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_PAYROLL_ACTIONS

Line 329: pay_payroll_actions ppa

325: cursor c_prepay_action (cp_run_action_id number) is
326: select paa.assignment_action_id
327: from pay_action_interlocks pai,
328: pay_assignment_actions paa,
329: pay_payroll_actions ppa
330: where pai.locked_action_id = cp_run_action_id
331: and paa.assignment_action_id = pai.locking_action_id
332: and ppa.payroll_action_id = paa.payroll_action_id
333: and ppa.action_type in ('P', 'U');

Line 655: pay_payroll_actions PPA

651: c_date2_earned in date )
652: is
653: select distinct PAA.assignment_id
654: from pay_assignment_actions PAA,
655: pay_payroll_actions PPA
656: where PAA.tax_unit_id = c_tax_unit_id
657: and PPA.payroll_action_id = PAA.payroll_action_id
658: and PPA.effective_date >= trunc(c_date_earned,'Q')
659: and PPA.effective_date <= c_date2_earned

Line 668: pay_payroll_actions PPA

664: c_date2_earned in date )
665: is
666: select distinct PAA.assignment_id
667: from pay_assignment_actions PAA,
668: pay_payroll_actions PPA
669: where PAA.tax_unit_id = c_tax_unit_id
670: and PPA.payroll_action_id = PAA.payroll_action_id
671: and PPA.effective_date >= trunc(c_date_earned,'Y')
672: and PPA.effective_date <= c_date2_earned

Line 691: from pay_payroll_actions PPA,

687: and substr(PAR.jurisdiction_code, 1, PBT.jurisdiction_level) =
688: substr(c_jurisdiction_code, 1, PBT.jurisdiction_level)
689: and exists
690: (select 1
691: from pay_payroll_actions PPA,
692: pay_assignment_actions PAA
693: where PAA.assignment_id = PAR.assignment_id
694: and PAA.tax_unit_id = PAR.tax_unit_id
695: and PPA.payroll_action_id = PAA.payroll_action_id

Line 773: from pay_payroll_actions ppa,

769: into l_dummy
770: from dual
771: where exists (
772: select ''
773: from pay_payroll_actions ppa,
774: pay_assignment_actions paa,
775: pay_assignment_latest_balances palb
776: where palb.assignment_id = p_assignment_id
777: and palb.defined_balance_id = l_defined_balance_id

Line 1263: pay_payroll_actions ppa2,

1259: RETURN number is
1260: cursor prepayment_aaid(param_aaid number) is
1261: select pai.locking_action_id
1262: from pay_assignment_actions paa2,
1263: pay_payroll_actions ppa2,
1264: pay_action_interlocks pai,
1265: pay_assignment_actions paa,
1266: pay_payroll_actions ppa
1267: where pai.locked_Action_id = param_aaid

Line 1266: pay_payroll_actions ppa

1262: from pay_assignment_actions paa2,
1263: pay_payroll_actions ppa2,
1264: pay_action_interlocks pai,
1265: pay_assignment_actions paa,
1266: pay_payroll_actions ppa
1267: where pai.locked_Action_id = param_aaid
1268: and pai.locking_action_id = pai.locking_action_id
1269: and pai.locking_action_id = paa.assignment_action_id
1270: and paa.payroll_Action_id = ppa.payroll_action_id

Line 1279: pay_payroll_Actions ppae

1275: /*
1276: and exists ( select locked_action_id,locking_action_id
1277: from pay_action_interlocks paie,
1278: pay_assignment_Actions paae,
1279: pay_payroll_Actions ppae
1280: where paie.locked_action_id = pai2.locked_action_id
1281: and paie.locking_action_id = paae.assignment_action_id
1282: and paae.payroll_Action_id = ppae.payroll_Action_id
1283: and ppae.action_type = 'V' )

Line 1325: from pay_payroll_actions ppa,

1321: cursor c_run_actions (cp_pre_pay_action_id in number,
1322: cp_sep_check_run_type_id in number,
1323: cp_run_assignment_id in number) is
1324: select pai.locked_action_id
1325: from pay_payroll_actions ppa,
1326: pay_assignment_actions paa,
1327: pay_action_interlocks pai
1328: where pai.locking_action_id = cp_pre_pay_action_id
1329: and pai.locked_action_id = paa.assignment_action_id

Line 1432: from pay_payroll_actions ppa,

1428: cursor c_run_actions (cp_pre_pay_action_id in number,
1429: cp_sep_check_run_type_id in number,
1430: cp_run_assignment_id in number) is
1431: select pai.locked_action_id
1432: from pay_payroll_actions ppa,
1433: pay_assignment_actions paa,
1434: pay_action_interlocks pai
1435: where pai.locking_action_id = cp_pre_pay_action_id
1436: and pai.locked_action_id = paa.assignment_action_id

Line 1647: pay_payroll_actions ppa

1643: select paa.assignment_action_id
1644: into l_pre_pay_aaid
1645: from pay_action_interlocks pai,
1646: pay_assignment_actions paa,
1647: pay_payroll_actions ppa
1648: where pai.locked_action_id = l_assignment_action_id
1649: and paa.assignment_action_id = pai.locking_action_id
1650: and paa.source_action_id is NULL -- master pre-payment action.
1651: and ppa.payroll_action_id = paa.payroll_action_id

Line 1904: pay_payroll_actions ppa

1900: select paa.assignment_action_id
1901: into l_pre_pay_aaid
1902: from pay_action_interlocks pai,
1903: pay_assignment_actions paa,
1904: pay_payroll_actions ppa
1905: where pai.locked_action_id = l_assignment_action_id
1906: and paa.assignment_action_id = pai.locking_action_id
1907: and paa.source_action_id is NULL -- master pre-payment action.
1908: and ppa.payroll_action_id = paa.payroll_action_id

Line 2020: FROM pay_assignment_actions paa,pay_payroll_actions ppa

2016: where payroll_action_id = p_payroll_action_id;
2017:
2018: CURSOR get_year (p_assign_action_id NUMBER) IS
2019: SELECT TO_CHAR(effective_date,'YYYY')
2020: FROM pay_assignment_actions paa,pay_payroll_actions ppa
2021: WHERE ppa.payroll_action_id = paa.payroll_action_id
2022: AND paa.assignment_action_id = p_assign_action_id;
2023:
2024: --

Line 2458: pay_payroll_actions pact,

2454:
2455: select min(paa.assignment_id)
2456: into l_assignment_id
2457: from pay_assignment_actions paa,
2458: pay_payroll_actions pact,
2459: pay_payrolls_f ppf
2460: where pact.effective_date <= p_virtual_date
2461: and pact.payroll_action_id=paa.payroll_action_id
2462: and pact.action_type in ('R', 'Q', 'I', 'V', 'B')

Line 3336: , pay_payroll_actions PACT

3332: FROM pay_balance_feeds_f FEED
3333: , pay_run_result_values TARGET
3334: , pay_run_results RR
3335: , pay_assignment_actions ASSACT
3336: , pay_payroll_actions PACT
3337: where PACT.effective_date between trunc(p_effective_date,'Y')
3338: and p_effective_date
3339: and PACT.action_type in ('R','Q','I','B','V')
3340: /*

Line 3545: , pay_payroll_actions PACT

3541: FROM pay_balance_feeds_f FEED
3542: , pay_run_result_values TARGET
3543: , pay_run_results RR
3544: , pay_assignment_actions ASSACT
3545: , pay_payroll_actions PACT
3546: where PACT.effective_date between trunc(p_effective_date,'Q')
3547: and p_effective_date
3548: and PACT.action_type in ('R','Q','I','B','V')
3549: /*

Line 3638: , pay_payroll_actions PACT

3634: FROM pay_balance_feeds_f FEED
3635: , pay_run_result_values TARGET
3636: , pay_run_results RR
3637: , pay_assignment_actions ASSACT
3638: , pay_payroll_actions PACT
3639: where PACT.effective_date between trunc(p_effective_date,'Q')
3640: and p_effective_date
3641: and PACT.action_type in ('R','Q','I','B','V')
3642: /*

Line 3727: , pay_payroll_actions PACT

3723: pay_balance_feeds_f FEED
3724: , pay_run_result_values TARGET
3725: , pay_run_results RR
3726: , pay_assignment_actions ASSACT
3727: , pay_payroll_actions PACT
3728: where PACT.effective_date between trunc(c_effective_date,'Y')
3729: and c_effective_date
3730: and PACT.action_type in ('R','Q','I','B','V')
3731: /*

Line 3834: , pay_payroll_actions PACT

3830: pay_balance_feeds_f FEED
3831: , pay_run_result_values TARGET
3832: , pay_run_results RR
3833: , pay_assignment_actions ASSACT
3834: , pay_payroll_actions PACT
3835: where PACT.effective_date between trunc(c_effective_date,'Q')
3836: and c_effective_date
3837: and PACT.action_type in ('R','Q','I','B','V')
3838: /*

Line 3950: , pay_payroll_actions PACT

3946: pay_balance_feeds_f FEED
3947: , pay_run_result_values TARGET
3948: , pay_run_results RR
3949: , pay_assignment_actions ASSACT
3950: , pay_payroll_actions PACT
3951: , (select distinct puar.assignment_id assignment_id
3952: from pay_us_asg_reporting puar
3953: where puar.tax_unit_id = c_tax_unit_id
3954: and puar.jurisdiction_code like substr(c_state_code,1,2)||'%') ASGRPT

Line 4064: , pay_payroll_actions PACT

4060: pay_balance_feeds_f FEED
4061: , pay_run_result_values TARGET
4062: , pay_run_results RR
4063: , pay_assignment_actions ASSACT
4064: , pay_payroll_actions PACT
4065: , (select distinct puar.assignment_id assignment_id
4066: from pay_us_asg_reporting puar
4067: where puar.tax_unit_id = c_tax_unit_id
4068: and puar.jurisdiction_code like substr(c_state_code,1,2)||'%') ASGRPT

Line 4196: , pay_payroll_actions PACT

4192: FROM pay_balance_feeds_f FEED
4193: , pay_run_result_values TARGET
4194: , pay_run_results RR
4195: , pay_assignment_actions ASSACT
4196: , pay_payroll_actions PACT
4197: where PACT.effective_date between trunc(p_effective_date,'MON')
4198: and p_effective_date
4199: and PACT.action_type in ('R','Q','I','B','V')
4200: /*

Line 4342: , pay_payroll_actions PACT

4338: FROM pay_balance_feeds_f FEED
4339: , pay_run_result_values TARGET
4340: , pay_run_results RR
4341: , pay_assignment_actions ASSACT
4342: , pay_payroll_actions PACT
4343: where PACT.effective_date between p_start_date
4344: and p_effective_date
4345: and PACT.action_type in ('R','Q','I','B','V')
4346: /*

Line 4459: , pay_payroll_actions PACT

4455: pay_balance_feeds_f FEED
4456: , pay_run_result_values TARGET
4457: , pay_run_results RR
4458: , pay_assignment_actions ASSACT
4459: , pay_payroll_actions PACT
4460: where PACT.effective_date between trunc(c_effective_date,'MON')
4461: and c_effective_date
4462: and PACT.action_type in ('R','Q','I','B','V')
4463: /*

Line 4567: , pay_payroll_actions PACT

4563: pay_balance_feeds_f FEED
4564: , pay_run_result_values TARGET
4565: , pay_run_results RR
4566: , pay_assignment_actions ASSACT
4567: , pay_payroll_actions PACT
4568: where PACT.effective_date between c_start_date
4569: and c_effective_date
4570: and PACT.action_type in ('R','Q','I','B','V')
4571: /*

Line 4684: , pay_payroll_actions PACT

4680: pay_balance_feeds_f FEED
4681: , pay_run_result_values TARGET
4682: , pay_run_results RR
4683: , pay_assignment_actions ASSACT
4684: , pay_payroll_actions PACT
4685: , (select distinct puar.assignment_id assignment_id
4686: from pay_us_asg_reporting puar
4687: where puar.tax_unit_id = c_tax_unit_id
4688: and puar.jurisdiction_code like substr(c_state_code,1,2)||'%') ASGRPT

Line 4801: , pay_payroll_actions PACT

4797: pay_balance_feeds_f FEED
4798: , pay_run_result_values TARGET
4799: , pay_run_results RR
4800: , pay_assignment_actions ASSACT
4801: , pay_payroll_actions PACT
4802: , (select distinct puar.assignment_id assignment_id
4803: from pay_us_asg_reporting puar
4804: where puar.tax_unit_id = c_tax_unit_id
4805: and puar.jurisdiction_code like substr(c_state_code,1,2)||'%') ASGRPT