APPS.PER_ACCRUAL_CALC_FUNCTIONS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 6: pay_element_entry_values_f.screen_entry_value%Type

2: /* $Header: peaclcal.pkb 120.6.12010000.3 2008/09/25 05:12:15 nshrikha ship $ */
3: --
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;

Line 483: pay_element_entry_values_f pev,

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
485: where pap.accrual_plan_id = p_plan_id
486: and pee.assignment_id = p_assignment_id
487: and pee.element_entry_id = pev.element_entry_id

Line 502: from pay_element_entry_values_f pev1,

498: and p_calculation_date between iv.effective_start_date and iv.effective_end_date
499: and pee.element_type_id = iv.element_type_id
500: and exists
501: (select /*+ index(piv2 PAY_INPUT_VALUES_F_N50)*/ null -- bug6621800
502: from pay_element_entry_values_f pev1,
503: pay_input_values_f piv2
504: where pev1.element_entry_id = pev.element_entry_id
505: and pev1.input_value_id = ncr.date_input_value_id
506: and pev1.effective_start_date = pev.effective_start_date

Line 614: pay_element_entry_values_f pev,

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,
618: pay_element_entries_f pee

Line 615: pay_element_entry_values_f pev1,

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,
618: pay_element_entries_f pee
619: where pap.accrual_plan_id = p_plan_id

Line 633: from pay_element_entry_values_f pev2,

629: and pee.element_type_id = piv.element_type_id
630: and pee.element_type_id = piv1.element_type_id
631: and exists
632: (select null
633: from pay_element_entry_values_f pev2,
634: pay_input_values_f piv2
635: where pev2.element_entry_id = pev.element_entry_id
636: and pev2.input_value_id = pap.co_date_input_value_id
637: and pev2.input_value_id = piv2.input_value_id