APPS.PER_UTILITY_FUNCTIONS dependencies on PAY_ACCRUAL_PLANS

Line 431: pay_accrual_plans pap,

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

Line 469: pay_accrual_plans pap,

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
472: where
473: pee1.element_type_id = piv.element_type_id

Line 503: pay_accrual_plans pap

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

Line 587: pay_accrual_plans pap,

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

Line 625: pay_accrual_plans pap,

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
628: where
629: pee1.element_type_id = piv.element_type_id