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.10.12020000.5 2012/11/16 10:14:32 lbodired 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 484: pay_element_entry_values_f pev,

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
487: and pee.assignment_id = p_assignment_id
488: and pee.element_entry_id = pev.element_entry_id

Line 503: from pay_element_entry_values_f pev1,

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

Line 620: pay_element_entry_values_f pev,

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

Line 621: pay_element_entry_values_f pev1,

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

Line 639: from pay_element_entry_values_f pev2,

635: and pee.element_type_id = piv.element_type_id
636: and pee.element_type_id = piv1.element_type_id
637: and exists
638: (select null
639: from pay_element_entry_values_f pev2,
640: pay_input_values_f piv2
641: where pev2.element_entry_id = pev.element_entry_id
642: and pev2.input_value_id = pap.co_date_input_value_id
643: and pev2.input_value_id = piv2.input_value_id