APPS.PER_UTILITY_FUNCTIONS dependencies on PAY_ELEMENT_LINKS_F

Line 524: from pay_element_links_f pel1,

520: */
521: /* modified the following cursor to improve performance
522: cursor c_get_date is
523: select nvl(min(pee1.effective_start_date), P_Accrual_Start_Date)
524: from pay_element_links_f pel1,
525: pay_input_values_f piv,
526: pay_net_calculation_rules ncr,
527: pay_accrual_plans pap,
528: pay_element_links_f pel2,

Line 528: pay_element_links_f pel2,

524: from pay_element_links_f pel1,
525: pay_input_values_f piv,
526: pay_net_calculation_rules ncr,
527: pay_accrual_plans pap,
528: pay_element_links_f pel2,
529: pay_element_entries_f pee1, -- Change (1)
530: pay_element_entries_f pee2
531: where pee1.element_link_id = pel1.element_link_id
532: and pel1.element_type_id = piv.element_type_id

Line 598: pay_element_links_f pel,

594: -- end of bug 5645232
595: cursor c_check_balance_exists is
596: select 1
597: from pay_element_entries_f pee,
598: pay_element_links_f pel,
599: pay_accrual_plans pap
600: where pap.accrual_plan_id = p_accrual_plan_id
601: and pee.assignment_id = p_assignment_id
602: and pap.accrual_plan_element_type_id = pel.element_type_id

Line 680: from pay_element_links_f pel1,

676: modified the cursor to improve performance
677: cursor c_get_element (p_entry_id number,
678: p_effective_date date) is
679: select distinct pee1.element_entry_id
680: from pay_element_links_f pel1,
681: pay_input_values_f piv,
682: pay_net_calculation_rules ncr,
683: pay_accrual_plans pap,
684: pay_element_links_f pel2,

Line 684: pay_element_links_f pel2,

680: from pay_element_links_f pel1,
681: pay_input_values_f piv,
682: pay_net_calculation_rules ncr,
683: pay_accrual_plans pap,
684: pay_element_links_f pel2,
685: pay_element_entries_f pee1, -- Change (1)
686: pay_element_entries_f pee2
687: where pee1.element_link_id = pel1.element_link_id
688: and pel1.element_type_id = piv.element_type_id