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_RUN_RESULT_VALUES

Line 2922: , pay_run_result_values TARGET

2918: nvl(sum(decode(FEED.balance_type_id,c_balance_type_id8,TARGET.result_value * FEED.scale,0)),0),
2919: nvl(sum(decode(FEED.balance_type_id,c_balance_type_id9,TARGET.result_value * FEED.scale,0)),0),
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')

Line 3131: , pay_run_result_values TARGET

3127: nvl(sum(decode(FEED.balance_type_id,c_balance_type_id10,TARGET.result_value * FEED.scale,0)),0),
3128: nvl(sum(decode(FEED.balance_type_id,c_balance_type_id11,TARGET.result_value * FEED.scale,0)),0),
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')

Line 3254: , pay_run_result_values TARGET

3250: nvl(sum(decode(feed.balance_type_id,c_balance_type_id4,TARGET.result_value * FEED.scale,0)),0),
3251: nvl(sum(decode(feed.balance_type_id,c_balance_type_id5,TARGET.result_value * FEED.scale,0)),0)
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')

Line 3361: , pay_run_result_values TARGET

3357: nvl(sum(decode(feed.balance_type_id,c_balance_type_id4,TARGET.result_value * FEED.scale,0)),0),
3358: nvl(sum(decode(feed.balance_type_id,c_balance_type_id5,TARGET.result_value * FEED.scale,0)),0)
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')

Line 3477: , pay_run_result_values TARGET

3473: nvl(sum(decode(FEED.balance_type_id,c_balance_type_id6,TARGET.result_value * FEED.scale,0)),0) ,
3474: nvl(sum(decode(FEED.balance_type_id,c_balance_type_id7,TARGET.result_value * FEED.scale,0)),0)
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

Line 3591: , pay_run_result_values TARGET

3587: nvl(sum(decode(FEED.balance_type_id,c_balance_type_id6,TARGET.result_value * FEED.scale,0)),0) ,
3588: nvl(sum(decode(FEED.balance_type_id,c_balance_type_id7,TARGET.result_value * FEED.scale,0)),0)
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

Line 3723: , pay_run_result_values TARGET

3719: nvl(sum(decode(FEED.balance_type_id,c_balance_type_id8,TARGET.result_value * FEED.scale,0)),0),
3720: nvl(sum(decode(FEED.balance_type_id,c_balance_type_id9,TARGET.result_value * FEED.scale,0)),0),
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')

Line 3869: , pay_run_result_values TARGET

3865: nvl(sum(decode(FEED.balance_type_id,c_balance_type_id8,TARGET.result_value * FEED.scale,0)),0),
3866: nvl(sum(decode(FEED.balance_type_id,c_balance_type_id9,TARGET.result_value * FEED.scale,0)),0),
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

Line 3986: , pay_run_result_values TARGET

3982: nvl(sum(decode(feed.balance_type_id,c_balance_type_id4,TARGET.result_value * FEED.scale,0)),0),
3983: nvl(sum(decode(feed.balance_type_id,c_balance_type_id5,TARGET.result_value * FEED.scale,0)),0)
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')

Line 4094: , pay_run_result_values TARGET

4090: nvl(sum(decode(feed.balance_type_id,c_balance_type_id4,TARGET.result_value * FEED.scale,0)),0),
4091: nvl(sum(decode(feed.balance_type_id,c_balance_type_id5,TARGET.result_value * FEED.scale,0)),0)
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

Line 4211: , pay_run_result_values TARGET

4207: nvl(sum(decode(FEED.balance_type_id,c_balance_type_id6,TARGET.result_value * FEED.scale,0)),0) ,
4208: nvl(sum(decode(FEED.balance_type_id,c_balance_type_id7,TARGET.result_value * FEED.scale,0)),0)
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

Line 4328: , pay_run_result_values TARGET

4324: nvl(sum(decode(FEED.balance_type_id,c_balance_type_id6,TARGET.result_value * FEED.scale,0)),0) ,
4325: nvl(sum(decode(FEED.balance_type_id,c_balance_type_id7,TARGET.result_value * FEED.scale,0)),0)
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