[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')
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,
2256: pay_pre_payments ppp,
2253: pay_assignment_actions act,
2254: pay_payroll_actions pa2,
2255: pay_action_classifications pcl,
2256: pay_pre_payments ppp,
2257: per_all_assignments_f as2,
2258: pay_org_payment_methods_f opm
2259: where pa1.payroll_action_id = pactid
2260: and pa2.consolidation_set_id + 0 = pa1.consolidation_set_id
2261: and pa2.effective_date between
2304: )
2305: and not exists (
2306: select /*+ ORDERED*/
2307: null
2308: from per_all_assignments_f as3,
2309: pay_assignment_actions ac3
2310: where itpflg = 'N'
2311: and ac3.payroll_action_id = pa2.payroll_action_id
2312: and ac3.action_status not in ('C', 'S')
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,
2503: pay_org_payment_methods_f opm
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,
2503: pay_org_payment_methods_f opm
2504: where pa1.payroll_action_id = pactid
2505: and pa2.consolidation_set_id +0 = pa1.consolidation_set_id
2529: and (opm.org_payment_method_id = pa1.org_payment_method_id
2530: or pa1.org_payment_method_id is null)
2531: and not exists (
2532: select null
2533: from per_all_assignments_f as3,
2534: pay_assignment_actions ac3
2535: where itpflg = 'N'
2536: and ac3.payroll_action_id = pa2.payroll_action_id
2537: and ac3.action_status not in ('C', 'S')
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,
2591: pay_org_payment_methods_f opm
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,
2591: pay_org_payment_methods_f opm
2592: where pa1.payroll_action_id = pactid
2593: and pa2.consolidation_set_id +0 = pa1.consolidation_set_id
2615: and (opm.org_payment_method_id = pa1.org_payment_method_id
2616: or pa1.org_payment_method_id is null)
2617: and not exists (
2618: select null
2619: from per_all_assignments_f as3,
2620: pay_assignment_actions ac3
2621: where itpflg = 'N'
2622: and ac3.payroll_action_id = pa2.payroll_action_id
2623: and ac3.action_status not in ('C', 'S')
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,
2675: per_all_assignments_f as2,
2671: per_all_assignments_f as1,
2672: pay_assignment_actions act,
2673: pay_payroll_actions pa2,
2674: pay_action_classifications pcl,
2675: per_all_assignments_f as2,
2676: pay_pre_payments ppp,
2677: pay_org_payment_methods_f opm
2678: where pa1.payroll_action_id = pactid
2679: and pa2.consolidation_set_id +0 = pa1.consolidation_set_id
2703: and (opm.org_payment_method_id = pa1.org_payment_method_id
2704: or pa1.org_payment_method_id is null)
2705: and not exists (
2706: select null
2707: from per_all_assignments_f as3,
2708: pay_assignment_actions ac3
2709: where itpflg = 'N'
2710: and ac3.payroll_action_id = pa2.payroll_action_id
2711: and ac3.action_status not in ('C', 'S')
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
2850: and pa2.payroll_id = pa1.payroll_id
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
2850: and pa2.payroll_id = pa1.payroll_id
2851: and pa2.effective_date between
2852: pa1.start_date and pa1.effective_date
2879: and pa3.action_type in ('P', 'U'))
2880: and not exists (
2881: select /*+ ORDERED*/
2882: null
2883: from per_all_assignments_f as3,
2884: pay_assignment_actions ac3
2885: where itpflg = 'N'
2886: and ac3.payroll_action_id = pa2.payroll_action_id
2887: and ac3.action_status not in ( 'C', 'S')
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
2922: and pa2.payroll_id = pa1.payroll_id
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
2922: and pa2.payroll_id = pa1.payroll_id
2923: and pa2.effective_date between
2924: pa1.start_date and pa1.effective_date
2949: and pa3.action_type in ('P', 'U'))
2950: and not exists (
2951: select /*+ ORDERED*/
2952: null
2953: from per_all_assignments_f as3,
2954: pay_assignment_actions ac3
2955: where itpflg = 'N'
2956: and ac3.payroll_action_id = pa2.payroll_action_id
2957: and ac3.action_status not in ( 'C', 'S')
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,
2992: per_all_assignments_f as2
2988: per_all_assignments_f as1,
2989: pay_assignment_actions act,
2990: pay_payroll_actions pa2,
2991: pay_action_classifications pcl,
2992: per_all_assignments_f as2
2993: where pa1.payroll_action_id = pactid
2994: and pa2.payroll_id = pa1.payroll_id
2995: and pa2.effective_date between
2996: pa1.start_date and pa1.effective_date
3023: and pa3.action_type in ('P', 'U'))
3024: and not exists (
3025: select /*+ ORDERED*/
3026: null
3027: from per_all_assignments_f as3,
3028: pay_assignment_actions ac3
3029: where itpflg = 'N'
3030: and ac3.payroll_action_id = pa2.payroll_action_id
3031: and ac3.action_status not in ( 'C', 'S')
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
3164: and pa2.consolidation_set_id = pa1.consolidation_set_id
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
3164: and pa2.consolidation_set_id = pa1.consolidation_set_id
3165: and pa2.effective_date between
3166: pa1.start_date and pa1.effective_date
3190: and pa3.action_type in ('C', 'S'))
3191: and not exists (
3192: select /*+ ORDERED*/
3193: null
3194: from per_all_assignments_f as3,
3195: pay_assignment_actions ac3
3196: where itpflg = 'N'
3197: and ac3.payroll_action_id = pa2.payroll_action_id
3198: and ac3.action_status not in ('C','S')
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
3231: and pa2.consolidation_set_id = pa1.consolidation_set_id
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
3231: and pa2.consolidation_set_id = pa1.consolidation_set_id
3232: and pa2.effective_date between
3233: pa1.start_date and pa1.effective_date
3255: and pa3.action_type in ('C', 'S'))
3256: and not exists (
3257: select /*+ ORDERED*/
3258: null
3259: from per_all_assignments_f as3,
3260: pay_assignment_actions ac3
3261: where itpflg = 'N'
3262: and ac3.payroll_action_id = pa2.payroll_action_id
3263: and ac3.action_status not in ('C','S')
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,
3295: per_all_assignments_f as2
3291: per_all_assignments_f as1,
3292: pay_assignment_actions act,
3293: pay_payroll_actions pa2,
3294: pay_action_classifications pcl,
3295: per_all_assignments_f as2
3296: where pa1.payroll_action_id = pactid
3297: and pa2.consolidation_set_id = pa1.consolidation_set_id
3298: and pa2.effective_date between
3299: pa1.start_date and pa1.effective_date
3323: and pa3.action_type in ('C', 'S'))
3324: and not exists (
3325: select /*+ ORDERED*/
3326: null
3327: from per_all_assignments_f as3,
3328: pay_assignment_actions ac3
3329: where itpflg = 'N'
3330: and ac3.payroll_action_id = pa2.payroll_action_id
3331: and ac3.action_status not in ('C','S')
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
3440: and pa2.consolidation_set_id = pa1.consolidation_set_id
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
3440: and pa2.consolidation_set_id = pa1.consolidation_set_id
3441: and pa2.effective_date between
3442: pa1.start_date and pa1.effective_date
3466: and pa3.action_type = 'CP')
3467: and not exists (
3468: select /*+ ORDERED*/
3469: null
3470: from per_all_assignments_f as3,
3471: pay_assignment_actions ac3
3472: where itpflg = 'N'
3473: and ac3.payroll_action_id = pa2.payroll_action_id
3474: and ac3.action_status not in ('C','S')
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
3578: and pa2.consolidation_set_id = pa1.consolidation_set_id
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
3578: and pa2.consolidation_set_id = pa1.consolidation_set_id
3579: and pa2.effective_date between
3580: pa1.start_date and pa1.effective_date
3602: and pa3.action_type = 'CP')
3603: and not exists (
3604: select /*+ ORDERED*/
3605: null
3606: from per_all_assignments_f as3,
3607: pay_assignment_actions ac3
3608: where itpflg = 'N'
3609: and ac3.payroll_action_id = pa2.payroll_action_id
3610: and ac3.action_status not in ('C','S')
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,
3714: per_all_assignments_f as2
3710: per_all_assignments_f as1,
3711: pay_assignment_actions act,
3712: pay_payroll_actions pa2,
3713: pay_action_classifications pcl,
3714: per_all_assignments_f as2
3715: where pa1.payroll_action_id = pactid
3716: and pa2.consolidation_set_id = pa1.consolidation_set_id
3717: and pa2.effective_date between
3718: pa1.start_date and pa1.effective_date
3742: and pa3.action_type = 'CP')
3743: and not exists (
3744: select /*+ ORDERED*/
3745: null
3746: from per_all_assignments_f as3,
3747: pay_assignment_actions ac3
3748: where itpflg = 'N'
3749: and ac3.payroll_action_id = pa2.payroll_action_id
3750: and ac3.action_status not in ('C','S')
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
3936: and pay.consolidation_set_id = pa1.consolidation_set_id
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
3936: and pay.consolidation_set_id = pa1.consolidation_set_id
3937: and pa1.effective_date between
3938: pay.effective_start_date and pay.effective_end_date
3960: and (as1.payroll_id = pa1.payroll_id or pa1.payroll_id is null)
3961: and not exists (
3962: select /*+ ORDERED*/
3963: null
3964: from per_all_assignments_f as3,
3965: pay_assignment_actions ac3
3966: where itpflg = 'N'
3967: and ac3.payroll_action_id = pa2.payroll_action_id
3968: and ac3.action_status not in ('C','S')
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
4002: and pay.consolidation_set_id = pa1.consolidation_set_id
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
4002: and pay.consolidation_set_id = pa1.consolidation_set_id
4003: and pa1.effective_date between
4004: pay.effective_start_date and pay.effective_end_date
4024: and (as1.payroll_id = pa1.payroll_id or pa1.payroll_id is null)
4025: and not exists (
4026: select /*+ ORDERED*/
4027: null
4028: from per_all_assignments_f as3,
4029: pay_assignment_actions ac3
4030: where itpflg = 'N'
4031: and ac3.payroll_action_id = pa2.payroll_action_id
4032: and ac3.action_status not in ('C','S')
4112: from pay_payroll_actions pac,
4113: pay_population_ranges pop,
4114: pay_batch_headers bth,
4115: pay_batch_lines btl,
4116: per_all_assignments_f asg
4117: where pac.payroll_action_id = pactid
4118: and pac.action_type = 'BEE'
4119: and pac.batch_id = bth.batch_id
4120: and bth.batch_id = btl.batch_id
4135: ) is
4136: select asg.assignment_id
4137: from pay_payroll_actions pac,
4138: pay_batch_lines btl,
4139: per_all_assignments_f asg
4140: where pac.payroll_action_id = pactid
4141: and pac.action_type = 'BEE'
4142: and pac.batch_id = btl.batch_id
4143: and btl.assignment_id = asg.assignment_id
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
4240: and pa2.consolidation_set_id = pa.consolidation_set_id
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
4240: and pa2.consolidation_set_id = pa.consolidation_set_id
4241: and pa2.effective_date between
4242: pa.start_date and pa.effective_date
4268: and pa3.action_type = pa.action_type)
4269: and not exists (
4270: select /*+ ORDERED*/
4271: null
4272: from per_all_assignments_f as3,
4273: pay_assignment_actions ac3
4274: where itpflg = 'N'
4275: and ac3.payroll_action_id = pa2.payroll_action_id
4276: and ac3.action_status not in ('C','S')
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
4309: and pa2.consolidation_set_id = pa.consolidation_set_id
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
4309: and pa2.consolidation_set_id = pa.consolidation_set_id
4310: and pa2.effective_date between
4311: pa.start_date and pa.effective_date
4336: and pa3.action_type = pa.action_type)
4337: and not exists (
4338: select /*+ ORDERED*/
4339: null
4340: from per_all_assignments_f as3,
4341: pay_assignment_actions ac3
4342: where itpflg = 'N'
4343: and ac3.payroll_action_id = pa2.payroll_action_id
4344: and ac3.action_status not in ('C','S')
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,
4376: per_all_assignments_f as1
4372: per_all_assignments_f as2,
4373: pay_assignment_actions ac2,
4374: pay_payroll_actions pa2,
4375: pay_action_classifications pcl,
4376: per_all_assignments_f as1
4377: where pa.payroll_action_id = pactid
4378: and pa2.consolidation_set_id = pa.consolidation_set_id
4379: and pa2.effective_date between
4380: pa.start_date and pa.effective_date
4406: and pa3.action_type = pa.action_type)
4407: and not exists (
4408: select /*+ ORDERED*/
4409: null
4410: from per_all_assignments_f as3,
4411: pay_assignment_actions ac3
4412: where itpflg = 'N'
4413: and ac3.payroll_action_id = pa2.payroll_action_id
4414: and ac3.action_status not in ('C','S')
4428: from pay_action_interlocks in2,
4429: pay_assignment_actions ac1,
4430: pay_payroll_actions pa1,
4431: pay_action_classifications pcl1,
4432: per_all_assignments_f as1,
4433: pay_payroll_actions pa
4434: where pa.payroll_action_id = pactid
4435: and in2.locking_action_id = costactid
4436: and ac1.assignment_action_id = in2.locked_action_id
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,
4748: pay_org_payment_methods_f opm
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,
4748: pay_org_payment_methods_f opm
4749: where pa1.payroll_action_id = pactid
4750: and pa2.consolidation_set_id +0 = pa1.consolidation_set_id
4774: and (opm.org_payment_method_id = pa1.org_payment_method_id
4775: or pa1.org_payment_method_id is null)
4776: and not exists (
4777: select null
4778: from per_all_assignments_f as3,
4779: pay_assignment_actions ac3
4780: where itpflg = 'N'
4781: and ac3.payroll_action_id = pa2.payroll_action_id
4782: and ac3.action_status not in ('C', 'S')
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,
4836: pay_org_payment_methods_f opm
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,
4836: pay_org_payment_methods_f opm
4837: where pa1.payroll_action_id = pactid
4838: and pa2.consolidation_set_id +0 = pa1.consolidation_set_id
4860: and (opm.org_payment_method_id = pa1.org_payment_method_id
4861: or pa1.org_payment_method_id is null)
4862: and not exists (
4863: select null
4864: from per_all_assignments_f as3,
4865: pay_assignment_actions ac3
4866: where itpflg = 'N'
4867: and ac3.payroll_action_id = pa2.payroll_action_id
4868: and ac3.action_status not in ('C', 'S')
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,
4920: per_all_assignments_f as2,
4916: per_all_assignments_f as1,
4917: pay_assignment_actions act,
4918: pay_payroll_actions pa2,
4919: pay_action_classifications pcl,
4920: per_all_assignments_f as2,
4921: pay_pre_payments ppp,
4922: pay_org_payment_methods_f opm
4923: where pa1.payroll_action_id = pactid
4924: and pa2.consolidation_set_id +0 = pa1.consolidation_set_id
4948: and (opm.org_payment_method_id = pa1.org_payment_method_id
4949: or pa1.org_payment_method_id is null)
4950: and not exists (
4951: select null
4952: from per_all_assignments_f as3,
4953: pay_assignment_actions ac3
4954: where itpflg = 'N'
4955: and ac3.payroll_action_id = pa2.payroll_action_id
4956: and ac3.action_status not in ('C', 'S')
5261: ,p_paf_id number)
5262: is
5263: select paa.chunk_number
5264: from pay_assignment_actions paa
5265: , per_all_assignments_f paf
5266: , per_all_people_f ppf
5267: where paa.payroll_action_id = p_ppa_id
5268: and paa.assignment_id = p_paf_id
5269: and paa.assignment_id = paf.assignment_id