DBA Data[Home] [Help]

APPS.PAY_US_TAXBAL_VIEW_PKG dependencies on PAY_RUN_RESULTS

Line 2923: , pay_run_results RR

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')
2927: and p_effective_date

Line 3132: , pay_run_results RR

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')
3136: and p_effective_date

Line 3255: , pay_run_results RR

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')
3259: and c_effective_date

Line 3362: , pay_run_results RR

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')
3366: and c_effective_date

Line 3478: , pay_run_results RR

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
3482: from pay_us_asg_reporting puar

Line 3592: , pay_run_results RR

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
3596: from pay_us_asg_reporting puar

Line 3724: , pay_run_results RR

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')
3728: and p_effective_date

Line 3870: , pay_run_results RR

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
3874: and p_effective_date

Line 3987: , pay_run_results RR

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')
3991: and c_effective_date

Line 4095: , pay_run_results RR

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
4099: and c_effective_date

Line 4212: , pay_run_results RR

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
4216: from pay_us_asg_reporting puar

Line 4329: , pay_run_results RR

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
4333: from pay_us_asg_reporting puar