APPS.PER_ACCRUAL_CALC_FUNCTIONS dependencies on PAY_NET_CALCULATION_RULES

Line 8: Type g_add_subtract is table of pay_net_calculation_rules.add_or_subtract%Type

4: -- Start of fix 3222662
5: Type g_entry_value is table of
6: pay_element_entry_values_f.screen_entry_value%Type
7: index by binary_integer;
8: Type g_add_subtract is table of pay_net_calculation_rules.add_or_subtract%Type
9: index by binary_integer;
10: Type g_effective_date is table of date index by binary_integer;
11: -- End of 3222662
12: --

Line 376: pay_net_calculation_rules ncr

372: cursor c_get_total_absence is
373: select nvl(sum(nvl(abs.absence_days, abs.absence_hours)), 0)
374: from per_absence_attendances abs,
375: per_absence_attendance_types abt,
376: pay_net_calculation_rules ncr
377: where abs.absence_attendance_type_id =
378: abt.absence_attendance_type_id
379: and abt.input_value_id = ncr.input_value_id
380: and ((ncr.absence_attendance_type_id is not null

Line 399: pay_net_calculation_rules ncr

395: --
396: cursor c_get_abs_per_type is
397: select nvl(sum(nvl(abs.absence_days, abs.absence_hours)), 0)
398: from per_absence_attendances abs,
399: pay_net_calculation_rules ncr
400: where ncr.absence_attendance_type_id = p_absence_attendance_type_id
401: and ncr.absence_attendance_type_id = abs.absence_attendance_type_id
402: and exists (select 'Y'
403: from per_all_assignments_f paf

Line 482: pay_net_calculation_rules ncr,

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
486: where pap.accrual_plan_id = p_plan_id