APPS.PER_UTILITY_FUNCTIONS dependencies on PAY_INPUT_VALUES_F

Line 525: pay_input_values_f piv,

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,
529: pay_element_entries_f pee1, -- Change (1)

Line 563: pay_input_values_f piv,

559: cursor c_get_date is
560: select /*+ index(pee1 PAY_ELEMENT_ENTRIES_F_N53) use_nl(ncr)*/
561: nvl(min(pee1.effective_start_date), P_Accrual_Start_Date)
562: from
563: pay_input_values_f piv,
564: pay_net_calculation_rules ncr,
565: pay_accrual_plans pap,
566: pay_element_entries_f pee1,
567: pay_element_entries_f pee2

Line 681: pay_input_values_f piv,

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,
685: pay_element_entries_f pee1, -- Change (1)

Line 719: pay_input_values_f piv,

715: p_effective_date date) is
716: select /*+ index(pee1 PAY_ELEMENT_ENTRIES_F_N53)*/
717: distinct pee1.element_entry_id
718: from
719: pay_input_values_f piv,
720: pay_net_calculation_rules ncr,
721: pay_accrual_plans pap,
722: pay_element_entries_f pee1,
723: pay_element_entries_f pee2