APPS.PER_UTILITY_FUNCTIONS dependencies on PAY_ACCRUAL_PLANS

Line 527: pay_accrual_plans pap,

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)
530: pay_element_entries_f pee2
531: where pee1.element_link_id = pel1.element_link_id

Line 565: pay_accrual_plans pap,

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
568: where
569: pee1.element_type_id = piv.element_type_id

Line 599: pay_accrual_plans pap

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
603: and pel.element_link_id = pee.element_link_id

Line 683: pay_accrual_plans pap,

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)
686: pay_element_entries_f pee2
687: where pee1.element_link_id = pel1.element_link_id

Line 721: pay_accrual_plans pap,

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
724: where
725: pee1.element_type_id = piv.element_type_id