DBA Data[Home] [Help]

APPS.AP_CALC_WITHHOLDING_PKG dependencies on AP_OTHER_PERIODS

Line 53: l_awt_period_name ap_other_periods.period_name%TYPE

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;
57: l_withheld_amount_to_date ap_awt_buckets.withheld_amount_to_date%TYPE;

Line 2551: , ap_other_periods AOP

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
2555: AND (AOP.application_id (+) = 200)