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_RESULTS

Line 1545: from pay_run_results prr

1541:
1542: CURSOR c_get_source_id(cp_asg_act_id number
1543: ,cp_ele_typ_id number) is
1544: select distinct prr.source_id
1545: from pay_run_results prr
1546: where prr.assignment_action_id = cp_asg_act_id
1547: and prr.element_type_id = cp_ele_typ_id;
1548:
1549: l_asg_type VARCHAR(32);

Line 3334: , pay_run_results RR

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

Line 3543: , pay_run_results RR

3539: nvl(sum(decode(FEED.balance_type_id,c_balance_type_id11,TARGET.result_value * FEED.scale,0)),0),
3540: nvl(sum(decode(FEED.balance_type_id,c_balance_type_id12,TARGET.result_value * FEED.scale,0)),0)
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

Line 3636: , pay_run_results RR

3632: SELECT /* Removed RULE hint. Bug 3331031 */
3633: nvl(sum(decode(FEED.balance_type_id,c_balance_type_id1,TARGET.result_value * FEED.scale,0)),0)
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

Line 3725: , pay_run_results RR

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

Line 3832: , pay_run_results RR

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

Line 3948: , pay_run_results RR

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

Line 4062: , pay_run_results RR

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

Line 4194: , pay_run_results RR

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

Line 4340: , pay_run_results RR

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

Line 4457: , pay_run_results RR

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

Line 4565: , pay_run_results RR

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

Line 4682: , pay_run_results RR

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

Line 4799: , pay_run_results RR

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