APPS.AP_WITHHOLDING_PKG dependencies on GL_PERIOD_STATUSES

Line 233: l_period_name gl_period_statuses.period_name%TYPE; --added for bug 8266021

229: l_income_tax_region_pvs ap_system_parameters.income_tax_region%TYPE;
230: l_income_tax_region_flag ap_system_parameters.income_tax_region_flag%TYPE;
231: l_income_tax_region ap_system_parameters.income_tax_region%TYPE;
232:
233: l_period_name gl_period_statuses.period_name%TYPE; --added for bug 8266021
234:
235: l_exchange_rate ap_checks_all.exchange_rate%type; -- added for bug 8590059
236:
237: l_withhold_amount NUMBER; --8726501

Line 508: FROM gl_Period_Statuses gps,

504: curr_inv_line_number := curr_inv_line_number + 1;
505:
506: SELECT DISTINCT gps.Period_Name
507: INTO l_period_name
508: FROM gl_Period_Statuses gps,
509: ap_System_Parameters_All Asp
510: WHERE gps.Application_Id = 200
511: AND gps.Set_Of_Books_Id = Asp.Set_Of_Books_Id
512: AND Nvl(gps.Adjustment_Period_Flag,'N') = 'N'

Line 1318: l_period_name gl_period_statuses.period_name%type;

1314:
1315: l_set_of_books_id ap_invoices_all.set_of_books_id%type;
1316: l_batch_id ap_invoices_all.batch_id%type;
1317: l_org_id ap_invoices_all.org_id%type;
1318: l_period_name gl_period_statuses.period_name%type;
1319:
1320: l_line_number ap_invoice_lines_all.line_number%type;
1321: l_dist_number ap_invoice_distributions_all.distribution_line_number%type;
1322:

Line 1831: FROM gl_Period_Statuses gps,

1827: SELECT DISTINCT gps.Period_Name,
1828: automatic_offsets_flag
1829: INTO l_period_name,
1830: l_automatic_offsets
1831: FROM gl_Period_Statuses gps,
1832: ap_System_Parameters_All Asp
1833: WHERE gps.Application_Id = 200
1834: AND gps.Set_Of_Books_Id = Asp.Set_Of_Books_Id
1835: AND Nvl(gps.Adjustment_Period_Flag,'N') = 'N'

Line 4664: FROM gl_period_statuses GPS,

4660: SELECT GPS.period_name,
4661: P_Awt_Date
4662: INTO gl_period_name,
4663: gl_awt_date
4664: FROM gl_period_statuses GPS,
4665: ap_system_parameters_all ASP
4666: WHERE GPS.application_id = 200
4667: AND GPS.set_of_books_id = ASP.set_of_books_id
4668: AND P_Awt_Date BETWEEN GPS.start_date AND GPS.END_date