APPS.PAY_AU_TERMINATIONS dependencies on PAY_ELEMENT_LINKS_F

Line 702: pay_element_links_f pel,

698: ) is
699: select pap.accrual_plan_id
700: from pay_accrual_plans pap,
701: pay_element_entries_f pee,
702: pay_element_links_f pel,
703: pay_element_types_f pet
704: where pee.assignment_id = p_assignment_id
705: and p_effective_date between pee.effective_start_date and pee.effective_end_date
706: and p_effective_date between pel.effective_start_date and pel.effective_end_date /*Added for 8482224*/

Line 1040: pay_element_links_f pel,

1036: peev1.screen_entry_value,
1037: to_date(peev2.screen_entry_value,'YYYY/MM/DD HH24:MI:SS')
1038: from pay_element_types_f pet,
1039: pay_element_entries_f peef,
1040: pay_element_links_f pel,
1041: pay_input_values_f piv,
1042: pay_input_values_f piv1,
1043: pay_input_values_f piv2,
1044: pay_element_entry_values_f peev,

Line 1826: pay_element_links_f pel,

1822: ,p_plan_category VARCHAR2) IS
1823: SELECT pap.accrual_plan_id,pap.accrual_units_of_measure
1824: FROM pay_accrual_plans pap,
1825: pay_element_entries_f pee,
1826: pay_element_links_f pel,
1827: pay_element_types_f pet
1828: WHERE pee.assignment_id = p_assignment_id
1829: AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date
1830: AND pel.element_link_id = pee.element_link_id

Line 3119: pay_element_links_f pel,

3115: ) IS
3116: SELECT pap.accrual_plan_id,pap.accrual_units_of_measure
3117: FROM pay_accrual_plans pap,
3118: pay_element_entries_f pee,
3119: pay_element_links_f pel,
3120: pay_element_types_f pet
3121: WHERE pee.assignment_id = c_assignment_id
3122: AND c_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date
3123: AND pel.element_link_id = pee.element_link_id