APPS.AP_CALC_WITHHOLDING_PKG dependencies on AP_TAX_CODES

Line 52: l_awt_period_type ap_tax_codes.awt_period_type%TYPE;

48: the appropriate bucket records. The NUMBER passed out IS the amount
49: to be withheld. If no cut off has been applied this will be the
50: same as the amount withheld passed in. */
51:
52: l_awt_period_type ap_tax_codes.awt_period_type%TYPE;
53: l_awt_period_name ap_other_periods.period_name%TYPE
54: := P_Awt_Period_Name;
55: l_awt_period_limit ap_tax_codes.awt_period_limit%TYPE
56: := P_Period_Limit;

Line 55: l_awt_period_limit ap_tax_codes.awt_period_limit%TYPE

51:
52: l_awt_period_type ap_tax_codes.awt_period_type%TYPE;
53: l_awt_period_name ap_other_periods.period_name%TYPE
54: := P_Awt_Period_Name;
55: l_awt_period_limit ap_tax_codes.awt_period_limit%TYPE
56: := P_Period_Limit;
57: l_withheld_amount_to_date ap_awt_buckets.withheld_amount_to_date%TYPE;
58: l_amount_withheld NUMBER;
59:

Line 1113: invalid_tax ap_tax_codes.name%TYPE;

1109: max_gl_date_period gl_period_statuses.period_name%TYPE; /* Added for bug#6605368 */
1110:
1111: -- Invalid Situations Variables
1112: invalid_group ap_awt_groups.group_id%TYPE;
1113: invalid_tax ap_tax_codes.name%TYPE;
1114:
1115: -- PL/SQL debugging/logging Objects:
1116:
1117: DBG_Loc VARCHAR2(30) := 'AP_Calculate_AWT_Amounts';

Line 2550: , ap_tax_codes ATC

2546: , ATC.inactive_date
2547: , ATC.enabled_flag -- bug 6911736
2548: , ATC.tax_code_combination_id
2549: FROM ap_awt_group_taxes AAGT
2550: , ap_tax_codes ATC
2551: , ap_other_periods AOP
2552: WHERE (AAGT.group_id = GrpId)
2553: AND (AAGT.tax_name = ATC.name)
2554: AND (ATC.tax_type = 'AWT') -- BUG 3665866