eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ACCRUAL_CALC_FUNCTIONS dependencies on PAY_ELEMENT_ENTRIES_F

Line 215: from pay_element_entries_f pee,

211: ,P_Calculation_Date IN Date) return Boolean is
212:
213: cursor c_enrolled is
214: select 1
215: from pay_element_entries_f pee,
216: pay_element_links_f pel,
217: pay_element_types_f pet
218: where pel.element_link_id = pee.element_link_id
219: and pel.element_type_id = pet.element_type_id

Line 474: -- index PAY_ELEMENT_ENTRIES_F_N53 is now used in hint to resolve bug 5677610

470: g_add_sub_entries g_add_subtract;
471: --
472: cursor c_get_contribution is
473: -- index hint applied for bug 4737028 to avoid bitmap conversion and usage of proper index
474: -- index PAY_ELEMENT_ENTRIES_F_N53 is now used in hint to resolve bug 5677610
475: -- index PAY_INPUT_VALUES_F_N50 is now used in hint to resolve bug 6621800
476:
477: select /*+ index(pee PAY_ELEMENT_ENTRIES_F_N53,iv PAY_INPUT_VALUES_F_N50 )*/ fnd_number.canonical_to_number(pev.screen_entry_value) amount,
478: -- Bug 4551666, bug6621800

Line 477: select /+ index(pee PAY_ELEMENT_ENTRIES_F_N53,iv PAY_INPUT_VALUES_F_N50 )/ fnd_number.canonical_to_number(pev.screen_entry_value) amount,

473: -- index hint applied for bug 4737028 to avoid bitmap conversion and usage of proper index
474: -- index PAY_ELEMENT_ENTRIES_F_N53 is now used in hint to resolve bug 5677610
475: -- index PAY_INPUT_VALUES_F_N50 is now used in hint to resolve bug 6621800
476:
477: select /*+ index(pee PAY_ELEMENT_ENTRIES_F_N53,iv PAY_INPUT_VALUES_F_N50 )*/ fnd_number.canonical_to_number(pev.screen_entry_value) amount,
478: -- Bug 4551666, bug6621800
479: ncr.add_or_subtract add_or_subtract
480: from pay_accrual_plans pap,
481: pay_net_calculation_rules ncr,

Line 482: pay_element_entries_f pee,

478: -- Bug 4551666, bug6621800
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

Line 610: select /+ index(pee PAY_ELEMENT_ENTRIES_F_N53)/ fnd_number.canonical_to_number(nvl(pev.screen_entry_value, 0)) carryover,

606: g_expiry_date1 g_effective_date;
607: --
608: cursor c_get_carryover is
609: -- index hint applied for bug 4737028 to avoid bitmap conversion and usage of proper index
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,

Line 618: pay_element_entries_f pee

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
620: and pee.assignment_id = p_assignment_id
621: and pee.element_entry_id = pev.element_entry_id
622: and pee.element_entry_id = pev1.element_entry_id