[Home] [Help]
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)
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,
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)
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,
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)
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,
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
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
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,
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,
2241: pa1.assignment_set_id,
2242: as1.payroll_id
2243: from pay_payroll_actions pa1,
2244: pay_population_ranges pop,
2245: per_periods_of_service pos,
2246: per_all_assignments_f as1,
2247: pay_assignment_actions act,
2248: pay_payroll_actions pa2,
2249: pay_action_classifications pcl,
2474: ptype number
2475: ) is
2476: select /*+ ORDERED
2477: INDEX(pa2 PAY_PAYROLL_ACTIONS_N5)
2478: INDEX(pos PER_PERIODS_OF_SERVICE_N3)
2479: INDEX(as1 PER_ASSIGNMENTS_N4)
2480: INDEX(as2 PER_ASSIGNMENTS_F_PK)
2481: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)
2482: index(opm PAY_ORG_PAYMENT_METHODS_F_PK)
2488: from pay_payroll_actions pa1,
2489: pay_payroll_actions pa2,
2490: pay_action_classifications pcl,
2491: pay_population_ranges pop,
2492: per_periods_of_service pos,
2493: per_all_assignments_f as1,
2494: pay_assignment_actions act,
2495: per_all_assignments_f as2,
2496: pay_pre_payments ppp,
2563: ptype number
2564: ) is
2565: select /*+ ORDERED
2566: INDEX(pa2 PAY_PAYROLL_ACTIONS_N5)
2567: INDEX(pos PER_PERIODS_OF_SERVICE_N3)
2568: INDEX(as1 PER_ASSIGNMENTS_N4)
2569: INDEX(as2 PER_ASSIGNMENTS_F_PK)
2570: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)
2571: index(opm PAY_ORG_PAYMENT_METHODS_F_PK)
2576: ppp.pre_payment_id
2577: from pay_payroll_actions pa1,
2578: pay_payroll_actions pa2,
2579: pay_action_classifications pcl,
2580: per_periods_of_service pos,
2581: per_all_assignments_f as1,
2582: pay_assignment_actions act,
2583: per_all_assignments_f as2,
2584: pay_pre_payments ppp,
2648: ptype number
2649: ) is
2650: select /*+ ORDERED
2651: INDEX(pa2 PAY_PAYROLL_ACTIONS_PK)
2652: INDEX(pos PER_PERIODS_OF_SERVICE_N3)
2653: INDEX(as1 PER_ASSIGNMENTS_N4)
2654: INDEX(as2 PER_ASSIGNMENTS_F_PK)
2655: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)
2656: index(opm PAY_ORG_PAYMENT_METHODS_F_PK)
2660: act.tax_unit_id,
2661: ppp.pre_payment_id
2662: from pay_payroll_actions pa1,
2663: pay_population_ranges pop,
2664: per_periods_of_service pos,
2665: per_all_assignments_f as1,
2666: pay_assignment_actions act,
2667: pay_payroll_actions pa2,
2668: pay_action_classifications pcl,
2835: from pay_payroll_actions pa1,
2836: pay_payroll_actions pa2,
2837: pay_action_classifications pcl,
2838: pay_population_ranges pop,
2839: per_periods_of_service pos,
2840: per_all_assignments_f as1,
2841: pay_assignment_actions act,
2842: per_all_assignments_f as2
2843: where pa1.payroll_action_id = pactid
2907: as1.primary_flag
2908: from pay_payroll_actions pa1,
2909: pay_payroll_actions pa2,
2910: pay_action_classifications pcl,
2911: per_periods_of_service pos,
2912: per_all_assignments_f as1,
2913: pay_assignment_actions act,
2914: per_all_assignments_f as2
2915: where pa1.payroll_action_id = pactid
2964: itpflg varchar2
2965: ) is
2966: select /*+ ORDERED
2967: index(pa2 PAY_PAYROLL_ACTIONS_PK)
2968: index(pos PER_PERIODS_OF_SERVICE_N3)
2969: index(act PAY_ASSIGNMENT_ACTIONS_N51)
2970: index(as1 PER_ASSIGNMENTS_F_N4)
2971: index(as2 PER_ASSIGNMENTS_F_PK)
2972: USE_NL(pos pop act as1 as2 pa2) */
2977: as1.effective_start_date,
2978: as1.primary_flag
2979: from pay_payroll_actions pa1,
2980: pay_population_ranges pop,
2981: per_periods_of_service pos,
2982: per_all_assignments_f as1,
2983: pay_assignment_actions act,
2984: pay_payroll_actions pa2,
2985: pay_action_classifications pcl,
3148: from pay_payroll_actions pa1,
3149: pay_payroll_actions pa2,
3150: pay_action_classifications pcl,
3151: pay_population_ranges pop,
3152: per_periods_of_service pos,
3153: per_all_assignments_f as1,
3154: pay_assignment_actions act,
3155: per_all_assignments_f as2
3156: where pa1.payroll_action_id = pactid
3214: act.tax_unit_id
3215: from pay_payroll_actions pa1,
3216: pay_payroll_actions pa2,
3217: pay_action_classifications pcl,
3218: per_periods_of_service pos,
3219: per_all_assignments_f as1,
3220: pay_assignment_actions act,
3221: per_all_assignments_f as2
3222: where pa1.payroll_action_id = pactid
3268: itpflg varchar2
3269: ) is
3270: select /*+ ORDERED
3271: index(pa2 PAY_PAYROLL_ACTIONS_PK)
3272: index(pos PER_PERIODS_OF_SERVICE_N3)
3273: index(as1 PER_ASSIGNMENTS_F_N4)
3274: index(act PAY_ASSIGNMENT_ACTIONS_N51)
3275: index(as2 PER_ASSIGNMENTS_F_PK)
3276: USE_NL(pos pop act pa2 as2 as1) */
3278: act.assignment_id,
3279: act.tax_unit_id
3280: from pay_payroll_actions pa1,
3281: pay_population_ranges pop,
3282: per_periods_of_service pos,
3283: per_all_assignments_f as1,
3284: pay_assignment_actions act,
3285: pay_payroll_actions pa2,
3286: pay_action_classifications pcl,
3423: from pay_payroll_actions pa1,
3424: pay_payroll_actions pa2,
3425: pay_action_classifications pcl,
3426: pay_population_ranges pop,
3427: per_periods_of_service pos,
3428: per_all_assignments_f as1,
3429: pay_assignment_actions act,
3430: per_all_assignments_f as2
3431: where pa1.payroll_action_id = pactid
3561: act.payroll_action_id
3562: from pay_payroll_actions pa1,
3563: pay_payroll_actions pa2,
3564: pay_action_classifications pcl,
3565: per_periods_of_service pos,
3566: per_all_assignments_f as1,
3567: pay_assignment_actions act,
3568: per_all_assignments_f as2
3569: where pa1.payroll_action_id = pactid
3686: itpflg varchar2
3687: ) is
3688: select /*+ ORDERED
3689: index(pa2 PAY_PAYROLL_ACTIONS_PK)
3690: index(pos PER_PERIODS_OF_SERVICE_N3)
3691: index(as1 PER_ASSIGNMENTS_F_N4)
3692: index(act PAY_ASSIGNMENT_ACTIONS_N51)
3693: index(as2 PER_ASSIGNMENTS_F_PK)
3694: USE_NL(pos pop act pa2 as2 as1) */
3697: act.tax_unit_id,
3698: act.payroll_action_id
3699: from pay_payroll_actions pa1,
3700: pay_population_ranges pop,
3701: per_periods_of_service pos,
3702: per_all_assignments_f as1,
3703: pay_assignment_actions act,
3704: pay_payroll_actions pa2,
3705: pay_action_classifications pcl,
3919: per_time_periods ptp,
3920: pay_payroll_actions pa2,
3921: pay_action_classifications pcl,
3922: pay_population_ranges pop,
3923: per_periods_of_service pos,
3924: per_all_assignments_f as1,
3925: pay_assignment_actions act,
3926: per_all_assignments_f as2
3927: where pa1.payroll_action_id = pactid
3985: pay_all_payrolls_f pay,
3986: per_time_periods ptp,
3987: pay_payroll_actions pa2,
3988: pay_action_classifications pcl,
3989: per_periods_of_service pos,
3990: per_all_assignments_f as1,
3991: pay_assignment_actions act,
3992: per_all_assignments_f as2
3993: where pa1.payroll_action_id = pactid
4222: from pay_payroll_actions pa,
4223: pay_payroll_actions pa2,
4224: pay_action_classifications pcl,
4225: pay_population_ranges pop,
4226: per_periods_of_service pos,
4227: per_all_assignments_f as2,
4228: pay_assignment_actions ac2,
4229: per_all_assignments_f as1
4230: where pa.payroll_action_id = pactid
4290: pa2.action_type
4291: from pay_payroll_actions pa,
4292: pay_payroll_actions pa2,
4293: pay_action_classifications pcl,
4294: per_periods_of_service pos,
4295: per_all_assignments_f as2,
4296: pay_assignment_actions ac2,
4297: per_all_assignments_f as1
4298: where pa.payroll_action_id = pactid
4346: itpflg varchar2
4347: ) is
4348: select /*+ ORDERED
4349: index(pa2 PAY_PAYROLL_ACTIONS_PK)
4350: index(pos PER_PERIODS_OF_SERVICE_N3)
4351: index(as2 PER_ASSIGNMENTS_F_N4)
4352: index(ac2 PAY_ASSIGNMENT_ACTIONS_N51)
4353: index(as1 PER_ASSIGNMENTS_F_PK)
4354: USE_NL(pos pop as1 as2) */
4357: ac2.tax_unit_id,
4358: pa2.action_type
4359: from pay_payroll_actions pa,
4360: pay_population_ranges pop,
4361: per_periods_of_service pos,
4362: per_all_assignments_f as2,
4363: pay_assignment_actions ac2,
4364: pay_payroll_actions pa2,
4365: pay_action_classifications pcl,
4710: ptype number
4711: ) is
4712: select /*+ ORDERED
4713: INDEX(pa2 PAY_PAYROLL_ACTIONS_N5)
4714: INDEX(pos PER_PERIODS_OF_SERVICE_N3)
4715: INDEX(as1 PER_ASSIGNMENTS_N4)
4716: INDEX(as2 PER_ASSIGNMENTS_F_PK)
4717: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)
4718: index(opm PAY_ORG_PAYMENT_METHODS_F_PK)
4724: from pay_payroll_actions pa1,
4725: pay_payroll_actions pa2,
4726: pay_action_classifications pcl,
4727: pay_population_ranges pop,
4728: per_periods_of_service pos,
4729: per_all_assignments_f as1,
4730: pay_assignment_actions act,
4731: per_all_assignments_f as2,
4732: pay_pre_payments ppp,
4799: ptype number
4800: ) is
4801: select /*+ ORDERED
4802: INDEX(pa2 PAY_PAYROLL_ACTIONS_N5)
4803: INDEX(pos PER_PERIODS_OF_SERVICE_N3)
4804: INDEX(as1 PER_ASSIGNMENTS_N4)
4805: INDEX(as2 PER_ASSIGNMENTS_F_PK)
4806: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)
4807: index(opm PAY_ORG_PAYMENT_METHODS_F_PK)
4812: ppp.pre_payment_id
4813: from pay_payroll_actions pa1,
4814: pay_payroll_actions pa2,
4815: pay_action_classifications pcl,
4816: per_periods_of_service pos,
4817: per_all_assignments_f as1,
4818: pay_assignment_actions act,
4819: per_all_assignments_f as2,
4820: pay_pre_payments ppp,
4884: ptype number
4885: ) is
4886: select /*+ ORDERED
4887: INDEX(pa2 PAY_PAYROLL_ACTIONS_PK)
4888: INDEX(pos PER_PERIODS_OF_SERVICE_N3)
4889: INDEX(as1 PER_ASSIGNMENTS_N4)
4890: INDEX(as2 PER_ASSIGNMENTS_F_PK)
4891: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)
4892: index(opm PAY_ORG_PAYMENT_METHODS_F_PK)
4896: act.tax_unit_id,
4897: ppp.pre_payment_id
4898: from pay_payroll_actions pa1,
4899: pay_population_ranges pop,
4900: per_periods_of_service pos,
4901: per_all_assignments_f as1,
4902: pay_assignment_actions act,
4903: pay_payroll_actions pa2,
4904: pay_action_classifications pcl,