APPS.IGC_CC_YEP_PROCESS_PKG dependencies on GL_SETS_OF_BOOKS

Line 119: gl_sets_of_books gb

115: SELECT min(gp.period_num)
116: INTO l_min_period_num
117: FROM gl_period_statuses gps,
118: gl_periods gp,
119: gl_sets_of_books gb
120: WHERE
121: gb.set_of_books_id = p_SOB_ID AND
122: gp.period_set_name = gb.period_set_name AND
123: gp.period_type = gb.accounted_period_type AND

Line 135: gl_sets_of_books gb

131: SELECT gps.start_date INTO
132: l_next_yr_start_date
133: FROM gl_period_statuses gps,
134: gl_periods gp,
135: gl_sets_of_books gb
136: WHERE gb.set_of_books_id = p_SOB_ID AND
137: gp.period_set_name = gb.period_set_name AND
138: gp.period_type = gb.accounted_period_type AND
139: gps.set_of_books_id = gb.set_of_books_id AND

Line 994: GL_SETS_OF_BOOKS C

990: CURSOR C6 IS
991: SELECT B.PERIOD_NUM, B.PERIOD_NAME , A.CC_PERIOD_STATUS
992: FROM IGC_CC_PERIODS A,
993: GL_PERIODS_V B,
994: GL_SETS_OF_BOOKS C
995: WHERE B.PERIOD_YEAR = p_YEAR
996: AND A.PERIOD_SET_NAME = B.PERIOD_SET_NAME
997: AND B.PERIOD_SET_NAME = C.PERIOD_SET_NAME
998: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id

Line 1010: GL_SETS_OF_BOOKS C

1006: CURSOR C7 IS
1007: SELECT B.PERIOD_NUM, B.PERIOD_NAME , A.CC_PERIOD_STATUS
1008: FROM IGC_CC_PERIODS A,
1009: GL_PERIODS_V B,
1010: GL_SETS_OF_BOOKS C
1011: WHERE B.PERIOD_YEAR = p_YEAR+1
1012: AND A.PERIOD_SET_NAME = B.PERIOD_SET_NAME
1013: AND B.PERIOD_SET_NAME = C.PERIOD_SET_NAME
1014: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id

Line 1117: l_currency_code gl_sets_of_books.currency_code%TYPE;

1113: l_yr_end_dr_date DATE;
1114: l_min_period_num gl_periods.period_num%TYPE;
1115: l_max_period_num gl_periods.period_num%TYPE;
1116:
1117: l_currency_code gl_sets_of_books.currency_code%TYPE;
1118: l_sbc_on BOOLEAN;
1119: l_cbc_on BOOLEAN;
1120: l_prov_enc_on BOOLEAN;
1121: l_conf_enc_on BOOLEAN;

Line 1354: gl_sets_of_books gb

1350: SELECT min(gp.period_num)
1351: INTO l_min_period_num
1352: FROM gl_period_statuses gps,
1353: gl_periods gp,
1354: gl_sets_of_books gb
1355: WHERE
1356: gb.set_of_books_id = l_sob_id AND /*p_sob_id => l_sob_id by Bug 6341012 */
1357: gp.period_set_name = gb.period_set_name AND
1358: gp.period_type = gb.accounted_period_type AND

Line 1370: gl_sets_of_books gb

1366: SELECT max(gp.period_num)
1367: INTO l_max_period_num
1368: FROM gl_period_statuses gps,
1369: gl_periods gp,
1370: gl_sets_of_books gb
1371: WHERE
1372: gb.set_of_books_id = l_sob_id AND /* p_sob_id => l_sob_id by Bug 6341012 */
1373: gp.period_set_name = gb.period_set_name AND
1374: gp.period_type = gb.accounted_period_type AND

Line 1387: gl_sets_of_books gb

1383: SELECT gps.end_date,gps.end_date INTO
1384: l_yr_end_cr_date,l_yr_end_date
1385: FROM gl_period_statuses gps,
1386: gl_periods gp,
1387: gl_sets_of_books gb
1388: WHERE
1389: gb.set_of_books_id = l_sob_id AND /* p_sob_id => l_sob_id by Bug 6341012 */
1390: gp.period_set_name = gb.period_set_name AND
1391: gp.period_type = gb.accounted_period_type AND

Line 1403: gl_sets_of_books gb

1399: SELECT gps.start_date, gps.start_date INTO
1400: l_yr_end_dr_date, l_yr_start_date_next
1401: FROM gl_period_statuses gps,
1402: gl_periods gp,
1403: gl_sets_of_books gb
1404: WHERE
1405: gb.set_of_books_id = l_sob_id AND /* p_sob_id => l_sob_id by Bug 6341012 */
1406: gp.period_set_name = gb.period_set_name AND
1407: gp.period_type = gb.accounted_period_type AND

Line 1419: gl_sets_of_books gb

1415: SELECT gps.start_date INTO
1416: l_yr_start_date
1417: FROM gl_period_statuses gps,
1418: gl_periods gp,
1419: gl_sets_of_books gb
1420: WHERE
1421: gb.set_of_books_id = l_sob_id AND /* p_sob_id => l_sob_id by Bug 6341012 */
1422: gp.period_set_name = gb.period_set_name AND
1423: gp.period_type = gb.accounted_period_type AND