APPS.PER_ACCRUAL_CALC_FUNCTIONS dependencies on PAY_ACCRUAL_PLANS

Line 179: from pay_accrual_plans

175: --
176: cursor c_accrual_plan_details is
177: select accrual_plan_element_type_id,
178: accrual_formula_id
179: from pay_accrual_plans
180: where accrual_plan_id = p_plan_id;
181:
182: l_proc varchar2(72) := g_package||'Get_Accrual_Plan';
183: l_accrual_plan_rec g_accrual_plan_rec_type;

Line 384: (select 'Y' from pay_accrual_plans

380: and ncr.absence_attendance_type_id =
381: abt.absence_attendance_type_id)
382: OR (ncr.absence_attendance_type_id is null
383: and exists
384: (select 'Y' from pay_accrual_plans
385: where accrual_plan_id = ncr.accrual_plan_id
386: and ncr.input_value_id = pto_input_value_id)
387: ))
388: and exists (select 'Y'

Line 480: from pay_accrual_plans pap,

476:
477: select /*+ index(pee PAY_ELEMENT_ENTRIES_F_N53,iv PAY_INPUT_VALUES_F_N50 )*/ fnd_number.canonical_to_number(pev.screen_entry_value) amount,
478: -- Bug 4551666, bug6621800
479: ncr.add_or_subtract add_or_subtract
480: from pay_accrual_plans pap,
481: pay_net_calculation_rules ncr,
482: pay_element_entries_f pee,
483: pay_element_entry_values_f pev,
484: pay_input_values_f iv

Line 613: from pay_accrual_plans pap,

609: -- index hint applied for bug 4737028 to avoid bitmap conversion and usage of proper index
610: select /*+ index(pee PAY_ELEMENT_ENTRIES_F_N53)*/ fnd_number.canonical_to_number(nvl(pev.screen_entry_value, 0)) carryover,
611: fnd_date.canonical_to_date(nvl(pev1.screen_entry_value,
612: p_calculation_date)) expiry_date
613: from pay_accrual_plans pap,
614: pay_element_entry_values_f pev,
615: pay_element_entry_values_f pev1,
616: pay_input_values_f piv,
617: pay_input_values_f piv1,

Line 836: from pay_accrual_plans

832: l_defined_balance_id number;
833:
834: cursor c_get_balance is
835: select defined_balance_id
836: from pay_accrual_plans
837: where accrual_plan_id = p_plan_id;
838:
839: begin
840: --