APPS.AP_CALC_WITHHOLDING_PKG dependencies on AP_AWT_BUCKETS

Line 57: l_withheld_amount_to_date ap_awt_buckets.withheld_amount_to_date%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:
60: CURSOR c_get_bucket (PerName IN VARCHAR2)
61: IS

Line 63: FROM ap_awt_buckets bk

59:
60: CURSOR c_get_bucket (PerName IN VARCHAR2)
61: IS
62: SELECT bk.withheld_amount_to_date
63: FROM ap_awt_buckets bk
64: WHERE bk.period_name = PerName
65: AND bk.tax_name = P_Tax_Name
66: AND bk.vendor_id = P_Vendor_Id
67: AND bk.org_id = g_org_id; -- bug 7301484

Line 177: FROM ap_awt_buckets bk

173: debug_info VARCHAR2(100);
174:
175: CURSOR c_get_bucket IS
176: SELECT 'Y'
177: FROM ap_awt_buckets bk
178: WHERE bk.period_name = P_Awt_Period_Name
179: AND bk.tax_name = P_Tax_Name
180: AND bk.vendor_id = P_Vendor_Id
181: AND bk.org_id = g_org_id -- bug 7301484

Line 210: UPDATE ap_awt_buckets

206:
207: -- Update existing bucket
208: debug_info := 'Update existing bucket';
209:
210: UPDATE ap_awt_buckets
211: SET gross_amount_to_date = gross_amount_to_date +
212: NVL(P_Amount_Subject, 0),
213: withheld_amount_to_date = withheld_amount_to_date +
214: NVL(P_Amount_Withheld, 0),

Line 227: INSERT INTO ap_awt_buckets

223: ELSE
224: -- Create new bucket
225: debug_info := 'Create new bucket';
226:
227: INSERT INTO ap_awt_buckets
228: (period_name
229: ,tax_name
230: ,vendor_id
231: ,withheld_amount_to_date

Line 1794: FROM ap_awt_buckets

1790: <> --bug14530757, changed the block name to Gross_Amount_To_Date
1791: DECLARE
1792: CURSOR c_gross_amount_to_date_period IS --bug14530757, changed the cursor name to c_gross_amount_to_date_period
1793: SELECT gross_amount_to_date
1794: FROM ap_awt_buckets
1795: WHERE (period_name = AwtPeriodName)
1796: AND (tax_name = TaxName)
1797: AND (vendor_id = SuppId);
1798:

Line 1825: gross_amount_to_date ap_awt_buckets.gross_amount_to_date%TYPE;

1821: and aid.invoice_id = p_invoice_id
1822: and aid.awt_origin_group_id = p_group_id;
1823:
1824:
1825: gross_amount_to_date ap_awt_buckets.gross_amount_to_date%TYPE;
1826: new_number_of_ranges NUMBER := 0;
1827: i binary_integer := 1;
1828: DBG_Loc VARCHAR2(30) := 'Period_Basis_Is_Period';
1829: BEGIN