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 298: pay_payroll_actions ppa

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
302: and ppa.action_type in ('P', 'U');

Line 624: pay_payroll_actions PPA

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')
628: and PPA.effective_date <= c_date2_earned

Line 637: pay_payroll_actions PPA

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')
641: and PPA.effective_date <= c_date2_earned

Line 660: from pay_payroll_actions PPA,

656: and substr(PAR.jurisdiction_code, 1, PBT.jurisdiction_level) =
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

Line 742: from pay_payroll_actions ppa,

738: into l_dummy
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

Line 1167: pay_payroll_actions ppa2,

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
1171: where pai.locked_Action_id = param_aaid

Line 1170: pay_payroll_actions ppa

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
1174: and paa.payroll_Action_id = ppa.payroll_action_id

Line 1183: pay_payroll_Actions ppae

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
1187: and ppae.action_type = 'V' )

Line 1229: from pay_payroll_actions ppa,

1225: cursor c_run_actions (cp_pre_pay_action_id in number,
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

Line 1336: from pay_payroll_actions ppa,

1332: cursor c_run_actions (cp_pre_pay_action_id in number,
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

Line 1536: pay_payroll_actions ppa

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.
1540: and ppa.payroll_action_id = paa.payroll_action_id

Line 1723: pay_payroll_actions ppa

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.
1727: and ppa.payroll_action_id = paa.payroll_action_id

Line 2197: pay_payroll_actions pact,

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
2201: and pact.action_type in ('R', 'Q', 'I', 'V', 'B')

Line 2925: , pay_payroll_actions PACT

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')
2929: /*

Line 3134: , pay_payroll_actions PACT

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')
3138: /*

Line 3257: , pay_payroll_actions PACT

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')
3261: /*

Line 3364: , pay_payroll_actions PACT

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')
3368: /*

Line 3480: , pay_payroll_actions PACT

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
3484: and puar.jurisdiction_code like substr(c_state_code,1,2)||'%') ASGRPT

Line 3594: , pay_payroll_actions PACT

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
3598: and puar.jurisdiction_code like substr(c_state_code,1,2)||'%') ASGRPT

Line 3726: , pay_payroll_actions PACT

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')
3730: /*

Line 3872: , pay_payroll_actions PACT

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')
3876: /*

Line 3989: , pay_payroll_actions PACT

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')
3993: /*

Line 4097: , pay_payroll_actions PACT

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')
4101: /*

Line 4214: , pay_payroll_actions PACT

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
4218: and puar.jurisdiction_code like substr(c_state_code,1,2)||'%') ASGRPT

Line 4331: , pay_payroll_actions PACT

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
4335: and puar.jurisdiction_code like substr(c_state_code,1,2)||'%') ASGRPT