[Home] [Help]
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,
1438: pay_org_payment_methods_f opm
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,
1438: pay_org_payment_methods_f opm
1439: where pa1.payroll_action_id = pactid
1440: and pa2.consolidation_set_id +0 = pa1.consolidation_set_id
1471: and ac2.assignment_action_id = int.locking_action_id
1472: and ac2.pre_payment_id = ppp.pre_payment_id)
1473: and not exists (
1474: select null
1475: from per_all_assignments_f as3,
1476: pay_assignment_actions ac3
1477: where itpflg = 'N'
1478: and ac3.payroll_action_id = pa2.payroll_action_id
1479: and ac3.action_status not in ('C', 'S')
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,
1514: pay_org_payment_methods_f opm
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,
1514: pay_org_payment_methods_f opm
1515: where pa1.payroll_action_id = pactid
1516: and pa2.consolidation_set_id +0 = pa1.consolidation_set_id
1545: and ac2.assignment_action_id = int.locking_action_id
1546: and ac2.pre_payment_id = ppp.pre_payment_id)
1547: and not exists (
1548: select null
1549: from per_all_assignments_f as3,
1550: pay_assignment_actions ac3
1551: where itpflg = 'N'
1552: and ac3.payroll_action_id = pa2.payroll_action_id
1553: and ac3.action_status not in ('C', 'S')
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,
1586: per_all_assignments_f as2,
1582: per_all_assignments_f as1,
1583: pay_assignment_actions act,
1584: pay_payroll_actions pa2,
1585: pay_action_classifications pcl,
1586: per_all_assignments_f as2,
1587: pay_pre_payments ppp,
1588: pay_org_payment_methods_f opm
1589: where pa1.payroll_action_id = pactid
1590: and pa2.consolidation_set_id +0 = pa1.consolidation_set_id
1621: and ac2.assignment_action_id = int.locking_action_id
1622: and ac2.pre_payment_id = ppp.pre_payment_id)
1623: and not exists (
1624: select null
1625: from per_all_assignments_f as3,
1626: pay_assignment_actions ac3
1627: where itpflg = 'N'
1628: and ac3.payroll_action_id = pa2.payroll_action_id
1629: and ac3.action_status not in ('C', 'S')
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
1723: pa1.start_date and pa1.effective_date
1748: )
1749: and not exists (
1750: select /*+ ORDERED*/
1751: null
1752: from per_all_assignments_f as3,
1753: pay_assignment_actions ac3
1754: where itpflg = 'N'
1755: and ac3.payroll_action_id = pa2.payroll_action_id
1756: and ac3.action_status not in ( 'C', 'S')
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
1787: pa1.start_date and pa1.effective_date
1814: )
1815: and not exists (
1816: select /*+ ORDERED*/
1817: null
1818: from per_all_assignments_f as3,
1819: pay_assignment_actions ac3
1820: where itpflg = 'N'
1821: and ac3.payroll_action_id = pa2.payroll_action_id
1822: and ac3.action_status not in ( 'C', 'S')
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,
2076: pay_org_payment_methods_f opm
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,
2076: pay_org_payment_methods_f opm
2077: where pa1.payroll_action_id = pactid
2078: and pa2.consolidation_set_id +0 = pa1.consolidation_set_id
2079: and pa2.effective_date between
2122: )
2123: and not exists (
2124: select /*+ ORDERED*/
2125: null
2126: from per_all_assignments_f as3,
2127: pay_assignment_actions ac3
2128: where itpflg = 'N'
2129: and ac3.payroll_action_id = pa2.payroll_action_id
2130: and ac3.action_status not in ('C', 'S')
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,
2167: pay_org_payment_methods_f opm
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,
2167: pay_org_payment_methods_f opm
2168: where pa1.payroll_action_id = pactid
2169: and pa2.consolidation_set_id +0 = pa1.consolidation_set_id
2170: and pa2.effective_date between
2211: )
2212: and not exists (
2213: select /*+ ORDERED*/
2214: null
2215: from per_all_assignments_f as3,
2216: pay_assignment_actions ac3
2217: where itpflg = 'N'
2218: and ac3.payroll_action_id = pa2.payroll_action_id
2219: and ac3.action_status not in ('C', 'S')
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,
2250: pay_pre_payments ppp,
2247: pay_assignment_actions act,
2248: pay_payroll_actions pa2,
2249: pay_action_classifications pcl,
2250: pay_pre_payments ppp,
2251: per_all_assignments_f as2,
2252: pay_org_payment_methods_f opm
2253: where pa1.payroll_action_id = pactid
2254: and pa2.consolidation_set_id = pa1.consolidation_set_id /* moved +0, bug 6522667 */
2255: and pa2.effective_date between
2298: )
2299: and not exists (
2300: select /* Bug 6522667, moved ORDERED hint */
2301: null
2302: from per_all_assignments_f as3,
2303: pay_assignment_actions ac3
2304: where itpflg = 'N'
2305: and ac3.payroll_action_id = pa2.payroll_action_id
2306: and ac3.action_status not in ('C', 'S')
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,
2497: pay_org_payment_methods_f opm
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,
2497: pay_org_payment_methods_f opm
2498: where pa1.payroll_action_id = pactid
2499: and pa2.consolidation_set_id +0 = pa1.consolidation_set_id
2523: and (opm.org_payment_method_id = pa1.org_payment_method_id
2524: or pa1.org_payment_method_id is null)
2525: and not exists (
2526: select null
2527: from per_all_assignments_f as3,
2528: pay_assignment_actions ac3
2529: where itpflg = 'N'
2530: and ac3.payroll_action_id = pa2.payroll_action_id
2531: and ac3.action_status not in ('C', 'S')
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,
2585: pay_org_payment_methods_f opm
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,
2585: pay_org_payment_methods_f opm
2586: where pa1.payroll_action_id = pactid
2587: and pa2.consolidation_set_id +0 = pa1.consolidation_set_id
2609: and (opm.org_payment_method_id = pa1.org_payment_method_id
2610: or pa1.org_payment_method_id is null)
2611: and not exists (
2612: select null
2613: from per_all_assignments_f as3,
2614: pay_assignment_actions ac3
2615: where itpflg = 'N'
2616: and ac3.payroll_action_id = pa2.payroll_action_id
2617: and ac3.action_status not in ('C', 'S')
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,
2669: per_all_assignments_f as2,
2665: per_all_assignments_f as1,
2666: pay_assignment_actions act,
2667: pay_payroll_actions pa2,
2668: pay_action_classifications pcl,
2669: per_all_assignments_f as2,
2670: pay_pre_payments ppp,
2671: pay_org_payment_methods_f opm
2672: where pa1.payroll_action_id = pactid
2673: and pa2.consolidation_set_id +0 = pa1.consolidation_set_id
2697: and (opm.org_payment_method_id = pa1.org_payment_method_id
2698: or pa1.org_payment_method_id is null)
2699: and not exists (
2700: select null
2701: from per_all_assignments_f as3,
2702: pay_assignment_actions ac3
2703: where itpflg = 'N'
2704: and ac3.payroll_action_id = pa2.payroll_action_id
2705: and ac3.action_status not in ('C', 'S')
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
2844: and pa2.payroll_id = pa1.payroll_id
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
2844: and pa2.payroll_id = pa1.payroll_id
2845: and pa2.effective_date between
2846: pa1.start_date and pa1.effective_date
2873: and pa3.action_type in ('P', 'U'))
2874: and not exists (
2875: select /*+ ORDERED*/
2876: null
2877: from per_all_assignments_f as3,
2878: pay_assignment_actions ac3
2879: where itpflg = 'N'
2880: and ac3.payroll_action_id = pa2.payroll_action_id
2881: and ac3.action_status not in ( 'C', 'S')
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
2916: and pa2.payroll_id = pa1.payroll_id
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
2916: and pa2.payroll_id = pa1.payroll_id
2917: and pa2.effective_date between
2918: pa1.start_date and pa1.effective_date
2943: and pa3.action_type in ('P', 'U'))
2944: and not exists (
2945: select /*+ ORDERED*/
2946: null
2947: from per_all_assignments_f as3,
2948: pay_assignment_actions ac3
2949: where itpflg = 'N'
2950: and ac3.payroll_action_id = pa2.payroll_action_id
2951: and ac3.action_status not in ( 'C', 'S')
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,
2986: per_all_assignments_f as2
2982: per_all_assignments_f as1,
2983: pay_assignment_actions act,
2984: pay_payroll_actions pa2,
2985: pay_action_classifications pcl,
2986: per_all_assignments_f as2
2987: where pa1.payroll_action_id = pactid
2988: and pa2.payroll_id = pa1.payroll_id
2989: and pa2.effective_date between
2990: pa1.start_date and pa1.effective_date
3017: and pa3.action_type in ('P', 'U'))
3018: and not exists (
3019: select /*+ ORDERED*/
3020: null
3021: from per_all_assignments_f as3,
3022: pay_assignment_actions ac3
3023: where itpflg = 'N'
3024: and ac3.payroll_action_id = pa2.payroll_action_id
3025: and ac3.action_status not in ( 'C', 'S')
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
3157: and pa2.consolidation_set_id = pa1.consolidation_set_id
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
3157: and pa2.consolidation_set_id = pa1.consolidation_set_id
3158: and pa2.effective_date between
3159: pa1.start_date and pa1.effective_date
3183: and pa3.action_type in ('C', 'S'))
3184: and not exists (
3185: select /*+ ORDERED*/
3186: null
3187: from per_all_assignments_f as3,
3188: pay_assignment_actions ac3
3189: where itpflg = 'N'
3190: and ac3.payroll_action_id = pa2.payroll_action_id
3191: and ac3.action_status not in ('C','S')
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
3223: and pa2.consolidation_set_id = pa1.consolidation_set_id
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
3223: and pa2.consolidation_set_id = pa1.consolidation_set_id
3224: and pa2.effective_date between
3225: pa1.start_date and pa1.effective_date
3247: and pa3.action_type in ('C', 'S'))
3248: and not exists (
3249: select /*+ ORDERED*/
3250: null
3251: from per_all_assignments_f as3,
3252: pay_assignment_actions ac3
3253: where itpflg = 'N'
3254: and ac3.payroll_action_id = pa2.payroll_action_id
3255: and ac3.action_status not in ('C','S')
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,
3287: per_all_assignments_f as2
3283: per_all_assignments_f as1,
3284: pay_assignment_actions act,
3285: pay_payroll_actions pa2,
3286: pay_action_classifications pcl,
3287: per_all_assignments_f as2
3288: where pa1.payroll_action_id = pactid
3289: and pa2.consolidation_set_id = pa1.consolidation_set_id
3290: and pa2.effective_date between
3291: pa1.start_date and pa1.effective_date
3315: and pa3.action_type in ('C', 'S'))
3316: and not exists (
3317: select /*+ ORDERED*/
3318: null
3319: from per_all_assignments_f as3,
3320: pay_assignment_actions ac3
3321: where itpflg = 'N'
3322: and ac3.payroll_action_id = pa2.payroll_action_id
3323: and ac3.action_status not in ('C','S')
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
3432: and pa2.consolidation_set_id = pa1.consolidation_set_id
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
3432: and pa2.consolidation_set_id = pa1.consolidation_set_id
3433: and pa2.effective_date between
3434: pa1.start_date and pa1.effective_date
3458: and pa3.action_type = 'CP')
3459: and not exists (
3460: select /*+ ORDERED*/
3461: null
3462: from per_all_assignments_f as3,
3463: pay_assignment_actions ac3
3464: where itpflg = 'N'
3465: and ac3.payroll_action_id = pa2.payroll_action_id
3466: and ac3.action_status not in ('C','S')
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
3570: and pa2.consolidation_set_id = pa1.consolidation_set_id
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
3570: and pa2.consolidation_set_id = pa1.consolidation_set_id
3571: and pa2.effective_date between
3572: pa1.start_date and pa1.effective_date
3594: and pa3.action_type = 'CP')
3595: and not exists (
3596: select /*+ ORDERED*/
3597: null
3598: from per_all_assignments_f as3,
3599: pay_assignment_actions ac3
3600: where itpflg = 'N'
3601: and ac3.payroll_action_id = pa2.payroll_action_id
3602: and ac3.action_status not in ('C','S')
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,
3706: per_all_assignments_f as2
3702: per_all_assignments_f as1,
3703: pay_assignment_actions act,
3704: pay_payroll_actions pa2,
3705: pay_action_classifications pcl,
3706: per_all_assignments_f as2
3707: where pa1.payroll_action_id = pactid
3708: and pa2.consolidation_set_id = pa1.consolidation_set_id
3709: and pa2.effective_date between
3710: pa1.start_date and pa1.effective_date
3734: and pa3.action_type = 'CP')
3735: and not exists (
3736: select /*+ ORDERED*/
3737: null
3738: from per_all_assignments_f as3,
3739: pay_assignment_actions ac3
3740: where itpflg = 'N'
3741: and ac3.payroll_action_id = pa2.payroll_action_id
3742: and ac3.action_status not in ('C','S')
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
3928: and pay.consolidation_set_id = pa1.consolidation_set_id
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
3928: and pay.consolidation_set_id = pa1.consolidation_set_id
3929: and pa1.effective_date between
3930: pay.effective_start_date and pay.effective_end_date
3952: and (as1.payroll_id = pa1.payroll_id or pa1.payroll_id is null)
3953: and not exists (
3954: select /*+ ORDERED*/
3955: null
3956: from per_all_assignments_f as3,
3957: pay_assignment_actions ac3
3958: where itpflg = 'N'
3959: and ac3.payroll_action_id = pa2.payroll_action_id
3960: and ac3.action_status not in ('C','S')
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
3994: and pay.consolidation_set_id = pa1.consolidation_set_id
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
3994: and pay.consolidation_set_id = pa1.consolidation_set_id
3995: and pa1.effective_date between
3996: pay.effective_start_date and pay.effective_end_date
4016: and (as1.payroll_id = pa1.payroll_id or pa1.payroll_id is null)
4017: and not exists (
4018: select /*+ ORDERED*/
4019: null
4020: from per_all_assignments_f as3,
4021: pay_assignment_actions ac3
4022: where itpflg = 'N'
4023: and ac3.payroll_action_id = pa2.payroll_action_id
4024: and ac3.action_status not in ('C','S')
4104: from pay_payroll_actions pac,
4105: pay_population_ranges pop,
4106: pay_batch_headers bth,
4107: pay_batch_lines btl,
4108: per_all_assignments_f asg
4109: where pac.payroll_action_id = pactid
4110: and pac.action_type = 'BEE'
4111: and pac.batch_id = bth.batch_id
4112: and bth.batch_id = btl.batch_id
4127: ) is
4128: select asg.assignment_id
4129: from pay_payroll_actions pac,
4130: pay_batch_lines btl,
4131: per_all_assignments_f asg
4132: where pac.payroll_action_id = pactid
4133: and pac.action_type = 'BEE'
4134: and pac.batch_id = btl.batch_id
4135: and btl.assignment_id = asg.assignment_id
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
4231: and pa2.consolidation_set_id = pa.consolidation_set_id
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
4231: and pa2.consolidation_set_id = pa.consolidation_set_id
4232: and pa2.effective_date between
4233: pa.start_date and pa.effective_date
4259: and pa3.action_type = pa.action_type)
4260: and not exists (
4261: select /*+ ORDERED*/
4262: null
4263: from per_all_assignments_f as3,
4264: pay_assignment_actions ac3
4265: where itpflg = 'N'
4266: and ac3.payroll_action_id = pa2.payroll_action_id
4267: and ac3.action_status not in ('C','S')
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
4299: and pa2.consolidation_set_id = pa.consolidation_set_id
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
4299: and pa2.consolidation_set_id = pa.consolidation_set_id
4300: and pa2.effective_date between
4301: pa.start_date and pa.effective_date
4326: and pa3.action_type = pa.action_type)
4327: and not exists (
4328: select /*+ ORDERED*/
4329: null
4330: from per_all_assignments_f as3,
4331: pay_assignment_actions ac3
4332: where itpflg = 'N'
4333: and ac3.payroll_action_id = pa2.payroll_action_id
4334: and ac3.action_status not in ('C','S')
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,
4366: per_all_assignments_f as1
4362: per_all_assignments_f as2,
4363: pay_assignment_actions ac2,
4364: pay_payroll_actions pa2,
4365: pay_action_classifications pcl,
4366: per_all_assignments_f as1
4367: where pa.payroll_action_id = pactid
4368: and pa2.consolidation_set_id = pa.consolidation_set_id
4369: and pa2.effective_date between
4370: pa.start_date and pa.effective_date
4396: and pa3.action_type = pa.action_type)
4397: and not exists (
4398: select /*+ ORDERED*/
4399: null
4400: from per_all_assignments_f as3,
4401: pay_assignment_actions ac3
4402: where itpflg = 'N'
4403: and ac3.payroll_action_id = pa2.payroll_action_id
4404: and ac3.action_status not in ('C','S')
4418: from pay_action_interlocks in2,
4419: pay_assignment_actions ac1,
4420: pay_payroll_actions pa1,
4421: pay_action_classifications pcl1,
4422: per_all_assignments_f as1,
4423: pay_payroll_actions pa
4424: where pa.payroll_action_id = pactid
4425: and in2.locking_action_id = costactid
4426: and ac1.assignment_action_id = in2.locked_action_id
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,
4733: pay_org_payment_methods_f opm
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,
4733: pay_org_payment_methods_f opm
4734: where pa1.payroll_action_id = pactid
4735: and pa2.consolidation_set_id +0 = pa1.consolidation_set_id
4759: and (opm.org_payment_method_id = pa1.org_payment_method_id
4760: or pa1.org_payment_method_id is null)
4761: and not exists (
4762: select null
4763: from per_all_assignments_f as3,
4764: pay_assignment_actions ac3
4765: where itpflg = 'N'
4766: and ac3.payroll_action_id = pa2.payroll_action_id
4767: and ac3.action_status not in ('C', 'S')
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,
4821: pay_org_payment_methods_f opm
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,
4821: pay_org_payment_methods_f opm
4822: where pa1.payroll_action_id = pactid
4823: and pa2.consolidation_set_id +0 = pa1.consolidation_set_id
4845: and (opm.org_payment_method_id = pa1.org_payment_method_id
4846: or pa1.org_payment_method_id is null)
4847: and not exists (
4848: select null
4849: from per_all_assignments_f as3,
4850: pay_assignment_actions ac3
4851: where itpflg = 'N'
4852: and ac3.payroll_action_id = pa2.payroll_action_id
4853: and ac3.action_status not in ('C', 'S')
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,
4905: per_all_assignments_f as2,
4901: per_all_assignments_f as1,
4902: pay_assignment_actions act,
4903: pay_payroll_actions pa2,
4904: pay_action_classifications pcl,
4905: per_all_assignments_f as2,
4906: pay_pre_payments ppp,
4907: pay_org_payment_methods_f opm
4908: where pa1.payroll_action_id = pactid
4909: and pa2.consolidation_set_id +0 = pa1.consolidation_set_id
4933: and (opm.org_payment_method_id = pa1.org_payment_method_id
4934: or pa1.org_payment_method_id is null)
4935: and not exists (
4936: select null
4937: from per_all_assignments_f as3,
4938: pay_assignment_actions ac3
4939: where itpflg = 'N'
4940: and ac3.payroll_action_id = pa2.payroll_action_id
4941: and ac3.action_status not in ('C', 'S')
5246: ,p_paf_id number)
5247: is
5248: select paa.chunk_number
5249: from pay_assignment_actions paa
5250: , per_all_assignments_f paf
5251: , per_all_people_f ppf
5252: where paa.payroll_action_id = p_ppa_id
5253: and paa.assignment_id = p_paf_id
5254: and paa.assignment_id = paf.assignment_id