APPS.AP_WITHHOLDING_PKG dependencies on AP_OTHER_PERIODS

Line 3883: FROM ap_other_periods P,

3879: ,current_calling_sequence)) THEN
3880: DECLARE
3881: CURSOR c_get_awt_period IS
3882: SELECT p.period_name
3883: FROM ap_other_periods P,
3884: ap_tax_codes_all C
3885: WHERE (rec_temp_gross.accounting_date BETWEEN
3886: p.start_date AND p.end_date)
3887: AND p.period_type = c.awt_period_type

Line 3891: awt_period ap_other_periods.period_name%TYPE;

3887: AND p.period_type = c.awt_period_type
3888: AND c.name = rec_temp_gross.tax_name
3889: AND p.module = 'AWT';
3890:
3891: awt_period ap_other_periods.period_name%TYPE;
3892: BEGIN
3893: debug_info := 'OPEN CURSOR c_get_awt_period';
3894: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3895: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);

Line 3965: FROM ap_other_periods P,

3961: ,current_calling_sequence)) THEN
3962: DECLARE
3963: CURSOR c_get_awt_period IS
3964: SELECT p.period_name
3965: FROM ap_other_periods P,
3966: ap_tax_codes_all C
3967: WHERE (rec_temp.accounting_date BETWEEN
3968: p.start_date AND p.end_date)
3969: AND p.period_type = c.awt_period_type

Line 3973: awt_period ap_other_periods.period_name%TYPE;

3969: AND p.period_type = c.awt_period_type
3970: AND c.name = rec_temp.tax_name
3971: AND p.module = 'AWT';
3972:
3973: awt_period ap_other_periods.period_name%TYPE;
3974: BEGIN
3975: debug_info := 'OPEN CURSOR c_get_awt_period';
3976: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3977: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);

Line 4246: awt_period ap_other_periods.period_name%TYPE;

4242: */
4243:
4244: -- PL/SQL Main Block Constants AND Variables:
4245:
4246: awt_period ap_other_periods.period_name%TYPE;
4247: gl_period_name ap_invoice_distributions.period_name%TYPE;
4248: gl_awt_date DATE;
4249: DBG_Loc VARCHAR2(30) := 'Ap_Undo_Withholding';
4250: current_calling_sequence VARCHAR2(2000);

Line 4721: FROM ap_other_periods P,

4717: DBG_Loc VARCHAR2(30) := 'Get_Withholding_Period';
4718: msg VARCHAR2(240);
4719: CURSOR c_get_period (distDate IN DATE, TaxId IN NUMBER) IS
4720: SELECT period_name
4721: FROM ap_other_periods P,
4722: ap_tax_codes T
4723: WHERE t.tax_id = TaxId
4724: AND p.period_type = t.awt_period_type
4725: AND p.application_id = 200

Line 4931: FROM ap_other_periods P,

4927: DBG_Loc VARCHAR2(30) := 'Get_Withholding_Period';
4928: msg VARCHAR2(240);
4929: CURSOR c_get_period (distDate IN DATE, TaxId IN NUMBER) IS
4930: SELECT period_name
4931: FROM ap_other_periods P,
4932: ap_tax_codes T
4933: WHERE t.tax_id = TaxId
4934: AND p.period_type = t.awt_period_type
4935: AND p.application_id = 200

Line 5762: awt_period ap_other_periods.period_name%TYPE;

5758: and AATD.invoice_payment_id is null;
5759:
5760: rec_orphan_awt_buckets_w c_orphan_awt_buckets_w%ROWTYPE;
5761: rec_orphan_awt_buckets_g c_orphan_awt_buckets_g%ROWTYPE;
5762: awt_period ap_other_periods.period_name%TYPE;
5763:
5764: BEGIN
5765: current_calling_sequence := 'AP_WITHHOLDING_PKG.Ap_Undo_Orphan_Distributions';
5766:

Line 5791: FROM ap_other_periods P,

5787:
5788: DECLARE
5789: CURSOR c_get_awt_period IS
5790: SELECT p.period_name
5791: FROM ap_other_periods P,
5792: ap_tax_codes_all C
5793: WHERE (rec_orphan_awt_buckets_w.accounting_date BETWEEN
5794: p.start_date AND p.end_date)
5795: AND p.period_type = c.awt_period_type

Line 5858: FROM ap_other_periods P,

5854:
5855: DECLARE
5856: CURSOR c_get_awt_period IS
5857: SELECT p.period_name
5858: FROM ap_other_periods P,
5859: ap_tax_codes_all C
5860: WHERE (rec_orphan_awt_buckets_g.accounting_date BETWEEN
5861: p.start_date AND p.end_date)
5862: AND p.period_type = c.awt_period_type