GET_ENRT_DTLS
This formula function can be used to fetch information regarding key dates relevant for an accrual plan enrollment whose start date is earlier than the effective date.
Mandatory Contexts
- PERSON_ID
- HR_ASSIGNMENT_ID
- EFFECTIVE_DATE
- LEGISLATIVE_DATA_GROUP_ID
Parameters
Parameter name | Data Type | Description |
---|---|---|
p_plan_name | Character | The name of the accrual plan for which enrollment information is required |
p_enrt_st_dt | Date | Out parameter – Start date of enrollment |
p_enrt_end_dt | Date | Out parameter – End date of enrollment |
p_last_accrual_run | Date | Out parameter – Last date as of which accrual has been calculated. |
Data Returned
The function returns a value ‘1’ if data is found and ‘0’ if no data is found.