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.HR_NONRUN_ASACT dependencies on PER_PERIODS_OF_SERVICE

Line 1419: INDEX(pos PER_PERIODS_OF_SERVICE_N3)

1415: itpflg varchar2
1416: ) is
1417: select /*+ ORDERED
1418: INDEX(pa2 PAY_PAYROLL_ACTIONS_N5)
1419: INDEX(pos PER_PERIODS_OF_SERVICE_N3)
1420: INDEX(as1 PER_ASSIGNMENTS_N4)
1421: INDEX(as2 PER_ASSIGNMENTS_F_PK)
1422: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)
1423: index(opm PAY_ORG_PAYMENT_METHODS_F_PK)

Line 1433: per_periods_of_service pos,

1429: from pay_payroll_actions pa1,
1430: pay_payroll_actions pa2,
1431: pay_action_classifications pcl,
1432: pay_population_ranges pop,
1433: per_periods_of_service pos,
1434: per_all_assignments_f as1,
1435: pay_assignment_actions act,
1436: per_all_assignments_f as2,
1437: pay_pre_payments ppp,

Line 1496: INDEX(pos PER_PERIODS_OF_SERVICE_N3)

1492: itpflg varchar2
1493: ) is
1494: select /*+ ORDERED
1495: INDEX(pa2 PAY_PAYROLL_ACTIONS_N5)
1496: INDEX(pos PER_PERIODS_OF_SERVICE_N3)
1497: INDEX(as1 PER_ASSIGNMENTS_N4)
1498: INDEX(as2 PER_ASSIGNMENTS_F_PK)
1499: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)
1500: index(opm PAY_ORG_PAYMENT_METHODS_F_PK)

Line 1509: per_periods_of_service pos,

1505: ppp.pre_payment_id
1506: from pay_payroll_actions pa1,
1507: pay_payroll_actions pa2,
1508: pay_action_classifications pcl,
1509: per_periods_of_service pos,
1510: per_all_assignments_f as1,
1511: pay_assignment_actions act,
1512: per_all_assignments_f as2,
1513: pay_pre_payments ppp,

Line 1569: INDEX(pos PER_PERIODS_OF_SERVICE_N3)

1565: itpflg varchar2
1566: ) is
1567: select /*+ ORDERED
1568: INDEX(pa2 PAY_PAYROLL_ACTIONS_PK)
1569: INDEX(pos PER_PERIODS_OF_SERVICE_N3)
1570: INDEX(as1 PER_ASSIGNMENTS_N4)
1571: INDEX(as2 PER_ASSIGNMENTS_F_PK)
1572: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)
1573: index(opm PAY_ORG_PAYMENT_METHODS_F_PK)

Line 1581: per_periods_of_service pos,

1577: act.tax_unit_id,
1578: ppp.pre_payment_id
1579: from pay_payroll_actions pa1,
1580: pay_population_ranges pop,
1581: per_periods_of_service pos,
1582: per_all_assignments_f as1,
1583: pay_assignment_actions act,
1584: pay_payroll_actions pa2,
1585: pay_action_classifications pcl,

Line 1718: per_periods_of_service pos,

1714: act.tax_unit_id
1715: from pay_payroll_actions pa1,
1716: pay_payroll_actions pa2,
1717: pay_action_classifications pcl,
1718: per_periods_of_service pos,
1719: per_all_assignments_f as1,
1720: pay_assignment_actions act
1721: where pa1.payroll_action_id = pactid
1722: and pa2.effective_date between

Line 1782: per_periods_of_service pos,

1778: from pay_payroll_actions pa1,
1779: pay_payroll_actions pa2,
1780: pay_action_classifications pcl,
1781: pay_population_ranges pop,
1782: per_periods_of_service pos,
1783: per_all_assignments_f as1,
1784: pay_assignment_actions act
1785: where pa1.payroll_action_id = pactid
1786: and pa2.effective_date between

Line 2071: per_periods_of_service pos,

2067: from pay_payroll_actions pa1,
2068: pay_payroll_actions pa2,
2069: pay_action_classifications pcl,
2070: pay_population_ranges pop,
2071: per_periods_of_service pos,
2072: per_all_assignments_f as1,
2073: pay_assignment_actions act,
2074: pay_pre_payments ppp,
2075: per_all_assignments_f as2,

Line 2162: per_periods_of_service pos,

2158: as1.payroll_id
2159: from pay_payroll_actions pa1,
2160: pay_payroll_actions pa2,
2161: pay_action_classifications pcl,
2162: per_periods_of_service pos,
2163: per_all_assignments_f as1,
2164: pay_assignment_actions act,
2165: pay_pre_payments ppp,
2166: per_all_assignments_f as2,

Line 2237: index(pos PER_PERIODS_OF_SERVICE_N3)

2233: class varchar2
2234: ) is
2235: SELECT /*+ ORDERED
2236: index(pa2 PAY_PAYROLL_ACTIONS_PK)
2237: index(pos PER_PERIODS_OF_SERVICE_N3)
2238: index(as1 PER_ASSIGNMENTS_F_N4)
2239: index(act PAY_ASSIGNMENT_ACTIONS_N51)
2240: index(as2 PER_ASSIGNMENTS_F_PK)
2241: index(opm PAY_ORG_PAYMENT_METHODS_F_PK)

Line 2251: per_periods_of_service pos,

2247: pa1.assignment_set_id,
2248: as1.payroll_id
2249: from pay_payroll_actions pa1,
2250: pay_population_ranges pop,
2251: per_periods_of_service pos,
2252: per_all_assignments_f as1,
2253: pay_assignment_actions act,
2254: pay_payroll_actions pa2,
2255: pay_action_classifications pcl,

Line 2484: INDEX(pos PER_PERIODS_OF_SERVICE_N3)

2480: ptype number
2481: ) is
2482: select /*+ ORDERED
2483: INDEX(pa2 PAY_PAYROLL_ACTIONS_N5)
2484: INDEX(pos PER_PERIODS_OF_SERVICE_N3)
2485: INDEX(as1 PER_ASSIGNMENTS_N4)
2486: INDEX(as2 PER_ASSIGNMENTS_F_PK)
2487: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)
2488: index(opm PAY_ORG_PAYMENT_METHODS_F_PK)

Line 2498: per_periods_of_service pos,

2494: from pay_payroll_actions pa1,
2495: pay_payroll_actions pa2,
2496: pay_action_classifications pcl,
2497: pay_population_ranges pop,
2498: per_periods_of_service pos,
2499: per_all_assignments_f as1,
2500: pay_assignment_actions act,
2501: per_all_assignments_f as2,
2502: pay_pre_payments ppp,

Line 2573: INDEX(pos PER_PERIODS_OF_SERVICE_N3)

2569: ptype number
2570: ) is
2571: select /*+ ORDERED
2572: INDEX(pa2 PAY_PAYROLL_ACTIONS_N5)
2573: INDEX(pos PER_PERIODS_OF_SERVICE_N3)
2574: INDEX(as1 PER_ASSIGNMENTS_N4)
2575: INDEX(as2 PER_ASSIGNMENTS_F_PK)
2576: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)
2577: index(opm PAY_ORG_PAYMENT_METHODS_F_PK)

Line 2586: per_periods_of_service pos,

2582: ppp.pre_payment_id
2583: from pay_payroll_actions pa1,
2584: pay_payroll_actions pa2,
2585: pay_action_classifications pcl,
2586: per_periods_of_service pos,
2587: per_all_assignments_f as1,
2588: pay_assignment_actions act,
2589: per_all_assignments_f as2,
2590: pay_pre_payments ppp,

Line 2658: INDEX(pos PER_PERIODS_OF_SERVICE_N3)

2654: ptype number
2655: ) is
2656: select /*+ ORDERED
2657: INDEX(pa2 PAY_PAYROLL_ACTIONS_PK)
2658: INDEX(pos PER_PERIODS_OF_SERVICE_N3)
2659: INDEX(as1 PER_ASSIGNMENTS_N4)
2660: INDEX(as2 PER_ASSIGNMENTS_F_PK)
2661: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)
2662: index(opm PAY_ORG_PAYMENT_METHODS_F_PK)

Line 2670: per_periods_of_service pos,

2666: act.tax_unit_id,
2667: ppp.pre_payment_id
2668: from pay_payroll_actions pa1,
2669: pay_population_ranges pop,
2670: per_periods_of_service pos,
2671: per_all_assignments_f as1,
2672: pay_assignment_actions act,
2673: pay_payroll_actions pa2,
2674: pay_action_classifications pcl,

Line 2845: per_periods_of_service pos,

2841: from pay_payroll_actions pa1,
2842: pay_payroll_actions pa2,
2843: pay_action_classifications pcl,
2844: pay_population_ranges pop,
2845: per_periods_of_service pos,
2846: per_all_assignments_f as1,
2847: pay_assignment_actions act,
2848: per_all_assignments_f as2
2849: where pa1.payroll_action_id = pactid

Line 2917: per_periods_of_service pos,

2913: as1.primary_flag
2914: from pay_payroll_actions pa1,
2915: pay_payroll_actions pa2,
2916: pay_action_classifications pcl,
2917: per_periods_of_service pos,
2918: per_all_assignments_f as1,
2919: pay_assignment_actions act,
2920: per_all_assignments_f as2
2921: where pa1.payroll_action_id = pactid

Line 2974: index(pos PER_PERIODS_OF_SERVICE_N3)

2970: itpflg varchar2
2971: ) is
2972: select /*+ ORDERED
2973: index(pa2 PAY_PAYROLL_ACTIONS_PK)
2974: index(pos PER_PERIODS_OF_SERVICE_N3)
2975: index(act PAY_ASSIGNMENT_ACTIONS_N51)
2976: index(as1 PER_ASSIGNMENTS_F_N4)
2977: index(as2 PER_ASSIGNMENTS_F_PK)
2978: USE_NL(pos pop act as1 as2 pa2) */

Line 2987: per_periods_of_service pos,

2983: as1.effective_start_date,
2984: as1.primary_flag
2985: from pay_payroll_actions pa1,
2986: pay_population_ranges pop,
2987: per_periods_of_service pos,
2988: per_all_assignments_f as1,
2989: pay_assignment_actions act,
2990: pay_payroll_actions pa2,
2991: pay_action_classifications pcl,

Line 3159: per_periods_of_service pos,

3155: from pay_payroll_actions pa1,
3156: pay_payroll_actions pa2,
3157: pay_action_classifications pcl,
3158: pay_population_ranges pop,
3159: per_periods_of_service pos,
3160: per_all_assignments_f as1,
3161: pay_assignment_actions act,
3162: per_all_assignments_f as2
3163: where pa1.payroll_action_id = pactid

Line 3226: per_periods_of_service pos,

3222: act.tax_unit_id
3223: from pay_payroll_actions pa1,
3224: pay_payroll_actions pa2,
3225: pay_action_classifications pcl,
3226: per_periods_of_service pos,
3227: per_all_assignments_f as1,
3228: pay_assignment_actions act,
3229: per_all_assignments_f as2
3230: where pa1.payroll_action_id = pactid

Line 3280: index(pos PER_PERIODS_OF_SERVICE_N3)

3276: itpflg varchar2
3277: ) is
3278: select /*+ ORDERED
3279: index(pa2 PAY_PAYROLL_ACTIONS_PK)
3280: index(pos PER_PERIODS_OF_SERVICE_N3)
3281: index(as1 PER_ASSIGNMENTS_F_N4)
3282: index(act PAY_ASSIGNMENT_ACTIONS_N51)
3283: index(as2 PER_ASSIGNMENTS_F_PK)
3284: USE_NL(pos pop act pa2 as2 as1) */

Line 3290: per_periods_of_service pos,

3286: act.assignment_id,
3287: act.tax_unit_id
3288: from pay_payroll_actions pa1,
3289: pay_population_ranges pop,
3290: per_periods_of_service pos,
3291: per_all_assignments_f as1,
3292: pay_assignment_actions act,
3293: pay_payroll_actions pa2,
3294: pay_action_classifications pcl,

Line 3435: per_periods_of_service pos,

3431: from pay_payroll_actions pa1,
3432: pay_payroll_actions pa2,
3433: pay_action_classifications pcl,
3434: pay_population_ranges pop,
3435: per_periods_of_service pos,
3436: per_all_assignments_f as1,
3437: pay_assignment_actions act,
3438: per_all_assignments_f as2
3439: where pa1.payroll_action_id = pactid

Line 3573: per_periods_of_service pos,

3569: act.payroll_action_id
3570: from pay_payroll_actions pa1,
3571: pay_payroll_actions pa2,
3572: pay_action_classifications pcl,
3573: per_periods_of_service pos,
3574: per_all_assignments_f as1,
3575: pay_assignment_actions act,
3576: per_all_assignments_f as2
3577: where pa1.payroll_action_id = pactid

Line 3698: index(pos PER_PERIODS_OF_SERVICE_N3)

3694: itpflg varchar2
3695: ) is
3696: select /*+ ORDERED
3697: index(pa2 PAY_PAYROLL_ACTIONS_PK)
3698: index(pos PER_PERIODS_OF_SERVICE_N3)
3699: index(as1 PER_ASSIGNMENTS_F_N4)
3700: index(act PAY_ASSIGNMENT_ACTIONS_N51)
3701: index(as2 PER_ASSIGNMENTS_F_PK)
3702: USE_NL(pos pop act pa2 as2 as1) */

Line 3709: per_periods_of_service pos,

3705: act.tax_unit_id,
3706: act.payroll_action_id
3707: from pay_payroll_actions pa1,
3708: pay_population_ranges pop,
3709: per_periods_of_service pos,
3710: per_all_assignments_f as1,
3711: pay_assignment_actions act,
3712: pay_payroll_actions pa2,
3713: pay_action_classifications pcl,

Line 3931: per_periods_of_service pos,

3927: per_time_periods ptp,
3928: pay_payroll_actions pa2,
3929: pay_action_classifications pcl,
3930: pay_population_ranges pop,
3931: per_periods_of_service pos,
3932: per_all_assignments_f as1,
3933: pay_assignment_actions act,
3934: per_all_assignments_f as2
3935: where pa1.payroll_action_id = pactid

Line 3997: per_periods_of_service pos,

3993: pay_all_payrolls_f pay,
3994: per_time_periods ptp,
3995: pay_payroll_actions pa2,
3996: pay_action_classifications pcl,
3997: per_periods_of_service pos,
3998: per_all_assignments_f as1,
3999: pay_assignment_actions act,
4000: per_all_assignments_f as2
4001: where pa1.payroll_action_id = pactid

Line 4235: per_periods_of_service pos,

4231: from pay_payroll_actions pa,
4232: pay_payroll_actions pa2,
4233: pay_action_classifications pcl,
4234: pay_population_ranges pop,
4235: per_periods_of_service pos,
4236: per_all_assignments_f as2,
4237: pay_assignment_actions ac2,
4238: per_all_assignments_f as1
4239: where pa.payroll_action_id = pactid

Line 4304: per_periods_of_service pos,

4300: pa2.action_type
4301: from pay_payroll_actions pa,
4302: pay_payroll_actions pa2,
4303: pay_action_classifications pcl,
4304: per_periods_of_service pos,
4305: per_all_assignments_f as2,
4306: pay_assignment_actions ac2,
4307: per_all_assignments_f as1
4308: where pa.payroll_action_id = pactid

Line 4360: index(pos PER_PERIODS_OF_SERVICE_N3)

4356: itpflg varchar2
4357: ) is
4358: select /*+ ORDERED
4359: index(pa2 PAY_PAYROLL_ACTIONS_PK)
4360: index(pos PER_PERIODS_OF_SERVICE_N3)
4361: index(as2 PER_ASSIGNMENTS_F_N4)
4362: index(ac2 PAY_ASSIGNMENT_ACTIONS_N51)
4363: index(as1 PER_ASSIGNMENTS_F_PK)
4364: USE_NL(pos pop as1 as2) */

Line 4371: per_periods_of_service pos,

4367: ac2.tax_unit_id,
4368: pa2.action_type
4369: from pay_payroll_actions pa,
4370: pay_population_ranges pop,
4371: per_periods_of_service pos,
4372: per_all_assignments_f as2,
4373: pay_assignment_actions ac2,
4374: pay_payroll_actions pa2,
4375: pay_action_classifications pcl,

Line 4729: INDEX(pos PER_PERIODS_OF_SERVICE_N3)

4725: ptype number
4726: ) is
4727: select /*+ ORDERED
4728: INDEX(pa2 PAY_PAYROLL_ACTIONS_N5)
4729: INDEX(pos PER_PERIODS_OF_SERVICE_N3)
4730: INDEX(as1 PER_ASSIGNMENTS_N4)
4731: INDEX(as2 PER_ASSIGNMENTS_F_PK)
4732: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)
4733: index(opm PAY_ORG_PAYMENT_METHODS_F_PK)

Line 4743: per_periods_of_service pos,

4739: from pay_payroll_actions pa1,
4740: pay_payroll_actions pa2,
4741: pay_action_classifications pcl,
4742: pay_population_ranges pop,
4743: per_periods_of_service pos,
4744: per_all_assignments_f as1,
4745: pay_assignment_actions act,
4746: per_all_assignments_f as2,
4747: pay_pre_payments ppp,

Line 4818: INDEX(pos PER_PERIODS_OF_SERVICE_N3)

4814: ptype number
4815: ) is
4816: select /*+ ORDERED
4817: INDEX(pa2 PAY_PAYROLL_ACTIONS_N5)
4818: INDEX(pos PER_PERIODS_OF_SERVICE_N3)
4819: INDEX(as1 PER_ASSIGNMENTS_N4)
4820: INDEX(as2 PER_ASSIGNMENTS_F_PK)
4821: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)
4822: index(opm PAY_ORG_PAYMENT_METHODS_F_PK)

Line 4831: per_periods_of_service pos,

4827: ppp.pre_payment_id
4828: from pay_payroll_actions pa1,
4829: pay_payroll_actions pa2,
4830: pay_action_classifications pcl,
4831: per_periods_of_service pos,
4832: per_all_assignments_f as1,
4833: pay_assignment_actions act,
4834: per_all_assignments_f as2,
4835: pay_pre_payments ppp,

Line 4903: INDEX(pos PER_PERIODS_OF_SERVICE_N3)

4899: ptype number
4900: ) is
4901: select /*+ ORDERED
4902: INDEX(pa2 PAY_PAYROLL_ACTIONS_PK)
4903: INDEX(pos PER_PERIODS_OF_SERVICE_N3)
4904: INDEX(as1 PER_ASSIGNMENTS_N4)
4905: INDEX(as2 PER_ASSIGNMENTS_F_PK)
4906: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)
4907: index(opm PAY_ORG_PAYMENT_METHODS_F_PK)

Line 4915: per_periods_of_service pos,

4911: act.tax_unit_id,
4912: ppp.pre_payment_id
4913: from pay_payroll_actions pa1,
4914: pay_population_ranges pop,
4915: per_periods_of_service pos,
4916: per_all_assignments_f as1,
4917: pay_assignment_actions act,
4918: pay_payroll_actions pa2,
4919: pay_action_classifications pcl,