APPS.AP_CALC_WITHHOLDING_PKG dependencies on AP_TAX_CODES

Line 44: l_awt_period_type ap_tax_codes.awt_period_type%TYPE;

40: the appropriate bucket records. The NUMBER passed out IS the amount
41: to be withheld. If no cut off has been applied this will be the
42: same as the amount withheld passed in. */
43:
44: l_awt_period_type ap_tax_codes.awt_period_type%TYPE;
45: l_awt_period_name ap_other_periods.period_name%TYPE
46: := P_Awt_Period_Name;
47: l_awt_period_limit ap_tax_codes.awt_period_limit%TYPE
48: := P_Period_Limit;

Line 47: l_awt_period_limit ap_tax_codes.awt_period_limit%TYPE

43:
44: l_awt_period_type ap_tax_codes.awt_period_type%TYPE;
45: l_awt_period_name ap_other_periods.period_name%TYPE
46: := P_Awt_Period_Name;
47: l_awt_period_limit ap_tax_codes.awt_period_limit%TYPE
48: := P_Period_Limit;
49: l_withheld_amount_to_date ap_awt_buckets.withheld_amount_to_date%TYPE;
50: l_amount_withheld NUMBER;
51:

Line 918: invalid_tax ap_tax_codes.name%TYPE;

914: gl_awt_date DATE;
915:
916: -- Invalid Situations Variables
917: invalid_group ap_awt_groups.group_id%TYPE;
918: invalid_tax ap_tax_codes.name%TYPE;
919:
920: -- PL/SQL debugging/logging Objects:
921:
922: DBG_Loc VARCHAR2(30) := 'AP_Calculate_AWT_Amounts';

Line 2183: , ap_tax_codes ATC

2179: , ATC.awt_period_limit
2180: , ATC.inactive_date
2181: , ATC.tax_code_combination_id
2182: FROM ap_awt_group_taxes AAGT
2183: , ap_tax_codes ATC
2184: , ap_other_periods AOP
2185: WHERE (AAGT.group_id = GrpId)
2186: AND (AAGT.tax_name = ATC.name)
2187: AND (ATC.tax_type = 'AWT') -- BUG 3665866