DBA Data[Home] [Help]

APPS.PER_DISPLAY_ACCRUAL_BALANCE dependencies on PAY_ACCRUAL_PLANS_TL

Line 72: ,pay_accrual_plans_tl pap_tl /* 14387376 */

68: FROM pay_accrual_plans pap
69: ,pay_element_types_f pet
70: ,pay_element_links_f pel
71: ,pay_element_entries_f pee
72: ,pay_accrual_plans_tl pap_tl /* 14387376 */
73: WHERE
74: pee.assignment_id = p_assignment_id
75: AND
76: pet.ELEMENT_TYPE_ID=p_element_type_id

Line 284: ,pay_accrual_plans_tl pap_tl /* 14387376 */

280: pap_v.information1, /* 4767298 */
281: pap_v.information_Category /* 4767298 */
282: FROM
283: PAY_VIEW_ACCRUAL_PLANS_V pap_v
284: ,pay_accrual_plans_tl pap_tl /* 14387376 */
285: WHERE pap_v.ASSIGNMENT_ID = p_assignment_id
286: AND pap_v.accrual_plan_id = pap_tl.accrual_plan_id
287: AND pap_tl.LANGUAGE(+) = userenv('LANG')
288: AND p_evaluation_date BETWEEN pap_v.ASG_EFFECTIVE_START_DATE AND pap_v.ASG_EFFECTIVE_END_DATE