APPS.IGC_CC_OPEN_INTERFACE_PKG dependencies on GL_PERIODS

Line 1180: FROM gl_periods gp,

1176: IS
1177: SELECT gp.period_name,
1178: gp.period_num,
1179: gp.period_year
1180: FROM gl_periods gp,
1181: gl_sets_of_books sob
1182: WHERE gp.period_set_name = sob.period_set_name
1183: AND gp.period_type = sob.accounted_period_type
1184: AND sob.set_of_books_id = p_sob_id

Line 1381: l_start_date gl_periods.start_date%TYPE;

1377: l_error_text VARCHAR2(12000);
1378: l_msg_buf VARCHAR2(2000);
1379: l_request_id NUMBER;
1380: l_interface_header_record igc_cc_headers_interface%ROWTYPE;
1381: l_start_date gl_periods.start_date%TYPE;
1382: l_end_date gl_periods.end_date%TYPE;
1383: l_curr_year_pf_lines NUMBER;
1384: l_error_message igc_cc_interface_errors.error_message%TYPE;
1385: l_history_message VARCHAR2(240);

Line 1382: l_end_date gl_periods.end_date%TYPE;

1378: l_msg_buf VARCHAR2(2000);
1379: l_request_id NUMBER;
1380: l_interface_header_record igc_cc_headers_interface%ROWTYPE;
1381: l_start_date gl_periods.start_date%TYPE;
1382: l_end_date gl_periods.end_date%TYPE;
1383: l_curr_year_pf_lines NUMBER;
1384: l_error_message igc_cc_interface_errors.error_message%TYPE;
1385: l_history_message VARCHAR2(240);
1386: l_wait_for_request BOOLEAN;

Line 1419: FROM GL_PERIODS GP,

1415:
1416: CURSOR c_fiscal_year_dates(P_Sob_Id NUMBER)
1417: IS
1418: SELECT MIN(start_date) start_date, MAX(end_date) end_date
1419: FROM GL_PERIODS GP,
1420: GL_SETS_OF_BOOKS GB
1421: WHERE
1422: GP.period_set_name = GB.period_set_name AND
1423: GP.period_type = GB.accounted_period_type AND

Line 3105: FROM igc_cc_periods ccp, gl_sets_of_books sob, gl_periods glp

3101: P_X_Error_Status);
3102: ELSE
3103: BEGIN
3104: SELECT 1 INTO l_count
3105: FROM igc_cc_periods ccp, gl_sets_of_books sob, gl_periods glp
3106: WHERE sob.set_of_books_id = P_Set_of_Books_Id
3107: AND sob.period_set_name = glp.period_set_name
3108: AND sob.accounted_period_type = glp.period_type
3109: AND glp.adjustment_period_flag = 'N'