APPS.PAY_GTNLOD_PKG dependencies on PAY_US_LOCAL_TAXES_V

Line 27: pay_us_local_taxes_v views, to eliminate

23: Multi threaded.
24: 31-JAN-2002 tclewis 115.6 Modified the load_ee_tax specificall the
25: query of local taxes to join to the
26: ppa_year_effective_date of the
27: pay_us_local_taxes_v views, to eliminate
28: local taxes being reporting incorrectly.
29: Bug 2060255. Modified the load_message
30: lines routine, adding a cursor look around
31: the outer cursor, to check each row in the

Line 40: the view pay_us_local_taxes_v has been changed (removed the

36: "Disbursements".
37: 16-MAY-2002 ahanda 115.10 Added session var to supress PTD balance calls.
38: 22-MAY-2002 sodhingr 115.11 For bug 2304091- Modified the cursor ee_tax
39: removed the join with column paa_year_effective_date as
40: the view pay_us_local_taxes_v has been changed (removed the
41: inline view).
42: 10-JUL-2002 tclewis 115.12 modified load_prepay, when inserting data into
43: pay_us_rpt_totals also load pay_pre_payments.pre_payment_id
44: into the pay_us_rpt_totals.location_id (an indexed column).

Line 794: from PAY_US_LOCAL_TAXES_V

790: ),
791: '3' sub_class,run_val,
792: TAX_TYPE_CODE,
793: jurisdiction_code
794: from PAY_US_LOCAL_TAXES_V
795: where assignment_action_id = l_assignment_action_id
796: and ee_or_er_code = 'EE'
797: UNION ALL
798: SELECT 'EE Non W2 FIT Withheld',

Line 1090: from PAY_US_LOCAL_TAXES_V

1086: (decode(city_name,'INVALID',null,city_name))
1087: )
1088: ),
1089: '3' sub_class,run_val
1090: from PAY_US_LOCAL_TAXES_V
1091: where assignment_action_id = l_assignment_action_id
1092: and ee_or_er_code = 'ER';
1093:
1094: /*-- Bug#4942114 ends -- */

Line 2656: l_local_view_name := 'PAY_US_LOCAL_TAXES_V';

2652: l_ded_view_name := 'PAY_US_GTN_DEDUCT_V';
2653: l_earn_view_name := 'PAY_US_GTN_EARNINGS_V';
2654: l_fed_view_name := 'PAY_US_FED_TAXES_V';
2655: l_state_view_name := 'PAY_US_STATE_TAXES_V';
2656: l_local_view_name := 'PAY_US_LOCAL_TAXES_V';
2657: l_fed_liab_view_name := 'PAY_US_FED_LIABILITIES_V';
2658: l_state_liab_view_name := 'PAY_US_STATE_LIABILITIES_V';
2659: l_futa_where := ' prr.status in ('||'''P'''||','||'''PA'''||')
2660: and pet.element_type_id = prr.element_type_id