eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_NONRUN_ASACT dependencies on PAY_PAYROLL_ACTIONS

Line 40: from pay_payroll_actions locked_pact,

36: --
37: select /*+ USE_NL(locked_pact locked locking locks)*/
38: max(date_earned)
39: into l_date_earned
40: from pay_payroll_actions locked_pact,
41: pay_assignment_actions locked,
42: pay_assignment_actions locking,
43: pay_action_interlocks locks
44: where locking.payroll_action_id = p_payroll_action_id

Line 54: update pay_payroll_actions pac

50: l_date_earned := null;
51: end if;
52: --
53: if (p_action_type in ('R', 'Q', 'B', 'V')) then
54: update pay_payroll_actions pac
55: set pac.action_population_status = p_action_population_status,
56: pac.last_update_date = p_last_update_date,
57: pac.last_updated_by = p_last_updated_by,
58: pac.last_update_login = p_last_update_login

Line 61: update pay_payroll_actions pac

57: pac.last_updated_by = p_last_updated_by,
58: pac.last_update_login = p_last_update_login
59: where pac.payroll_action_id = p_payroll_action_id;
60: elsif (p_action_type not in ('X', 'H')) then
61: update pay_payroll_actions pac
62: set pac.action_population_status = p_action_population_status,
63: pac.last_update_date = p_last_update_date,
64: pac.last_updated_by = p_last_updated_by,
65: pac.last_update_login = p_last_update_login,

Line 69: update pay_payroll_actions pac

65: pac.last_update_login = p_last_update_login,
66: pac.date_earned = l_date_earned
67: where pac.payroll_action_id = p_payroll_action_id;
68: else
69: update pay_payroll_actions pac
70: set pac.action_population_status = p_action_population_status,
71: pac.last_update_date = p_last_update_date,
72: pac.last_updated_by = p_last_updated_by,
73: pac.last_update_login = p_last_update_login,

Line 124: hr_utility.set_message_token('LOCKNAME','PAY_PAYROLL_ACTIONS_'||pactid);

120: release_on_commit => TRUE);
121: --
122: if (ret <> 0) then
123: hr_utility.set_message(801,'HR_289135_NO_LOCK_GAINED');
124: hr_utility.set_message_token('LOCKNAME','PAY_PAYROLL_ACTIONS_'||pactid);
125: hr_utility.set_message_token('LOCKERR',ret);
126: hr_utility.raise_error;
127: end if;
128: --

Line 131: from pay_payroll_actions pac

127: end if;
128: --
129: select pac.action_population_status
130: into actpopstat
131: from pay_payroll_actions pac
132: where pac.payroll_action_id = pactid;
133: --
134: -- only bother to process if status is not complete.
135: if(actpopstat <> 'C'and actpopstat <> 'A' and actpopstat <> 'E') then

Line 243: act_pop_status pay_payroll_actions.action_population_status%type;

239: ) is
240: l_lckhandle varchar2(128);
241: ret number;
242: chk_pop_status pay_chunk_status.population_status%type;
243: act_pop_status pay_payroll_actions.action_population_status%type;
244: begin
245: /* OK we have the next chunk lets lock it and confirm that its
246: unprocessed
247: */

Line 276: from pay_payroll_actions ppa,

272: select pcs_rand.population_status,
273: ppa.action_population_status
274: into chk_pop_status,
275: act_pop_status
276: from pay_payroll_actions ppa,
277: pay_chunk_status pcs_pop,
278: pay_chunk_status pcs_rand
279: where pcs_pop.payroll_action_id = pactid
280: and pcs_pop.chunk_number = p_next_chunk

Line 365: act_pop_status pay_payroll_actions.action_population_status%type;

361: next_chunk number;
362: found boolean;
363: l_lckhandle varchar2(128);
364: ret number;
365: act_pop_status pay_payroll_actions.action_population_status%type;
366: norows boolean; -- used to decide if sql stat has returned rows.
367: dummy number; -- need because must select into something.
368: begin
369: --

Line 395: hr_utility.set_message_token('LOCKNAME','PAY_PAYROLL_ACTIONS_'||pactid);

391: release_on_commit => TRUE);
392: --
393: if (ret <> 0) then
394: hr_utility.set_message(801,'HR_289135_NO_LOCK_GAINED');
395: hr_utility.set_message_token('LOCKNAME','PAY_PAYROLL_ACTIONS_'||pactid);
396: hr_utility.set_message_token('LOCKERR',ret);
397: hr_utility.raise_error;
398: end if;
399: --

Line 404: from pay_payroll_actions ppa

400: select
401: ppa.action_population_status
402: into
403: act_pop_status
404: from pay_payroll_actions ppa
405: where ppa.payroll_action_id = pactid;
406: --
407: if ( act_pop_status <> 'C'
408: and act_pop_status <> 'A'

Line 511: pay_pop_status pay_payroll_actions.action_population_status%type;

507: rand_chunk out nocopy number -- chunk_number.
508: ) is
509: next_chunk number;
510: found boolean;
511: pay_pop_status pay_payroll_actions.action_population_status%type;
512: chk_pop_status pay_chunk_status.population_status%type;
513: get_paused boolean;
514: begin
515: --

Line 532: from pay_payroll_actions

528: get_paused := FALSE;
529: --
530: select action_population_status
531: into pay_pop_status
532: from pay_payroll_actions
533: where payroll_action_id = pactid;
534: --
535: begin
536: --

Line 691: action_status pay_payroll_actions.action_status%type;

687: is
688: --
689: next_chunk number;
690: pop_chunk_number number;
691: action_status pay_payroll_actions.action_status%type;
692: action_pop_status pay_payroll_actions.action_population_status%type;
693: l_dummy number;
694: found boolean;
695: --

Line 692: action_pop_status pay_payroll_actions.action_population_status%type;

688: --
689: next_chunk number;
690: pop_chunk_number number;
691: action_status pay_payroll_actions.action_status%type;
692: action_pop_status pay_payroll_actions.action_population_status%type;
693: l_dummy number;
694: found boolean;
695: --
696: begin

Line 707: from pay_payroll_actions PAC

703: PAC.action_population_status
704: into next_chunk,
705: action_status,
706: action_pop_status
707: from pay_payroll_actions PAC
708: where PAC.payroll_action_id = pactid
709: for update of PAC.current_chunk_number;
710: --
711: if (action_status = 'C') then

Line 742: update pay_payroll_actions pac

738: end if;
739: --
740: if (got_chunk = TRUE) then
741: --
742: update pay_payroll_actions pac
743: set pac.current_chunk_number = next_chunk
744: where pac.payroll_action_id = pactid;
745: --
746: update pay_chunk_status

Line 816: from pay_payrolL_actions

812: select action_status,
813: action_population_status
814: into pact_act_status,
815: act_pop_status
816: from pay_payrolL_actions
817: where payroll_action_id = pactid;
818: --
819: if (next_chunk is not null) then
820: --

Line 903: pact_act_status pay_payroll_actions.action_status%type;

899: curr_chunk in out nocopy number -- current chunk
900: ) is
901: next_chunk number;
902: found boolean;
903: pact_act_status pay_payroll_actions.action_status%type;
904: act_pop_status pay_payroll_actions.action_population_status%type;
905: chk_status pay_chunk_status.process_status%type;
906: begin
907: --

Line 904: act_pop_status pay_payroll_actions.action_population_status%type;

900: ) is
901: next_chunk number;
902: found boolean;
903: pact_act_status pay_payroll_actions.action_status%type;
904: act_pop_status pay_payroll_actions.action_population_status%type;
905: chk_status pay_chunk_status.process_status%type;
906: begin
907: --
908: found := FALSE;

Line 921: from pay_payroll_actions

917: --
918: select action_status, action_population_status
919: into pact_act_status,
920: act_pop_status
921: from pay_payroll_actions
922: where payroll_action_id = pactid;
923: --
924: begin
925: --

Line 1153: pay_payroll_actions pac,

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
1157: and pai.locking_action_id = paa.assignment_action_id

Line 1283: l_action_type pay_payroll_actions.action_type%type;

1279: p_transient_action in boolean default false -- Transient Action
1280: ) is
1281: --
1282: l_transient_action boolean;
1283: l_action_type pay_payroll_actions.action_type%type;
1284: l_report_type pay_payroll_actions.report_type%type;
1285: l_report_qualifier pay_payroll_actions.report_qualifier%type;
1286: l_report_category pay_payroll_actions.report_category%type;
1287: l_eff_date pay_payroll_actions.effective_date%type;

Line 1284: l_report_type pay_payroll_actions.report_type%type;

1280: ) is
1281: --
1282: l_transient_action boolean;
1283: l_action_type pay_payroll_actions.action_type%type;
1284: l_report_type pay_payroll_actions.report_type%type;
1285: l_report_qualifier pay_payroll_actions.report_qualifier%type;
1286: l_report_category pay_payroll_actions.report_category%type;
1287: l_eff_date pay_payroll_actions.effective_date%type;
1288: l_temp_act_flag pay_report_format_mappings_f.temporary_action_flag%type;

Line 1285: l_report_qualifier pay_payroll_actions.report_qualifier%type;

1281: --
1282: l_transient_action boolean;
1283: l_action_type pay_payroll_actions.action_type%type;
1284: l_report_type pay_payroll_actions.report_type%type;
1285: l_report_qualifier pay_payroll_actions.report_qualifier%type;
1286: l_report_category pay_payroll_actions.report_category%type;
1287: l_eff_date pay_payroll_actions.effective_date%type;
1288: l_temp_act_flag pay_report_format_mappings_f.temporary_action_flag%type;
1289: --

Line 1286: l_report_category pay_payroll_actions.report_category%type;

1282: l_transient_action boolean;
1283: l_action_type pay_payroll_actions.action_type%type;
1284: l_report_type pay_payroll_actions.report_type%type;
1285: l_report_qualifier pay_payroll_actions.report_qualifier%type;
1286: l_report_category pay_payroll_actions.report_category%type;
1287: l_eff_date pay_payroll_actions.effective_date%type;
1288: l_temp_act_flag pay_report_format_mappings_f.temporary_action_flag%type;
1289: --
1290: begin

Line 1287: l_eff_date pay_payroll_actions.effective_date%type;

1283: l_action_type pay_payroll_actions.action_type%type;
1284: l_report_type pay_payroll_actions.report_type%type;
1285: l_report_qualifier pay_payroll_actions.report_qualifier%type;
1286: l_report_category pay_payroll_actions.report_category%type;
1287: l_eff_date pay_payroll_actions.effective_date%type;
1288: l_temp_act_flag pay_report_format_mappings_f.temporary_action_flag%type;
1289: --
1290: begin
1291: --

Line 1302: from pay_payroll_actions

1298: l_report_type,
1299: l_report_qualifier,
1300: l_report_category,
1301: l_eff_date
1302: from pay_payroll_actions
1303: where payroll_action_id = pactid;
1304: --
1305: l_transient_action := FALSE;
1306: --

Line 1418: INDEX(pa2 PAY_PAYROLL_ACTIONS_N5)

1414: chunk number,
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)

Line 1429: from pay_payroll_actions pa1,

1425: act.assignment_action_id,
1426: act.assignment_id,
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,

Line 1430: pay_payroll_actions pa2,

1426: act.assignment_id,
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,

Line 1495: INDEX(pa2 PAY_PAYROLL_ACTIONS_N5)

1491: endperson number,
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)

Line 1506: from pay_payroll_actions pa1,

1502: act.assignment_action_id,
1503: act.assignment_id,
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,

Line 1507: pay_payroll_actions pa2,

1503: act.assignment_id,
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,

Line 1568: INDEX(pa2 PAY_PAYROLL_ACTIONS_PK)

1564: chunk number,
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)

Line 1579: from pay_payroll_actions pa1,

1575: act.assignment_action_id,
1576: act.assignment_id,
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,

Line 1584: pay_payroll_actions pa2,

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,
1587: pay_pre_payments ppp,
1588: pay_org_payment_methods_f opm

Line 1709: index(pa2 PAY_PAYROLL_ACTIONS_N5)

1705: class varchar2,
1706: itpflg varchar2
1707: ) is
1708: select /*+ ORDERED
1709: index(pa2 PAY_PAYROLL_ACTIONS_N5)
1710: index(as1 PER_ASSIGNMENTS_F_N4)
1711: USE_NL(pos as1) */
1712: act.assignment_action_id,
1713: act.assignment_id,

Line 1715: from pay_payroll_actions pa1,

1711: USE_NL(pos as1) */
1712: act.assignment_action_id,
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,

Line 1716: pay_payroll_actions pa2,

1712: act.assignment_action_id,
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

Line 1772: index(pa2 PAY_PAYROLL_ACTIONS_N5)

1768: class varchar2,
1769: itpflg varchar2
1770: ) is
1771: select /*+ ORDERED
1772: index(pa2 PAY_PAYROLL_ACTIONS_N5)
1773: index(as1 PER_ASSIGNMENTS_F_N4)
1774: USE_NL(pos as1) */
1775: act.assignment_action_id,
1776: act.assignment_id,

Line 1778: from pay_payroll_actions pa1,

1774: USE_NL(pos as1) */
1775: act.assignment_action_id,
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,

Line 1779: pay_payroll_actions pa2,

1775: act.assignment_action_id,
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,

Line 1915: from pay_payroll_actions pa1,

1911: */
1912: pcp.assignment_action_id,
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,

Line 1916: pay_payroll_actions pa2,

1912: pcp.assignment_action_id,
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,

Line 1974: from pay_payroll_actions pa1

1970: if (g_contrib_payments_exist is null) then
1971: begin
1972: select 1
1973: into l_cp
1974: from pay_payroll_actions pa1
1975: where pa1.payroll_action_id = pactid
1976: and exists
1977: (select 1
1978: from pay_payroll_actions pa2,

Line 1978: from pay_payroll_actions pa2,

1974: from pay_payroll_actions pa1
1975: where pa1.payroll_action_id = pactid
1976: and exists
1977: (select 1
1978: from pay_payroll_actions pa2,
1979: pay_contributing_payments pcp
1980: where pa2.payroll_action_id = pcp.payroll_action_id
1981: and pa2.action_type = 'PRU'
1982: and pa2.business_group_id = pa1.business_group_id);

Line 2056: index(pa2 PAY_PAYROLL_ACTIONS_N5)

2052: ptype number,
2053: class varchar2
2054: ) is
2055: SELECT /*+ ORDERED
2056: index(pa2 PAY_PAYROLL_ACTIONS_N5)
2057: index(as1 PER_ASSIGNMENTS_F_N4)
2058: index(as2 PER_ASSIGNMENTS_F_PK)
2059: index(opm PAY_ORG_PAYMENT_METHODS_F_PK)
2060: USE_NL(pop pos as1 as2) */

Line 2067: from pay_payroll_actions pa1,

2063: act.tax_unit_id,
2064: ppp.pre_payment_id,
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,

Line 2068: pay_payroll_actions pa2,

2064: ppp.pre_payment_id,
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,

Line 2117: pay_payroll_actions ppa_void

2113: and not exists (
2114: select null
2115: from pay_assignment_actions paa_void,
2116: pay_action_interlocks pai_void,
2117: pay_payroll_actions ppa_void
2118: where pai_void.locked_action_id = ac2.assignment_action_id
2119: and pai_void.locking_action_id = paa_void.assignment_action_id
2120: and paa_void.payroll_action_id = ppa_void.payroll_action_id
2121: and ppa_void.action_type = 'D')

Line 2148: index(pa2 PAY_PAYROLL_ACTIONS_N5)

2144: ptype number,
2145: class varchar2
2146: ) is
2147: SELECT /*+ ORDERED
2148: index(pa2 PAY_PAYROLL_ACTIONS_N5)
2149: index(as1 PER_ASSIGNMENTS_F_N4)
2150: index(as2 PER_ASSIGNMENTS_F_PK)
2151: index(opm PAY_ORG_PAYMENT_METHODS_F_PK)
2152: USE_NL(pos as1 as2) */

Line 2159: from pay_payroll_actions pa1,

2155: act.tax_unit_id,
2156: ppp.pre_payment_id,
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,

Line 2160: pay_payroll_actions pa2,

2156: ppp.pre_payment_id,
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,

Line 2206: pay_payroll_actions ppa_void

2202: and not exists (
2203: select null
2204: from pay_assignment_actions paa_void,
2205: pay_action_interlocks pai_void,
2206: pay_payroll_actions ppa_void
2207: where pai_void.locked_action_id = ac2.assignment_action_id
2208: and pai_void.locking_action_id = paa_void.assignment_action_id
2209: and paa_void.payroll_action_id = ppa_void.payroll_action_id
2210: and ppa_void.action_type = 'D')

Line 2236: index(pa2 PAY_PAYROLL_ACTIONS_PK)

2232: ptype number,
2233: class varchar2
2234: ) is
2235: SELECT /*+ ORDERED
2236: index(pa2 PAY_PAYROLL_ACTIONS_PK)
2237: index(pos PER_PERIODS_OF_SERVICE_N3)
2238: index(as1 PER_ASSIGNMENTS_F_N4)
2239: index(act PAY_ASSIGNMENT_ACTIONS_N51)
2240: index(as2 PER_ASSIGNMENTS_F_PK)

Line 2249: from pay_payroll_actions pa1,

2245: act.tax_unit_id,
2246: ppp.pre_payment_id,
2247: pa1.assignment_set_id,
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,

Line 2254: pay_payroll_actions pa2,

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,
2257: per_all_assignments_f as2,
2258: pay_org_payment_methods_f opm

Line 2299: pay_payroll_actions ppa_void

2295: and not exists (
2296: select null
2297: from pay_assignment_actions paa_void,
2298: pay_action_interlocks pai_void,
2299: pay_payroll_actions ppa_void
2300: where pai_void.locked_action_id = ac2.assignment_action_id
2301: and pai_void.locking_action_id = paa_void.assignment_action_id
2302: and paa_void.payroll_action_id = ppa_void.payroll_action_id
2303: and ppa_void.action_type = 'D')

Line 2353: pay_payroll_actions chk_ppa,

2349: and exists
2350: (select 1
2351: from pay_action_interlocks lck1,
2352: pay_assignment_actions chk_paa,
2353: pay_payroll_actions chk_ppa,
2354: pay_action_interlocks lck2,
2355: pay_assignment_actions vd_paa,
2356: pay_payroll_actions vd_ppa
2357: where lck1.locked_action_id = plockedid

Line 2356: pay_payroll_actions vd_ppa

2352: pay_assignment_actions chk_paa,
2353: pay_payroll_actions chk_ppa,
2354: pay_action_interlocks lck2,
2355: pay_assignment_actions vd_paa,
2356: pay_payroll_actions vd_ppa
2357: where lck1.locked_action_id = plockedid
2358: and lck1.locking_action_id = chk_paa.assignment_action_id
2359: and chk_paa.payroll_action_id = chk_ppa.payroll_action_id
2360: and chk_ppa.action_type = 'H'

Line 2483: INDEX(pa2 PAY_PAYROLL_ACTIONS_N5)

2479: itpflg varchar2,
2480: ptype number
2481: ) is
2482: select /*+ ORDERED
2483: INDEX(pa2 PAY_PAYROLL_ACTIONS_N5)
2484: INDEX(pos PER_PERIODS_OF_SERVICE_N3)
2485: INDEX(as1 PER_ASSIGNMENTS_N4)
2486: INDEX(as2 PER_ASSIGNMENTS_F_PK)
2487: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)

Line 2494: from pay_payroll_actions pa1,

2490: act.assignment_action_id,
2491: act.assignment_id,
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,

Line 2495: pay_payroll_actions pa2,

2491: act.assignment_id,
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,

Line 2554: pay_payroll_actions ppa_void

2550: and not exists (
2551: select null
2552: from pay_assignment_actions paa_void,
2553: pay_action_interlocks pai_void,
2554: pay_payroll_actions ppa_void
2555: where pai_void.locked_action_id = ac2.assignment_action_id
2556: and pai_void.locking_action_id = paa_void.assignment_action_id
2557: and paa_void.payroll_action_id = ppa_void.payroll_action_id
2558: and ppa_void.action_type = 'D')

Line 2572: INDEX(pa2 PAY_PAYROLL_ACTIONS_N5)

2568: itpflg varchar2,
2569: ptype number
2570: ) is
2571: select /*+ ORDERED
2572: INDEX(pa2 PAY_PAYROLL_ACTIONS_N5)
2573: INDEX(pos PER_PERIODS_OF_SERVICE_N3)
2574: INDEX(as1 PER_ASSIGNMENTS_N4)
2575: INDEX(as2 PER_ASSIGNMENTS_F_PK)
2576: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)

Line 2583: from pay_payroll_actions pa1,

2579: act.assignment_action_id,
2580: act.assignment_id,
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,

Line 2584: pay_payroll_actions pa2,

2580: act.assignment_id,
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,

Line 2640: pay_payroll_actions ppa_void

2636: and not exists (
2637: select null
2638: from pay_assignment_actions paa_void,
2639: pay_action_interlocks pai_void,
2640: pay_payroll_actions ppa_void
2641: where pai_void.locked_action_id = ac2.assignment_action_id
2642: and pai_void.locking_action_id = paa_void.assignment_action_id
2643: and paa_void.payroll_action_id = ppa_void.payroll_action_id
2644: and ppa_void.action_type = 'D')

Line 2657: INDEX(pa2 PAY_PAYROLL_ACTIONS_PK)

2653: itpflg varchar2,
2654: ptype number
2655: ) is
2656: select /*+ ORDERED
2657: INDEX(pa2 PAY_PAYROLL_ACTIONS_PK)
2658: INDEX(pos PER_PERIODS_OF_SERVICE_N3)
2659: INDEX(as1 PER_ASSIGNMENTS_N4)
2660: INDEX(as2 PER_ASSIGNMENTS_F_PK)
2661: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)

Line 2668: from pay_payroll_actions pa1,

2664: act.assignment_action_id,
2665: act.assignment_id,
2666: act.tax_unit_id,
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,

Line 2673: pay_payroll_actions pa2,

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,
2676: pay_pre_payments ppp,
2677: pay_org_payment_methods_f opm

Line 2728: pay_payroll_actions ppa_void

2724: and not exists (
2725: select null
2726: from pay_assignment_actions paa_void,
2727: pay_action_interlocks pai_void,
2728: pay_payroll_actions ppa_void
2729: where pai_void.locked_action_id = ac2.assignment_action_id
2730: and pai_void.locking_action_id = paa_void.assignment_action_id
2731: and paa_void.payroll_action_id = ppa_void.payroll_action_id
2732: and ppa_void.action_type = 'D')

Line 2831: index(pa2 PAY_PAYROLL_ACTIONS_N5)

2827: class varchar2,
2828: itpflg varchar2
2829: ) is
2830: select /*+ ORDERED
2831: index(pa2 PAY_PAYROLL_ACTIONS_N5)
2832: index(as1 PER_ASSIGNMENTS_F_N4)
2833: index(as2 PER_ASSIGNMENTS_F_PK)
2834: USE_NL(pop pos as1) */
2835: act.assignment_action_id,

Line 2841: from pay_payroll_actions pa1,

2837: act.tax_unit_id,
2838: as1.person_id,
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,

Line 2842: pay_payroll_actions pa2,

2838: as1.person_id,
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,

Line 2874: pay_payroll_actions pa3,

2870: and (as1.payroll_id = pa1.payroll_id or pa1.payroll_id is null)
2871: and not exists (
2872: select null
2873: from pay_assignment_actions ac2,
2874: pay_payroll_actions pa3,
2875: pay_action_interlocks int
2876: where int.locked_action_id = act.assignment_action_id
2877: and ac2.assignment_action_id = int.locking_action_id
2878: and pa3.payroll_action_id = ac2.payroll_action_id

Line 2904: index(pa2 PAY_PAYROLL_ACTIONS_N5)

2900: class varchar2,
2901: itpflg varchar2
2902: ) is
2903: select /*+ ORDERED
2904: index(pa2 PAY_PAYROLL_ACTIONS_N5)
2905: index(as1 PER_ASSIGNMENTS_F_N4)
2906: index(as2 PER_ASSIGNMENTS_F_PK)
2907: USE_NL(pos as1) */
2908: act.assignment_action_id,

Line 2914: from pay_payroll_actions pa1,

2910: act.tax_unit_id,
2911: as1.person_id,
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,

Line 2915: pay_payroll_actions pa2,

2911: as1.person_id,
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,

Line 2944: pay_payroll_actions pa3,

2940: and (as1.payroll_id = pa1.payroll_id or pa1.payroll_id is null)
2941: and not exists (
2942: select null
2943: from pay_assignment_actions ac2,
2944: pay_payroll_actions pa3,
2945: pay_action_interlocks int
2946: where int.locked_action_id = act.assignment_action_id
2947: and ac2.assignment_action_id = int.locking_action_id
2948: and pa3.payroll_action_id = ac2.payroll_action_id

Line 2973: index(pa2 PAY_PAYROLL_ACTIONS_PK)

2969: class varchar2,
2970: itpflg varchar2
2971: ) is
2972: select /*+ ORDERED
2973: index(pa2 PAY_PAYROLL_ACTIONS_PK)
2974: index(pos PER_PERIODS_OF_SERVICE_N3)
2975: index(act PAY_ASSIGNMENT_ACTIONS_N51)
2976: index(as1 PER_ASSIGNMENTS_F_N4)
2977: index(as2 PER_ASSIGNMENTS_F_PK)

Line 2985: from pay_payroll_actions pa1,

2981: act.tax_unit_id,
2982: as1.person_id,
2983: as1.effective_start_date,
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,

Line 2990: pay_payroll_actions pa2,

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
2993: where pa1.payroll_action_id = pactid
2994: and pa2.payroll_id = pa1.payroll_id

Line 3018: pay_payroll_actions pa3,

3014: and (as1.payroll_id = pa1.payroll_id or pa1.payroll_id is null)
3015: and not exists (
3016: select null
3017: from pay_assignment_actions ac2,
3018: pay_payroll_actions pa3,
3019: pay_action_interlocks int
3020: where int.locked_action_id = act.assignment_action_id
3021: and ac2.assignment_action_id = int.locking_action_id
3022: and pa3.payroll_action_id = ac2.payroll_action_id

Line 3147: index(pa2 PAY_PAYROLL_ACTIONS_N5)

3143: class varchar2,
3144: itpflg varchar2
3145: ) is
3146: select /*+ ORDERED
3147: index(pa2 PAY_PAYROLL_ACTIONS_N5)
3148: index(as1 PER_ASSIGNMENTS_F_N4)
3149: index(as2 PER_ASSIGNMENTS_F_PK)
3150: index(act PAY_ASSIGNMENT_ACTIONS_N51)
3151: USE_NL(pos pop as1) */ -- Bug 14184691 Added hint index(act PAY_ASSIGNMENT_ACTIONS_N51)

Line 3155: from pay_payroll_actions pa1,

3151: USE_NL(pos pop as1) */ -- Bug 14184691 Added hint index(act PAY_ASSIGNMENT_ACTIONS_N51)
3152: act.assignment_action_id,
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,

Line 3156: pay_payroll_actions pa2,

3152: act.assignment_action_id,
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,

Line 3185: pay_payroll_actions pa3,

3181: and (as1.payroll_id = pa1.payroll_id or pa1.payroll_id is null)
3182: and not exists (
3183: select null
3184: from pay_assignment_actions ac2,
3185: pay_payroll_actions pa3,
3186: pay_action_interlocks int
3187: where int.locked_action_id = act.assignment_action_id
3188: and ac2.assignment_action_id = int.locking_action_id
3189: and pa3.payroll_action_id = ac2.payroll_action_id

Line 3215: index(pa2 PAY_PAYROLL_ACTIONS_N5)

3211: class varchar2,
3212: itpflg varchar2
3213: ) is
3214: select /*+ ORDERED
3215: index(pa2 PAY_PAYROLL_ACTIONS_N5)
3216: index(as1 PER_ASSIGNMENTS_F_N4)
3217: index(as2 PER_ASSIGNMENTS_F_PK)
3218: index(act PAY_ASSIGNMENT_ACTIONS_N51)
3219: USE_NL(pos as1) */ -- Bug 14184691 Added hint index(act PAY_ASSIGNMENT_ACTIONS_N51)

Line 3223: from pay_payroll_actions pa1,

3219: USE_NL(pos as1) */ -- Bug 14184691 Added hint index(act PAY_ASSIGNMENT_ACTIONS_N51)
3220: act.assignment_action_id,
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,

Line 3224: pay_payroll_actions pa2,

3220: act.assignment_action_id,
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,

Line 3250: pay_payroll_actions pa3,

3246: and (as1.payroll_id = pa1.payroll_id or pa1.payroll_id is null)
3247: and not exists (
3248: select null
3249: from pay_assignment_actions ac2,
3250: pay_payroll_actions pa3,
3251: pay_action_interlocks int
3252: where int.locked_action_id = act.assignment_action_id
3253: and ac2.assignment_action_id = int.locking_action_id
3254: and pa3.payroll_action_id = ac2.payroll_action_id

Line 3279: index(pa2 PAY_PAYROLL_ACTIONS_PK)

3275: class varchar2,
3276: itpflg varchar2
3277: ) is
3278: select /*+ ORDERED
3279: index(pa2 PAY_PAYROLL_ACTIONS_PK)
3280: index(pos PER_PERIODS_OF_SERVICE_N3)
3281: index(as1 PER_ASSIGNMENTS_F_N4)
3282: index(act PAY_ASSIGNMENT_ACTIONS_N51)
3283: index(as2 PER_ASSIGNMENTS_F_PK)

Line 3288: from pay_payroll_actions pa1,

3284: USE_NL(pos pop act pa2 as2 as1) */
3285: act.assignment_action_id,
3286: act.assignment_id,
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,

Line 3293: pay_payroll_actions pa2,

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
3296: where pa1.payroll_action_id = pactid
3297: and pa2.consolidation_set_id = pa1.consolidation_set_id

Line 3318: pay_payroll_actions pa3,

3314: and (as2.payroll_id = pa1.payroll_id or pa1.payroll_id is null)
3315: and not exists (
3316: select null
3317: from pay_assignment_actions ac2,
3318: pay_payroll_actions pa3,
3319: pay_action_interlocks int
3320: where int.locked_action_id = act.assignment_action_id
3321: and ac2.assignment_action_id = int.locking_action_id
3322: and pa3.payroll_action_id = ac2.payroll_action_id

Line 3423: index(pa2 PAY_PAYROLL_ACTIONS_N5)

3419: class varchar2,
3420: itpflg varchar2
3421: ) is
3422: select /*+ ORDERED
3423: index(pa2 PAY_PAYROLL_ACTIONS_N5)
3424: index(as1 PER_ASSIGNMENTS_F_N4)
3425: index(as2 PER_ASSIGNMENTS_F_PK)
3426: USE_NL(pos pop as1) */
3427: act.assignment_action_id,

Line 3431: from pay_payroll_actions pa1,

3427: act.assignment_action_id,
3428: act.assignment_id,
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,

Line 3432: pay_payroll_actions pa2,

3428: act.assignment_id,
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,

Line 3461: pay_payroll_actions pa3,

3457: and (as1.payroll_id = pa1.payroll_id or pa1.payroll_id is null)
3458: and not exists (
3459: select null
3460: from pay_assignment_actions ac2,
3461: pay_payroll_actions pa3,
3462: pay_action_interlocks int
3463: where int.locked_action_id = act.assignment_action_id
3464: and ac2.assignment_action_id = int.locking_action_id
3465: and pa3.payroll_action_id = ac2.payroll_action_id

Line 3519: pay_payroll_actions pcq,

3515: and ((pa1.batch_process_mode in ('CLEARED', 'ALL')
3516: and exists (select 1
3517: from pay_action_interlocks int,
3518: pay_assignment_actions chq,
3519: pay_payroll_actions pcq,
3520: pay_pre_payments ppp,
3521: pay_org_payment_methods_f pom,
3522: pay_ce_reconciled_payments crp
3523: where int.locking_action_id = act.assignment_action_id

Line 3537: pay_payroll_actions pcq,

3533: or (pa1.batch_process_mode in ('UNCLEARED', 'ALL')
3534: and exists (select 1
3535: from pay_action_interlocks int,
3536: pay_assignment_actions chq,
3537: pay_payroll_actions pcq,
3538: pay_pre_payments ppp,
3539: pay_org_payment_methods_f pom
3540: where int.locking_action_id = act.assignment_action_id
3541: and chq.assignment_action_id = int.locked_action_id

Line 3562: index(pa2 PAY_PAYROLL_ACTIONS_N5)

3558: class varchar2,
3559: itpflg varchar2
3560: ) is
3561: select /*+ ORDERED
3562: index(pa2 PAY_PAYROLL_ACTIONS_N5)
3563: index(as1 PER_ASSIGNMENTS_F_N4)
3564: index(as2 PER_ASSIGNMENTS_F_PK)
3565: USE_NL(pos as1) */
3566: act.assignment_action_id,

Line 3570: from pay_payroll_actions pa1,

3566: act.assignment_action_id,
3567: act.assignment_id,
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,

Line 3571: pay_payroll_actions pa2,

3567: act.assignment_id,
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,

Line 3597: pay_payroll_actions pa3,

3593: and (as1.payroll_id = pa1.payroll_id or pa1.payroll_id is null)
3594: and not exists (
3595: select null
3596: from pay_assignment_actions ac2,
3597: pay_payroll_actions pa3,
3598: pay_action_interlocks int
3599: where int.locked_action_id = act.assignment_action_id
3600: and ac2.assignment_action_id = int.locking_action_id
3601: and pa3.payroll_action_id = ac2.payroll_action_id

Line 3655: pay_payroll_actions pcq,

3651: and ((pa1.batch_process_mode in ('CLEARED', 'ALL')
3652: and exists (select 1
3653: from pay_action_interlocks int,
3654: pay_assignment_actions chq,
3655: pay_payroll_actions pcq,
3656: pay_pre_payments ppp,
3657: pay_org_payment_methods_f pom,
3658: pay_ce_reconciled_payments crp
3659: where int.locking_action_id = act.assignment_action_id

Line 3673: pay_payroll_actions pcq,

3669: or (pa1.batch_process_mode in ('UNCLEARED', 'ALL')
3670: and exists (select 1
3671: from pay_action_interlocks int,
3672: pay_assignment_actions chq,
3673: pay_payroll_actions pcq,
3674: pay_pre_payments ppp,
3675: pay_org_payment_methods_f pom
3676: where int.locking_action_id = act.assignment_action_id
3677: and chq.assignment_action_id = int.locked_action_id

Line 3697: index(pa2 PAY_PAYROLL_ACTIONS_PK)

3693: class varchar2,
3694: itpflg varchar2
3695: ) is
3696: select /*+ ORDERED
3697: index(pa2 PAY_PAYROLL_ACTIONS_PK)
3698: index(pos PER_PERIODS_OF_SERVICE_N3)
3699: index(as1 PER_ASSIGNMENTS_F_N4)
3700: index(act PAY_ASSIGNMENT_ACTIONS_N51)
3701: index(as2 PER_ASSIGNMENTS_F_PK)

Line 3707: from pay_payroll_actions pa1,

3703: act.assignment_action_id,
3704: act.assignment_id,
3705: act.tax_unit_id,
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,

Line 3712: pay_payroll_actions pa2,

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
3715: where pa1.payroll_action_id = pactid
3716: and pa2.consolidation_set_id = pa1.consolidation_set_id

Line 3737: pay_payroll_actions pa3,

3733: and (as2.payroll_id = pa1.payroll_id or pa1.payroll_id is null)
3734: and not exists (
3735: select null
3736: from pay_assignment_actions ac2,
3737: pay_payroll_actions pa3,
3738: pay_action_interlocks int
3739: where int.locked_action_id = act.assignment_action_id
3740: and ac2.assignment_action_id = int.locking_action_id
3741: and pa3.payroll_action_id = ac2.payroll_action_id

Line 3795: pay_payroll_actions pcq,

3791: and ((pa1.batch_process_mode in ('CLEARED', 'ALL')
3792: and exists (select 1
3793: from pay_action_interlocks int,
3794: pay_assignment_actions chq,
3795: pay_payroll_actions pcq,
3796: pay_pre_payments ppp,
3797: pay_org_payment_methods_f pom,
3798: pay_ce_reconciled_payments crp
3799: where int.locking_action_id = act.assignment_action_id

Line 3813: pay_payroll_actions pcq,

3809: or (pa1.batch_process_mode in ('UNCLEARED', 'ALL')
3810: and exists (select 1
3811: from pay_action_interlocks int,
3812: pay_assignment_actions chq,
3813: pay_payroll_actions pcq,
3814: pay_pre_payments ppp,
3815: pay_org_payment_methods_f pom
3816: where int.locking_action_id = act.assignment_action_id
3817: and chq.assignment_action_id = int.locked_action_id

Line 3918: index(pa2 PAY_PAYROLL_ACTIONS_N5)

3914: class varchar2,
3915: itpflg varchar2
3916: ) is
3917: select /*+ ORDERED
3918: index(pa2 PAY_PAYROLL_ACTIONS_N5)
3919: index(as1 PER_ASSIGNMENTS_F_N4)
3920: index(as2 PER_ASSIGNMENTS_F_PK)
3921: USE_NL(pop pos as1) */
3922: act.assignment_action_id,

Line 3925: from pay_payroll_actions pa1,

3921: USE_NL(pop pos as1) */
3922: act.assignment_action_id,
3923: act.assignment_id,
3924: act.tax_unit_id
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,

Line 3928: pay_payroll_actions pa2,

3924: act.tax_unit_id
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,

Line 3985: index(pa2 PAY_PAYROLL_ACTIONS_N5)

3981: class varchar2,
3982: itpflg varchar2
3983: ) is
3984: select /*+ ORDERED
3985: index(pa2 PAY_PAYROLL_ACTIONS_N5)
3986: index(as1 PER_ASSIGNMENTS_F_N4)
3987: index(as2 PER_ASSIGNMENTS_F_PK)
3988: USE_NL(pos as1) */
3989: act.assignment_action_id,

Line 3992: from pay_payroll_actions pa1,

3988: USE_NL(pos as1) */
3989: act.assignment_action_id,
3990: act.assignment_id,
3991: act.tax_unit_id
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,

Line 3995: pay_payroll_actions pa2,

3991: act.tax_unit_id
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,

Line 4112: from pay_payroll_actions pac,

4108: pactid number,
4109: chunk number
4110: ) is
4111: select asg.assignment_id
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

Line 4137: from pay_payroll_actions pac,

4133: stperson number,
4134: endperson number
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'

Line 4222: index(pa2 PAY_PAYROLL_ACTIONS_N5)

4218: chunk number,
4219: itpflg varchar2
4220: ) is
4221: select /*+ ORDERED
4222: index(pa2 PAY_PAYROLL_ACTIONS_N5)
4223: index(as1 PER_ASSIGNMENTS_F_PK)
4224: index(as2 PER_ASSIGNMENTS_F_N4)
4225: index(ac2 PAY_ASSIGNMENT_ACTIONS_N51)
4226: USE_NL(pop pos as1 as2) */ -- Bug 14184691 Added hint index(ac2 PAY_ASSIGNMENT_ACTIONS_N51)

Line 4231: from pay_payroll_actions pa,

4227: ac2.assignment_action_id,
4228: ac2.assignment_id,
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,

Line 4232: pay_payroll_actions pa2,

4228: ac2.assignment_id,
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,

Line 4263: pay_payroll_actions pa3,

4259: and pos.person_id = pop.person_id
4260: and not exists (
4261: select null
4262: from pay_assignment_actions ac3,
4263: pay_payroll_actions pa3,
4264: pay_action_interlocks in3
4265: where in3.locked_action_id = ac2.assignment_action_id
4266: and ac3.assignment_action_id = in3.locking_action_id
4267: and pa3.payroll_action_id = ac3.payroll_action_id

Line 4292: index(pa2 PAY_PAYROLL_ACTIONS_N5)

4288: endperson number,
4289: itpflg varchar2
4290: ) is
4291: select /*+ ORDERED
4292: index(pa2 PAY_PAYROLL_ACTIONS_N5)
4293: index(as1 PER_ASSIGNMENTS_F_PK)
4294: index(as2 PER_ASSIGNMENTS_F_N4)
4295: index(ac2 PAY_ASSIGNMENT_ACTIONS_N51)
4296: USE_NL(pos as1 as2) */ -- Bug 14184691 Added hint index(ac2 PAY_ASSIGNMENT_ACTIONS_N51)

Line 4301: from pay_payroll_actions pa,

4297: ac2.assignment_action_id,
4298: ac2.assignment_id,
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,

Line 4302: pay_payroll_actions pa2,

4298: ac2.assignment_id,
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,

Line 4331: pay_payroll_actions pa3,

4327: stperson and endperson
4328: and not exists (
4329: select null
4330: from pay_assignment_actions ac3,
4331: pay_payroll_actions pa3,
4332: pay_action_interlocks in3
4333: where in3.locked_action_id = ac2.assignment_action_id
4334: and ac3.assignment_action_id = in3.locking_action_id
4335: and pa3.payroll_action_id = ac3.payroll_action_id

Line 4359: index(pa2 PAY_PAYROLL_ACTIONS_PK)

4355: chunk number,
4356: itpflg varchar2
4357: ) is
4358: select /*+ ORDERED
4359: index(pa2 PAY_PAYROLL_ACTIONS_PK)
4360: index(pos PER_PERIODS_OF_SERVICE_N3)
4361: index(as2 PER_ASSIGNMENTS_F_N4)
4362: index(ac2 PAY_ASSIGNMENT_ACTIONS_N51)
4363: index(as1 PER_ASSIGNMENTS_F_PK)

Line 4369: from pay_payroll_actions pa,

4365: ac2.assignment_action_id,
4366: ac2.assignment_id,
4367: ac2.tax_unit_id,
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,

Line 4374: pay_payroll_actions pa2,

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
4377: where pa.payroll_action_id = pactid
4378: and pa2.consolidation_set_id = pa.consolidation_set_id

Line 4401: pay_payroll_actions pa3,

4397: and pos.person_id = pop.person_id
4398: and not exists (
4399: select null
4400: from pay_assignment_actions ac3,
4401: pay_payroll_actions pa3,
4402: pay_action_interlocks in3
4403: where in3.locked_action_id = ac2.assignment_action_id
4404: and ac3.assignment_action_id = in3.locking_action_id
4405: and pa3.payroll_action_id = ac3.payroll_action_id

Line 4430: pay_payroll_actions pa1,

4426: ) is
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

Line 4433: pay_payroll_actions pa

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
4437: and ac1.source_action_id is null

Line 4449: actype pay_payroll_actions.action_type%TYPE;

4445: --
4446: lockingactid number;
4447: lockedactid number;
4448: assignid number;
4449: actype pay_payroll_actions.action_type%TYPE;
4450: pmnt_act_type pay_payroll_actions.action_type%TYPE;
4451: prepay_aa_id number;
4452: runactid number;
4453: greid number;

Line 4450: pmnt_act_type pay_payroll_actions.action_type%TYPE;

4446: lockingactid number;
4447: lockedactid number;
4448: assignid number;
4449: actype pay_payroll_actions.action_type%TYPE;
4450: pmnt_act_type pay_payroll_actions.action_type%TYPE;
4451: prepay_aa_id number;
4452: runactid number;
4453: greid number;
4454: not_paid number;

Line 4517: pay_payroll_actions pa

4513: select distinct(pa.action_type)
4514: into pmnt_act_type
4515: from pay_action_interlocks int,
4516: pay_assignment_actions aa,
4517: pay_payroll_actions pa
4518: where int.locking_action_id = lockedactid
4519: and aa.assignment_action_id = int.locked_action_id
4520: and pa.payroll_action_id = aa.payroll_action_id;
4521:

Line 4531: pay_payroll_actions ppa

4527: from pay_action_interlocks int,
4528: pay_pre_payments ppp,
4529: pay_org_payment_methods_f opm,
4530: pay_assignment_actions paa,
4531: pay_payroll_actions ppa
4532: where int.locking_action_id = lockedactid
4533: and ppp.assignment_action_id = int.locked_action_id
4534: and paa.assignment_action_id = ppp.assignment_action_id
4535: and paa.payroll_action_id = ppa.payroll_action_id /* Bug 8619201 - Date eff. join */

Line 4597: pay_payroll_actions pa1

4593: ac1.assignment_id,
4594: ac1.tax_unit_id,
4595: pa1.action_type
4596: from pay_assignment_actions ac1,
4597: pay_payroll_actions pa1
4598: where pa1.payroll_action_id = pactid
4599: and pa1.target_payroll_action_id = ac1.payroll_action_id
4600: and not exists (
4601: select 1

Line 4611: atype pay_payroll_actions.action_type%type;

4607: lockingactid number;
4608: lockedactid number;
4609: assignid number;
4610: greid number;
4611: atype pay_payroll_actions.action_type%type;
4612: --
4613: begin
4614: open qpcur(pactid);
4615: fetch qpcur into lockedactid, assignid, greid, atype;

Line 4664: pay_payroll_actions ppa

4660: begin
4661: select assignment_action_code
4662: into action_proc
4663: from pay_report_format_mappings_f prfm,
4664: pay_payroll_actions ppa
4665: where ppa.payroll_action_id = pactid
4666: and ppa.report_type = prfm.report_type
4667: and ppa.report_qualifier = prfm.report_qualifier
4668: and ppa.report_category = prfm.report_category

Line 4728: INDEX(pa2 PAY_PAYROLL_ACTIONS_N5)

4724: itpflg varchar2,
4725: ptype number
4726: ) is
4727: select /*+ ORDERED
4728: INDEX(pa2 PAY_PAYROLL_ACTIONS_N5)
4729: INDEX(pos PER_PERIODS_OF_SERVICE_N3)
4730: INDEX(as1 PER_ASSIGNMENTS_N4)
4731: INDEX(as2 PER_ASSIGNMENTS_F_PK)
4732: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)

Line 4739: from pay_payroll_actions pa1,

4735: act.assignment_action_id,
4736: act.assignment_id,
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,

Line 4740: pay_payroll_actions pa2,

4736: act.assignment_id,
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,

Line 4799: pay_payroll_actions ppa_void

4795: and not exists (
4796: select null
4797: from pay_assignment_actions paa_void,
4798: pay_action_interlocks pai_void,
4799: pay_payroll_actions ppa_void
4800: where pai_void.locked_action_id = ac2.assignment_action_id
4801: and pai_void.locking_action_id = paa_void.assignment_action_id
4802: and paa_void.payroll_action_id = ppa_void.payroll_action_id
4803: and ppa_void.action_type = 'D')

Line 4817: INDEX(pa2 PAY_PAYROLL_ACTIONS_N5)

4813: itpflg varchar2,
4814: ptype number
4815: ) is
4816: select /*+ ORDERED
4817: INDEX(pa2 PAY_PAYROLL_ACTIONS_N5)
4818: INDEX(pos PER_PERIODS_OF_SERVICE_N3)
4819: INDEX(as1 PER_ASSIGNMENTS_N4)
4820: INDEX(as2 PER_ASSIGNMENTS_F_PK)
4821: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)

Line 4828: from pay_payroll_actions pa1,

4824: act.assignment_action_id,
4825: act.assignment_id,
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,

Line 4829: pay_payroll_actions pa2,

4825: act.assignment_id,
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,

Line 4885: pay_payroll_actions ppa_void

4881: and not exists (
4882: select null
4883: from pay_assignment_actions paa_void,
4884: pay_action_interlocks pai_void,
4885: pay_payroll_actions ppa_void
4886: where pai_void.locked_action_id = ac2.assignment_action_id
4887: and pai_void.locking_action_id = paa_void.assignment_action_id
4888: and paa_void.payroll_action_id = ppa_void.payroll_action_id
4889: and ppa_void.action_type = 'D')

Line 4902: INDEX(pa2 PAY_PAYROLL_ACTIONS_PK)

4898: itpflg varchar2,
4899: ptype number
4900: ) is
4901: select /*+ ORDERED
4902: INDEX(pa2 PAY_PAYROLL_ACTIONS_PK)
4903: INDEX(pos PER_PERIODS_OF_SERVICE_N3)
4904: INDEX(as1 PER_ASSIGNMENTS_N4)
4905: INDEX(as2 PER_ASSIGNMENTS_F_PK)
4906: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)

Line 4913: from pay_payroll_actions pa1,

4909: act.assignment_action_id,
4910: act.assignment_id,
4911: act.tax_unit_id,
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,

Line 4918: pay_payroll_actions pa2,

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,
4921: pay_pre_payments ppp,
4922: pay_org_payment_methods_f opm

Line 4973: pay_payroll_actions ppa_void

4969: and not exists (
4970: select null
4971: from pay_assignment_actions paa_void,
4972: pay_action_interlocks pai_void,
4973: pay_payroll_actions ppa_void
4974: where pai_void.locked_action_id = ac2.assignment_action_id
4975: and pai_void.locking_action_id = paa_void.assignment_action_id
4976: and paa_void.payroll_action_id = ppa_void.payroll_action_id
4977: and ppa_void.action_type = 'D')

Line 5091: pay_payroll_Actions pact

5087: elsif (atype = PREPAY) then
5088: select nvl(multi_assignments_flag, 'N')
5089: into multi_asg_fg
5090: from pay_all_payrolls_f prl,
5091: pay_payroll_Actions pact
5092: where pact.payroll_action_id = pactid
5093: and prl.payroll_id = pact.payroll_id
5094: and pact.effective_date between prl.effective_start_date
5095: and prl.effective_end_date;

Line 5143: lockname => 'PAY_PAYROLL_ACTIONS_'||pactid,

5139: g_many_procs_in_period := 'Y';
5140: end if;
5141: --
5142: dbms_lock.allocate_unique(
5143: lockname => 'PAY_PAYROLL_ACTIONS_'||pactid,
5144: lockhandle => g_lckhandle);
5145: --
5146: loop
5147: -- start by processing the range row.

Line 5253: from pay_payroll_actions ppa

5249: is
5250: select ppa.action_status
5251: , ppa.action_type
5252: , rfm.report_name
5253: from pay_payroll_actions ppa
5254: , pay_report_format_mappings_f rfm
5255: where ppa.payroll_action_id = p_pact_id
5256: and ppa.report_type = rfm.report_type(+)
5257: and ppa.report_qualifier = rfm.report_qualifier(+)

Line 5289: l_act_status pay_payroll_actions.action_status%type;

5285: from pay_assignment_actions
5286: where payroll_action_id = p_ppa_id
5287: group by chunk_number) v2);
5288: --
5289: l_act_status pay_payroll_actions.action_status%type;
5290: l_act_type pay_payroll_actions.action_type%type;
5291: l_rep_name pay_report_format_mappings_f.report_name%type;
5292: l_chunk pay_assignment_actions.chunk_number%type;
5293: l_asg_act_id pay_assignment_actions.assignment_action_id%type;

Line 5290: l_act_type pay_payroll_actions.action_type%type;

5286: where payroll_action_id = p_ppa_id
5287: group by chunk_number) v2);
5288: --
5289: l_act_status pay_payroll_actions.action_status%type;
5290: l_act_type pay_payroll_actions.action_type%type;
5291: l_rep_name pay_report_format_mappings_f.report_name%type;
5292: l_chunk pay_assignment_actions.chunk_number%type;
5293: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
5294: --