APPS.PER_UTILITY_FUNCTIONS dependencies on PAY_INPUT_VALUES_F

Line 429: pay_input_values_f piv,

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

Line 467: pay_input_values_f piv,

463: cursor c_get_date is
464: select /*+ index(pee1 PAY_ELEMENT_ENTRIES_F_N53) use_nl(ncr)*/
465: nvl(min(pee1.effective_start_date), P_Accrual_Start_Date)
466: from
467: pay_input_values_f piv,
468: pay_net_calculation_rules ncr,
469: pay_accrual_plans pap,
470: pay_element_entries_f pee1,
471: pay_element_entries_f pee2

Line 585: pay_input_values_f piv,

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

Line 623: pay_input_values_f piv,

619: p_effective_date date) is
620: select /*+ index(pee1 PAY_ELEMENT_ENTRIES_F_N53)*/
621: distinct pee1.element_entry_id
622: from
623: pay_input_values_f piv,
624: pay_net_calculation_rules ncr,
625: pay_accrual_plans pap,
626: pay_element_entries_f pee1,
627: pay_element_entries_f pee2