APPS.AP_WITHHOLDING_PKG dependencies on AP_OTHER_PERIODS

Line 2646: FROM ap_other_periods P,

2642: ,current_calling_sequence)) THEN
2643: DECLARE
2644: CURSOR c_get_awt_period IS
2645: SELECT p.period_name
2646: FROM ap_other_periods P,
2647: ap_tax_codes_all C
2648: WHERE (rec_temp.accounting_date BETWEEN
2649: p.start_date AND p.end_date)
2650: AND p.period_type = c.awt_period_type

Line 2654: awt_period ap_other_periods.period_name%TYPE;

2650: AND p.period_type = c.awt_period_type
2651: AND c.name = rec_temp.tax_name
2652: AND p.module = 'AWT';
2653:
2654: awt_period ap_other_periods.period_name%TYPE;
2655: BEGIN
2656: debug_info := 'OPEN CURSOR c_get_awt_period';
2657: OPEN c_get_awt_period;
2658:

Line 2900: awt_period ap_other_periods.period_name%TYPE;

2896: */
2897:
2898: -- PL/SQL Main Block Constants AND Variables:
2899:
2900: awt_period ap_other_periods.period_name%TYPE;
2901: gl_period_name ap_invoice_distributions.period_name%TYPE;
2902: gl_awt_date DATE;
2903: DBG_Loc VARCHAR2(30) := 'Ap_Undo_Withholding';
2904: current_calling_sequence VARCHAR2(2000);

Line 3256: FROM ap_other_periods P,

3252: DBG_Loc VARCHAR2(30) := 'Get_Withholding_Period';
3253: msg VARCHAR2(240);
3254: CURSOR c_get_period (distDate IN DATE, TaxId IN NUMBER) IS
3255: SELECT period_name
3256: FROM ap_other_periods P,
3257: ap_tax_codes T
3258: WHERE t.tax_id = TaxId
3259: AND p.period_type = t.awt_period_type
3260: AND p.application_id = 200