[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,
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,
2251: per_all_assignments_f as2,
2252: pay_org_payment_methods_f opm
2253: where pa1.payroll_action_id = pactid
2486: act.tax_unit_id,
2487: ppp.pre_payment_id
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,
2575: act.tax_unit_id,
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,
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,
2670: pay_pre_payments ppp,
2671: pay_org_payment_methods_f opm
2672: where pa1.payroll_action_id = pactid
2833: as1.effective_start_date,
2834: as1.primary_flag
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,
2906: as1.effective_start_date,
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
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
2987: where pa1.payroll_action_id = pactid
2988: and pa2.payroll_id = pa1.payroll_id
2989: and pa2.effective_date between
3146: act.assignment_id,
3147: act.tax_unit_id
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,
3213: act.assignment_id,
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
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
3288: where pa1.payroll_action_id = pactid
3289: and pa2.consolidation_set_id = pa1.consolidation_set_id
3290: and pa2.effective_date between
3421: act.tax_unit_id,
3422: act.payroll_action_id
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,
3560: act.tax_unit_id,
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
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
3707: where pa1.payroll_action_id = pactid
3708: and pa2.consolidation_set_id = pa1.consolidation_set_id
3709: and pa2.effective_date between
3917: from pay_payroll_actions pa1,
3918: pay_all_payrolls_f pay,
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,
3984: from pay_payroll_actions pa1,
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
4220: ac2.tax_unit_id,
4221: pa2.action_type
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,
4289: ac2.tax_unit_id,
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
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
4367: where pa.payroll_action_id = pactid
4368: and pa2.consolidation_set_id = pa.consolidation_set_id
4369: and pa2.effective_date between
4417: select ac1.assignment_action_id
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
4722: act.tax_unit_id,
4723: ppp.pre_payment_id
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,
4811: act.tax_unit_id,
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,
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,
4906: pay_pre_payments ppp,
4907: pay_org_payment_methods_f opm
4908: where pa1.payroll_action_id = pactid