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 510: 1. Moved pay_element_entries_f pee1 to second last

506: l_result number;
507: /*
508: Changes done for Bug 3183291
509: ----------------------------
510: 1. Moved pay_element_entries_f pee1 to second last
511: 2. Driving the join to pay_net_calculation_rules through the
512: input_value_id (PAY_NET_CALCULATION_RULES_N3) instead of
513: ncr.accrual_plan_id (PAY_NET_CALCULATION_RULES_FK1) which is more selective
514: 3. By disabling the Primary Key join to the table the query can be driven off the

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

525: pay_input_values_f piv,
526: pay_net_calculation_rules ncr,
527: pay_accrual_plans pap,
528: pay_element_links_f pel2,
529: pay_element_entries_f pee1, -- Change (1)
530: pay_element_entries_f pee2
531: where pee1.element_link_id = pel1.element_link_id
532: and pel1.element_type_id = piv.element_type_id
533: and piv.input_value_id = ncr.input_value_id

Line 530: pay_element_entries_f pee2

526: pay_net_calculation_rules ncr,
527: pay_accrual_plans pap,
528: pay_element_links_f pel2,
529: pay_element_entries_f pee1, -- Change (1)
530: pay_element_entries_f pee2
531: where pee1.element_link_id = pel1.element_link_id
532: and pel1.element_type_id = piv.element_type_id
533: and piv.input_value_id = ncr.input_value_id
534: and ncr.accrual_plan_id + 0 = pap.accrual_plan_id -- Change (2)

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

556: );
557: */
558: -- fix for the bug 5645232
559: cursor c_get_date is
560: select /*+ index(pee1 PAY_ELEMENT_ENTRIES_F_N53) use_nl(ncr)*/
561: nvl(min(pee1.effective_start_date), P_Accrual_Start_Date)
562: from
563: pay_input_values_f piv,
564: pay_net_calculation_rules ncr,

Line 566: pay_element_entries_f pee1,

562: from
563: pay_input_values_f piv,
564: pay_net_calculation_rules ncr,
565: pay_accrual_plans pap,
566: pay_element_entries_f pee1,
567: pay_element_entries_f pee2
568: where
569: pee1.element_type_id = piv.element_type_id
570: and piv.input_value_id = ncr.input_value_id

Line 567: pay_element_entries_f pee2

563: pay_input_values_f piv,
564: pay_net_calculation_rules ncr,
565: pay_accrual_plans pap,
566: pay_element_entries_f pee1,
567: pay_element_entries_f pee2
568: where
569: pee1.element_type_id = piv.element_type_id
570: and piv.input_value_id = ncr.input_value_id
571: and ncr.accrual_plan_id +0 = pap.accrual_plan_id

Line 597: from pay_element_entries_f pee,

593: );
594: -- end of bug 5645232
595: cursor c_check_balance_exists is
596: select 1
597: from pay_element_entries_f pee,
598: pay_element_links_f pel,
599: pay_accrual_plans pap
600: where pap.accrual_plan_id = p_accrual_plan_id
601: and pee.assignment_id = p_assignment_id

Line 667: 1. Moved pay_element_entries_f pee1 to second last

663:
664: /*
665: Changes done for Bug 3183291
666: ----------------------------
667: 1. Moved pay_element_entries_f pee1 to second last
668: 2. Driving the join to pay_net_calculation_rules through the
669: input_value_id (PAY_NET_CALCULATION_RULES_N3) instead of
670: ncr.accrual_plan_id (PAY_NET_CALCULATION_RULES_FK1) which is more selective
671: 3. Very poor filter so disabled to drive of the source_id which is more selective

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

681: pay_input_values_f piv,
682: pay_net_calculation_rules ncr,
683: pay_accrual_plans pap,
684: pay_element_links_f pel2,
685: pay_element_entries_f pee1, -- Change (1)
686: pay_element_entries_f pee2
687: where pee1.element_link_id = pel1.element_link_id
688: and pel1.element_type_id = piv.element_type_id
689: and piv.input_value_id = ncr.input_value_id

Line 686: pay_element_entries_f pee2

682: pay_net_calculation_rules ncr,
683: pay_accrual_plans pap,
684: pay_element_links_f pel2,
685: pay_element_entries_f pee1, -- Change (1)
686: pay_element_entries_f pee2
687: where pee1.element_link_id = pel1.element_link_id
688: and pel1.element_type_id = piv.element_type_id
689: and piv.input_value_id = ncr.input_value_id
690: and ncr.accrual_plan_id + 0 = pap.accrual_plan_id -- Change (2)

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

712: */
713: -- fix for the bug 5645232
714: cursor c_get_element (p_entry_id number,
715: p_effective_date date) is
716: select /*+ index(pee1 PAY_ELEMENT_ENTRIES_F_N53)*/
717: distinct pee1.element_entry_id
718: from
719: pay_input_values_f piv,
720: pay_net_calculation_rules ncr,

Line 722: pay_element_entries_f pee1,

718: from
719: pay_input_values_f piv,
720: pay_net_calculation_rules ncr,
721: pay_accrual_plans pap,
722: pay_element_entries_f pee1,
723: pay_element_entries_f pee2
724: where
725: pee1.element_type_id = piv.element_type_id
726: and piv.input_value_id = ncr.input_value_id

Line 723: pay_element_entries_f pee2

719: pay_input_values_f piv,
720: pay_net_calculation_rules ncr,
721: pay_accrual_plans pap,
722: pay_element_entries_f pee1,
723: pay_element_entries_f pee2
724: where
725: pee1.element_type_id = piv.element_type_id
726: and piv.input_value_id = ncr.input_value_id
727: and ncr.accrual_plan_id +0 = pap.accrual_plan_id