APPS.PER_ACCRUAL_CALC_FUNCTIONS dependencies on PAY_INPUT_VALUES_F

Line 476: -- index PAY_INPUT_VALUES_F_N50 is now used in hint to resolve bug 6621800

472: --
473: cursor c_get_contribution is
474: -- index hint applied for bug 4737028 to avoid bitmap conversion and usage of proper index
475: -- index PAY_ELEMENT_ENTRIES_F_N53 is now used in hint to resolve bug 5677610
476: -- index PAY_INPUT_VALUES_F_N50 is now used in hint to resolve bug 6621800
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

Line 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,

474: -- index hint applied for bug 4737028 to avoid bitmap conversion and usage of proper index
475: -- index PAY_ELEMENT_ENTRIES_F_N53 is now used in hint to resolve bug 5677610
476: -- index PAY_INPUT_VALUES_F_N50 is now used in hint to resolve bug 6621800
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,

Line 485: pay_input_values_f iv

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
489: and pev.input_value_id = ncr.input_value_id

Line 502: (select /*+ index(piv2 PAY_INPUT_VALUES_F_N50)*/ null -- bug6621800

498: and iv.input_value_id = ncr.input_value_id
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

Line 504: pay_input_values_f piv2

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
508: and pev1.effective_end_date = pev.effective_end_date

Line 622: pay_input_values_f piv,

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
626: and pee.assignment_id = p_assignment_id

Line 623: pay_input_values_f piv1,

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

Line 640: pay_input_values_f piv2

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
644: and pev2.effective_start_date = pev.effective_start_date