DBA Data[Home] [Help]

APPS.PAY_US_TAXBAL_VIEW_PKG dependencies on PAY_BALANCE_FEEDS_F

Line 3332: FROM pay_balance_feeds_f FEED

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

Line 3541: FROM pay_balance_feeds_f FEED

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

Line 3634: FROM pay_balance_feeds_f FEED

3630:
3631: cursor get_ss_values (c_balance_type_id1 in number) is
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

Line 3723: pay_balance_feeds_f FEED

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

Line 3830: pay_balance_feeds_f FEED

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

Line 3946: pay_balance_feeds_f FEED

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

Line 4060: pay_balance_feeds_f FEED

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

Line 4192: FROM pay_balance_feeds_f FEED

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

Line 4338: FROM pay_balance_feeds_f FEED

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

Line 4455: pay_balance_feeds_f FEED

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

Line 4563: pay_balance_feeds_f FEED

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

Line 4680: pay_balance_feeds_f FEED

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

Line 4797: pay_balance_feeds_f FEED

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