APPS.PER_UTILITY_FUNCTIONS dependencies on PAY_ELEMENT_LINKS_F

Line 428: from pay_element_links_f pel1,

424: */
425: /* modified the following cursor to improve performance
426: cursor c_get_date is
427: select nvl(min(pee1.effective_start_date), P_Accrual_Start_Date)
428: from pay_element_links_f pel1,
429: pay_input_values_f piv,
430: pay_net_calculation_rules ncr,
431: pay_accrual_plans pap,
432: pay_element_links_f pel2,

Line 432: pay_element_links_f pel2,

428: from pay_element_links_f pel1,
429: pay_input_values_f piv,
430: pay_net_calculation_rules ncr,
431: pay_accrual_plans pap,
432: pay_element_links_f pel2,
433: pay_element_entries_f pee1, -- Change (1)
434: pay_element_entries_f pee2
435: where pee1.element_link_id = pel1.element_link_id
436: and pel1.element_type_id = piv.element_type_id

Line 502: pay_element_links_f pel,

498: -- end of bug 5645232
499: cursor c_check_balance_exists is
500: select 1
501: from pay_element_entries_f pee,
502: pay_element_links_f pel,
503: pay_accrual_plans pap
504: where pap.accrual_plan_id = p_accrual_plan_id
505: and pee.assignment_id = p_assignment_id
506: and pap.accrual_plan_element_type_id = pel.element_type_id

Line 584: from pay_element_links_f pel1,

580: modified the cursor to improve performance
581: cursor c_get_element (p_entry_id number,
582: p_effective_date date) is
583: select distinct pee1.element_entry_id
584: from pay_element_links_f pel1,
585: pay_input_values_f piv,
586: pay_net_calculation_rules ncr,
587: pay_accrual_plans pap,
588: pay_element_links_f pel2,

Line 588: pay_element_links_f pel2,

584: from pay_element_links_f pel1,
585: pay_input_values_f piv,
586: pay_net_calculation_rules ncr,
587: pay_accrual_plans pap,
588: pay_element_links_f pel2,
589: pay_element_entries_f pee1, -- Change (1)
590: pay_element_entries_f pee2
591: where pee1.element_link_id = pel1.element_link_id
592: and pel1.element_type_id = piv.element_type_id