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 385: (select 'Y' from pay_accrual_plans

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

Line 481: from pay_accrual_plans pap,

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

Line 619: from pay_accrual_plans pap,

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

Line 855: from pay_accrual_plans

851: l_atd date; --added for bug 6418568
852:
853: cursor c_get_balance is
854: select defined_balance_id
855: from pay_accrual_plans
856: where accrual_plan_id = p_plan_id;
857:
858: --added for bug 6418568
859: cursor c_get_atd is