[Home] [Help]
1148: --
1149: cursor get_cost_lockers (p_cost_act number, p_run_act number)
1150: is
1151: select paa.assignment_action_id
1152: from pay_action_classifications pcl,
1153: pay_payroll_actions pac,
1154: pay_assignment_actions paa,
1155: pay_action_interlocks pai
1156: where pai.locked_action_id = p_run_act
1427: act.tax_unit_id,
1428: ppp.pre_payment_id
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,
1504: act.tax_unit_id,
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,
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,
1587: pay_pre_payments ppp,
1588: pay_org_payment_methods_f opm
1589: where pa1.payroll_action_id = pactid
1713: act.assignment_id,
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
1776: act.assignment_id,
1777: act.tax_unit_id
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
1913: hou.organization_id,
1914: ppp.pre_payment_id
1915: from pay_payroll_actions pa1,
1916: pay_payroll_actions pa2,
1917: pay_action_classifications pcl,
1918: pay_population_ranges pop,
1919: hr_organization_units hou,
1920: pay_pre_payments ppp,
1921: pay_org_payment_methods_f opm,
2065: pa1.assignment_set_id,
2066: as1.payroll_id
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,
2157: pa1.assignment_set_id,
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,
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,
2257: per_all_assignments_f as2,
2258: pay_org_payment_methods_f opm
2259: where pa1.payroll_action_id = pactid
2492: act.tax_unit_id,
2493: ppp.pre_payment_id
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,
2581: act.tax_unit_id,
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,
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,
2676: pay_pre_payments ppp,
2677: pay_org_payment_methods_f opm
2678: where pa1.payroll_action_id = pactid
2839: as1.effective_start_date,
2840: as1.primary_flag
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,
2912: as1.effective_start_date,
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
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
2993: where pa1.payroll_action_id = pactid
2994: and pa2.payroll_id = pa1.payroll_id
2995: and pa2.effective_date between
3153: act.assignment_id,
3154: act.tax_unit_id
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,
3221: act.assignment_id,
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
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
3296: where pa1.payroll_action_id = pactid
3297: and pa2.consolidation_set_id = pa1.consolidation_set_id
3298: and pa2.effective_date between
3429: act.tax_unit_id,
3430: act.payroll_action_id
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,
3568: act.tax_unit_id,
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
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
3715: where pa1.payroll_action_id = pactid
3716: and pa2.consolidation_set_id = pa1.consolidation_set_id
3717: and pa2.effective_date between
3925: from pay_payroll_actions pa1,
3926: pay_all_payrolls_f pay,
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,
3992: from pay_payroll_actions pa1,
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
4229: ac2.tax_unit_id,
4230: pa2.action_type
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,
4299: ac2.tax_unit_id,
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
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
4377: where pa.payroll_action_id = pactid
4378: and pa2.consolidation_set_id = pa.consolidation_set_id
4379: and pa2.effective_date between
4427: select ac1.assignment_action_id
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
4737: act.tax_unit_id,
4738: ppp.pre_payment_id
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,
4826: act.tax_unit_id,
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,
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,
4921: pay_pre_payments ppp,
4922: pay_org_payment_methods_f opm
4923: where pa1.payroll_action_id = pactid