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_UTILITY_FUNCTIONS dependencies on PAY_ELEMENT_ENTRIES_F

Line 414: 1. Moved pay_element_entries_f pee1 to second last

410: l_result number;
411: /*
412: Changes done for Bug 3183291
413: ----------------------------
414: 1. Moved pay_element_entries_f pee1 to second last
415: 2. Driving the join to pay_net_calculation_rules through the
416: input_value_id (PAY_NET_CALCULATION_RULES_N3) instead of
417: ncr.accrual_plan_id (PAY_NET_CALCULATION_RULES_FK1) which is more selective
418: 3. By disabling the Primary Key join to the table the query can be driven off the

Line 433: pay_element_entries_f pee1, -- Change (1)

429: pay_input_values_f piv,
430: pay_net_calculation_rules ncr,
431: pay_accrual_plans pap,
432: pay_element_links_f pel2,
433: pay_element_entries_f pee1, -- Change (1)
434: pay_element_entries_f pee2
435: where pee1.element_link_id = pel1.element_link_id
436: and pel1.element_type_id = piv.element_type_id
437: and piv.input_value_id = ncr.input_value_id

Line 434: pay_element_entries_f pee2

430: pay_net_calculation_rules ncr,
431: pay_accrual_plans pap,
432: pay_element_links_f pel2,
433: pay_element_entries_f pee1, -- Change (1)
434: pay_element_entries_f pee2
435: where pee1.element_link_id = pel1.element_link_id
436: and pel1.element_type_id = piv.element_type_id
437: and piv.input_value_id = ncr.input_value_id
438: and ncr.accrual_plan_id + 0 = pap.accrual_plan_id -- Change (2)

Line 464: select /+ index(pee1 PAY_ELEMENT_ENTRIES_F_N53) use_nl(ncr)/

460: );
461: */
462: -- fix for the bug 5645232
463: cursor c_get_date is
464: select /*+ index(pee1 PAY_ELEMENT_ENTRIES_F_N53) use_nl(ncr)*/
465: nvl(min(pee1.effective_start_date), P_Accrual_Start_Date)
466: from
467: pay_input_values_f piv,
468: pay_net_calculation_rules ncr,

Line 470: pay_element_entries_f pee1,

466: from
467: pay_input_values_f piv,
468: pay_net_calculation_rules ncr,
469: pay_accrual_plans pap,
470: pay_element_entries_f pee1,
471: pay_element_entries_f pee2
472: where
473: pee1.element_type_id = piv.element_type_id
474: and piv.input_value_id = ncr.input_value_id

Line 471: pay_element_entries_f pee2

467: pay_input_values_f piv,
468: pay_net_calculation_rules ncr,
469: pay_accrual_plans pap,
470: pay_element_entries_f pee1,
471: pay_element_entries_f pee2
472: where
473: pee1.element_type_id = piv.element_type_id
474: and piv.input_value_id = ncr.input_value_id
475: and ncr.accrual_plan_id +0 = pap.accrual_plan_id

Line 501: from pay_element_entries_f pee,

497: );
498: -- end of bug 5645232
499: cursor c_check_balance_exists is
500: select 1
501: from pay_element_entries_f pee,
502: pay_element_links_f pel,
503: pay_accrual_plans pap
504: where pap.accrual_plan_id = p_accrual_plan_id
505: and pee.assignment_id = p_assignment_id

Line 571: 1. Moved pay_element_entries_f pee1 to second last

567:
568: /*
569: Changes done for Bug 3183291
570: ----------------------------
571: 1. Moved pay_element_entries_f pee1 to second last
572: 2. Driving the join to pay_net_calculation_rules through the
573: input_value_id (PAY_NET_CALCULATION_RULES_N3) instead of
574: ncr.accrual_plan_id (PAY_NET_CALCULATION_RULES_FK1) which is more selective
575: 3. Very poor filter so disabled to drive of the source_id which is more selective

Line 589: pay_element_entries_f pee1, -- Change (1)

585: pay_input_values_f piv,
586: pay_net_calculation_rules ncr,
587: pay_accrual_plans pap,
588: pay_element_links_f pel2,
589: pay_element_entries_f pee1, -- Change (1)
590: pay_element_entries_f pee2
591: where pee1.element_link_id = pel1.element_link_id
592: and pel1.element_type_id = piv.element_type_id
593: and piv.input_value_id = ncr.input_value_id

Line 590: pay_element_entries_f pee2

586: pay_net_calculation_rules ncr,
587: pay_accrual_plans pap,
588: pay_element_links_f pel2,
589: pay_element_entries_f pee1, -- Change (1)
590: pay_element_entries_f pee2
591: where pee1.element_link_id = pel1.element_link_id
592: and pel1.element_type_id = piv.element_type_id
593: and piv.input_value_id = ncr.input_value_id
594: and ncr.accrual_plan_id + 0 = pap.accrual_plan_id -- Change (2)

Line 620: select /+ index(pee1 PAY_ELEMENT_ENTRIES_F_N53)/

616: */
617: -- fix for the bug 5645232
618: cursor c_get_element (p_entry_id number,
619: p_effective_date date) is
620: select /*+ index(pee1 PAY_ELEMENT_ENTRIES_F_N53)*/
621: distinct pee1.element_entry_id
622: from
623: pay_input_values_f piv,
624: pay_net_calculation_rules ncr,

Line 626: pay_element_entries_f pee1,

622: from
623: pay_input_values_f piv,
624: pay_net_calculation_rules ncr,
625: pay_accrual_plans pap,
626: pay_element_entries_f pee1,
627: pay_element_entries_f pee2
628: where
629: pee1.element_type_id = piv.element_type_id
630: and piv.input_value_id = ncr.input_value_id

Line 627: pay_element_entries_f pee2

623: pay_input_values_f piv,
624: pay_net_calculation_rules ncr,
625: pay_accrual_plans pap,
626: pay_element_entries_f pee1,
627: pay_element_entries_f pee2
628: where
629: pee1.element_type_id = piv.element_type_id
630: and piv.input_value_id = ncr.input_value_id
631: and ncr.accrual_plan_id +0 = pap.accrual_plan_id