APPS.AP_CALC_WITHHOLDING_PKG dependencies on GL_PERIOD_STATUSES

Line 1109: max_gl_date_period gl_period_statuses.period_name%TYPE; /* Added for bug#6605368 */

1105: gl_period_name ap_invoice_distributions.period_name%TYPE;
1106: gl_awt_date DATE;
1107:
1108: max_gl_dist_date DATE; /* Added for bug#6605368 */
1109: max_gl_date_period gl_period_statuses.period_name%TYPE; /* Added for bug#6605368 */
1110:
1111: -- Invalid Situations Variables
1112: invalid_group ap_awt_groups.group_id%TYPE;
1113: invalid_tax ap_tax_codes.name%TYPE;

Line 1166: TABLE OF gl_period_statuses.period_name%TYPE INDEX BY binary_integer;

1162: tab_max_gl_date Max_gl_date_TabTyp;
1163:
1164: /*type for the max gl date period*/
1165: TYPE Max_gl_period_TabTyp IS
1166: TABLE OF gl_period_statuses.period_name%TYPE INDEX BY binary_integer;
1167:
1168: tab_max_gl_period Max_gl_period_TabTyp;
1169:
1170: /* Added for bug6605368 End */

Line 2096: FROM gl_period_statuses GPS,

2092: SELECT GPS.period_name,
2093: P_Awt_Date
2094: INTO gl_period_name,
2095: gl_awt_date
2096: FROM gl_period_statuses GPS,
2097: ap_system_parameters ASP
2098: WHERE GPS.application_id = 200
2099: AND GPS.set_of_books_id = ASP.set_of_books_id
2100: AND P_Awt_Date BETWEEN GPS.start_date

Line 2236: FROM gl_period_statuses glps,

2232:
2233: BEGIN
2234: SELECT glps.period_name
2235: INTO tab_max_gl_period(i)
2236: FROM gl_period_statuses glps,
2237: ap_invoices_all ai
2238: WHERE glps.application_id = 200
2239: AND nvl(glps.adjustment_period_flag, 'N') <>'Y'
2240: AND (