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.PAY_US_TAXBAL_VIEW_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 297: pay_assignment_actions paa,

293:
294: cursor c_prepay_action (cp_run_action_id number) is
295: select paa.assignment_action_id
296: from pay_action_interlocks pai,
297: pay_assignment_actions paa,
298: pay_payroll_actions ppa
299: where pai.locked_action_id = cp_run_action_id
300: and paa.assignment_action_id = pai.locking_action_id
301: and ppa.payroll_action_id = paa.payroll_action_id

Line 315: pay_assignment_actions paa

311: CURSOR c_count_runs(cp_pre_pymt_action_id NUMBER ) IS
312: select count(pai.locked_action_id)
313: from pay_action_interlocks pai,
314: pay_pre_payments ppp,
315: pay_assignment_actions paa
316: where ppp.assignment_action_id = cp_pre_pymt_action_id
317: and nvl(ppp.source_action_id,0) <> pai.locked_action_id
318: and pai.locking_action_id = ppp.assignment_action_id
319: and pai.locked_action_id = paa.assignment_action_id

Line 327: pay_assignment_actions paa

323:
324: CURSOR c_count_runs(cp_pre_pymt_action_id NUMBER , cp_run_type_id NUMBER) IS
325: select count(pai.locked_action_id)
326: from pay_action_interlocks pai,
327: pay_assignment_actions paa
328: where pai.locking_action_id = cp_pre_pymt_action_id
329: and pai.locked_action_id = paa.assignment_action_id
330: and nvl(paa.run_type_id,cp_run_type_id) <> cp_run_type_id
331: and paa.source_action_id is not null;

Line 623: from pay_assignment_actions PAA,

619: c_date_earned in date,
620: c_date2_earned in date )
621: is
622: select distinct PAA.assignment_id
623: from pay_assignment_actions PAA,
624: pay_payroll_actions PPA
625: where PAA.tax_unit_id = c_tax_unit_id
626: and PPA.payroll_action_id = PAA.payroll_action_id
627: and PPA.effective_date >= trunc(c_date_earned,'Q')

Line 636: from pay_assignment_actions PAA,

632: c_date_earned in date,
633: c_date2_earned in date )
634: is
635: select distinct PAA.assignment_id
636: from pay_assignment_actions PAA,
637: pay_payroll_actions PPA
638: where PAA.tax_unit_id = c_tax_unit_id
639: and PPA.payroll_action_id = PAA.payroll_action_id
640: and PPA.effective_date >= trunc(c_date_earned,'Y')

Line 661: pay_assignment_actions PAA

657: substr(c_jurisdiction_code, 1, PBT.jurisdiction_level)
658: and exists
659: (select 1
660: from pay_payroll_actions PPA,
661: pay_assignment_actions PAA
662: where PAA.assignment_id = PAR.assignment_id
663: and PAA.tax_unit_id = PAR.tax_unit_id
664: and PPA.payroll_action_id = PAA.payroll_action_id
665: and PPA.effective_date >= trunc(c_date_earned,'Y')

Line 743: pay_assignment_actions paa,

739: from dual
740: where exists (
741: select ''
742: from pay_payroll_actions ppa,
743: pay_assignment_actions paa,
744: pay_assignment_latest_balances palb
745: where palb.assignment_id = p_assignment_id
746: and palb.defined_balance_id = l_defined_balance_id
747: and palb.assignment_action_id =

Line 1166: from pay_assignment_actions paa2,

1162: FUNCTION get_prepayment_aaid (p_assignment_action_id number DEFAULT NULL)
1163: RETURN number is
1164: cursor prepayment_aaid(param_aaid number) is
1165: select pai.locking_action_id
1166: from pay_assignment_actions paa2,
1167: pay_payroll_actions ppa2,
1168: pay_action_interlocks pai,
1169: pay_assignment_actions paa,
1170: pay_payroll_actions ppa

Line 1169: pay_assignment_actions paa,

1165: select pai.locking_action_id
1166: from pay_assignment_actions paa2,
1167: pay_payroll_actions ppa2,
1168: pay_action_interlocks pai,
1169: pay_assignment_actions paa,
1170: pay_payroll_actions ppa
1171: where pai.locked_Action_id = param_aaid
1172: and pai.locking_action_id = pai.locking_action_id
1173: and pai.locking_action_id = paa.assignment_action_id

Line 1182: pay_assignment_Actions paae,

1178: and ppa2.action_type in ('R','Q')
1179: /*
1180: and exists ( select locked_action_id,locking_action_id
1181: from pay_action_interlocks paie,
1182: pay_assignment_Actions paae,
1183: pay_payroll_Actions ppae
1184: where paie.locked_action_id = pai2.locked_action_id
1185: and paie.locking_action_id = paae.assignment_action_id
1186: and paae.payroll_Action_id = ppae.payroll_Action_id

Line 1222: from pay_assignment_actions paa

1218: cursor c_run_action_info
1219: (cp_assignment_action_id in number) is
1220: select run_type_id,
1221: assignment_id
1222: from pay_assignment_actions paa
1223: where paa.assignment_action_id = cp_assignment_action_id;
1224:
1225: cursor c_run_actions (cp_pre_pay_action_id in number,
1226: cp_sep_check_run_type_id in number,

Line 1230: pay_assignment_actions paa,

1226: cp_sep_check_run_type_id in number,
1227: cp_run_assignment_id in number) is
1228: select pai.locked_action_id
1229: from pay_payroll_actions ppa,
1230: pay_assignment_actions paa,
1231: pay_action_interlocks pai
1232: where pai.locking_action_id = cp_pre_pay_action_id
1233: and pai.locked_action_id = paa.assignment_action_id
1234: and paa.assignment_id = cp_run_assignment_id

Line 1329: from pay_assignment_actions paa

1325: cursor c_run_action_info
1326: (cp_assignment_action_id in number) is
1327: select run_type_id,
1328: assignment_id
1329: from pay_assignment_actions paa
1330: where paa.assignment_action_id = cp_assignment_action_id;
1331:
1332: cursor c_run_actions (cp_pre_pay_action_id in number,
1333: cp_sep_check_run_type_id in number,

Line 1337: pay_assignment_actions paa,

1333: cp_sep_check_run_type_id in number,
1334: cp_run_assignment_id in number) is
1335: select pai.locked_action_id
1336: from pay_payroll_actions ppa,
1337: pay_assignment_actions paa,
1338: pay_action_interlocks pai
1339: where pai.locking_action_id = cp_pre_pay_action_id
1340: and pai.locked_action_id = paa.assignment_action_id
1341: and paa.assignment_id = cp_run_assignment_id

Line 1434: from pay_assignment_actions paa, -- assignment_action for master payroll run

1430:
1431: CURSOR C_GET_MASTER_AAID (cp_prepay_action_id in number,
1432: cp_assignment_id in number) is
1433: select max(paa.assignment_action_id)
1434: from pay_assignment_actions paa, -- assignment_action for master payroll run
1435: pay_action_interlocks pai
1436: where pai.locking_action_id = cp_prepay_action_id
1437: and pai.locked_action_id = paa.assignment_action_id
1438: and paa.assignment_id = cp_assignment_id

Line 1518: FROM pay_assignment_actions paa

1514: SELECT DECODE(prt.shortname,'SEPCHECK','Y','N'),
1515: paa.assignment_id
1516: INTO l_sep_check,
1517: l_assignment_id
1518: FROM pay_assignment_actions paa
1519: ,pay_run_types_f prt
1520: WHERE paa.assignment_action_id = l_assignment_action_id
1521: AND prt.run_type_id = paa.run_type_id
1522: AND prt.legislation_code = 'US';

Line 1535: pay_assignment_actions paa,

1531:
1532: select paa.assignment_action_id
1533: into l_pre_pay_aaid
1534: from pay_action_interlocks pai,
1535: pay_assignment_actions paa,
1536: pay_payroll_actions ppa
1537: where pai.locked_action_id = l_assignment_action_id
1538: and paa.assignment_action_id = pai.locking_action_id
1539: and paa.source_action_id is NULL -- master pre-payment action.

Line 1621: from pay_assignment_actions paa, -- assignment_action for master payroll run

1617:
1618: CURSOR C_GET_MASTER_AAID (cp_prepay_action_id in number,
1619: cp_assignment_id in number) is
1620: select max(paa.assignment_action_id)
1621: from pay_assignment_actions paa, -- assignment_action for master payroll run
1622: pay_action_interlocks pai
1623: where pai.locking_action_id = cp_prepay_action_id
1624: and pai.locked_action_id = paa.assignment_action_id
1625: and paa.assignment_id = cp_assignment_id

Line 1705: FROM pay_assignment_actions paa

1701: SELECT DECODE(prt.shortname,'SEPCHECK','Y','N'),
1702: paa.assignment_id
1703: INTO l_sep_check,
1704: l_assignment_id
1705: FROM pay_assignment_actions paa
1706: ,pay_run_types_f prt
1707: WHERE paa.assignment_action_id = l_assignment_action_id
1708: AND prt.run_type_id = paa.run_type_id
1709: AND prt.legislation_code = 'US';

Line 1722: pay_assignment_actions paa,

1718:
1719: select paa.assignment_action_id
1720: into l_pre_pay_aaid
1721: from pay_action_interlocks pai,
1722: pay_assignment_actions paa,
1723: pay_payroll_actions ppa
1724: where pai.locked_action_id = l_assignment_action_id
1725: and paa.assignment_action_id = pai.locking_action_id
1726: and paa.source_action_id is NULL -- master pre-payment action.

Line 1834: from pay_assignment_actions

1830: -- doing group function (min)
1831: --
1832: CURSOR get_pay_action_id IS
1833: select assignment_action_id
1834: from pay_assignment_actions
1835: where payroll_action_id = p_payroll_action_id;
1836: --
1837: l_return_value number;
1838: l_test number;

Line 2196: from pay_assignment_actions paa,

2192: begin /* Modified the query for performance (Bug 3343982)*/
2193:
2194: select min(paa.assignment_id)
2195: into l_assignment_id
2196: from pay_assignment_actions paa,
2197: pay_payroll_actions pact,
2198: pay_payrolls_f ppf
2199: where pact.effective_date <= p_virtual_date
2200: and pact.payroll_action_id=paa.payroll_action_id

Line 2924: , pay_assignment_actions ASSACT

2920: nvl(sum(decode(FEED.balance_type_id,c_balance_type_id10,TARGET.result_value * FEED.scale,0)),0)
2921: FROM pay_balance_feeds_f FEED
2922: , pay_run_result_values TARGET
2923: , pay_run_results RR
2924: , pay_assignment_actions ASSACT
2925: , pay_payroll_actions PACT
2926: where PACT.effective_date between trunc(p_effective_date,'Y')
2927: and p_effective_date
2928: and PACT.action_type in ('R','Q','I','B','V')

Line 3133: , pay_assignment_actions ASSACT

3129: nvl(sum(decode(FEED.balance_type_id,c_balance_type_id12,TARGET.result_value * FEED.scale,0)),0)
3130: FROM pay_balance_feeds_f FEED
3131: , pay_run_result_values TARGET
3132: , pay_run_results RR
3133: , pay_assignment_actions ASSACT
3134: , pay_payroll_actions PACT
3135: where PACT.effective_date between trunc(p_effective_date,'Q')
3136: and p_effective_date
3137: and PACT.action_type in ('R','Q','I','B','V')

Line 3256: , pay_assignment_actions ASSACT

3252: FROM
3253: pay_balance_feeds_f FEED
3254: , pay_run_result_values TARGET
3255: , pay_run_results RR
3256: , pay_assignment_actions ASSACT
3257: , pay_payroll_actions PACT
3258: where PACT.effective_date between trunc(c_effective_date,'Y')
3259: and c_effective_date
3260: and PACT.action_type in ('R','Q','I','B','V')

Line 3363: , pay_assignment_actions ASSACT

3359: FROM
3360: pay_balance_feeds_f FEED
3361: , pay_run_result_values TARGET
3362: , pay_run_results RR
3363: , pay_assignment_actions ASSACT
3364: , pay_payroll_actions PACT
3365: where PACT.effective_date between trunc(c_effective_date,'Q')
3366: and c_effective_date
3367: and PACT.action_type in ('R','Q','I','B','V')

Line 3479: , pay_assignment_actions ASSACT

3475: FROM
3476: pay_balance_feeds_f FEED
3477: , pay_run_result_values TARGET
3478: , pay_run_results RR
3479: , pay_assignment_actions ASSACT
3480: , pay_payroll_actions PACT
3481: , (select distinct puar.assignment_id assignment_id
3482: from pay_us_asg_reporting puar
3483: where puar.tax_unit_id = c_tax_unit_id

Line 3593: , pay_assignment_actions ASSACT

3589: FROM
3590: pay_balance_feeds_f FEED
3591: , pay_run_result_values TARGET
3592: , pay_run_results RR
3593: , pay_assignment_actions ASSACT
3594: , pay_payroll_actions PACT
3595: , (select distinct puar.assignment_id assignment_id
3596: from pay_us_asg_reporting puar
3597: where puar.tax_unit_id = c_tax_unit_id

Line 3725: , pay_assignment_actions ASSACT

3721: nvl(sum(decode(FEED.balance_type_id,c_balance_type_id10,TARGET.result_value * FEED.scale,0)),0)
3722: FROM pay_balance_feeds_f FEED
3723: , pay_run_result_values TARGET
3724: , pay_run_results RR
3725: , pay_assignment_actions ASSACT
3726: , pay_payroll_actions PACT
3727: where PACT.effective_date between trunc(p_effective_date,'MON')
3728: and p_effective_date
3729: and PACT.action_type in ('R','Q','I','B','V')

Line 3871: , pay_assignment_actions ASSACT

3867: nvl(sum(decode(FEED.balance_type_id,c_balance_type_id10,TARGET.result_value * FEED.scale,0)),0)
3868: FROM pay_balance_feeds_f FEED
3869: , pay_run_result_values TARGET
3870: , pay_run_results RR
3871: , pay_assignment_actions ASSACT
3872: , pay_payroll_actions PACT
3873: where PACT.effective_date between p_start_date
3874: and p_effective_date
3875: and PACT.action_type in ('R','Q','I','B','V')

Line 3988: , pay_assignment_actions ASSACT

3984: FROM
3985: pay_balance_feeds_f FEED
3986: , pay_run_result_values TARGET
3987: , pay_run_results RR
3988: , pay_assignment_actions ASSACT
3989: , pay_payroll_actions PACT
3990: where PACT.effective_date between trunc(c_effective_date,'MON')
3991: and c_effective_date
3992: and PACT.action_type in ('R','Q','I','B','V')

Line 4096: , pay_assignment_actions ASSACT

4092: FROM
4093: pay_balance_feeds_f FEED
4094: , pay_run_result_values TARGET
4095: , pay_run_results RR
4096: , pay_assignment_actions ASSACT
4097: , pay_payroll_actions PACT
4098: where PACT.effective_date between c_start_date
4099: and c_effective_date
4100: and PACT.action_type in ('R','Q','I','B','V')

Line 4213: , pay_assignment_actions ASSACT

4209: FROM
4210: pay_balance_feeds_f FEED
4211: , pay_run_result_values TARGET
4212: , pay_run_results RR
4213: , pay_assignment_actions ASSACT
4214: , pay_payroll_actions PACT
4215: , (select distinct puar.assignment_id assignment_id
4216: from pay_us_asg_reporting puar
4217: where puar.tax_unit_id = c_tax_unit_id

Line 4330: , pay_assignment_actions ASSACT

4326: FROM
4327: pay_balance_feeds_f FEED
4328: , pay_run_result_values TARGET
4329: , pay_run_results RR
4330: , pay_assignment_actions ASSACT
4331: , pay_payroll_actions PACT
4332: , (select distinct puar.assignment_id assignment_id
4333: from pay_us_asg_reporting puar
4334: where puar.tax_unit_id = c_tax_unit_id