APPS.OKI_REFRESH_PVT dependencies on GL_SETS_OF_BOOKS

Line 1154: ,gl_sets_of_books sob

1150: , vnm.minor_version
1151: FROM okc_k_headers_b khr
1152: ,okc_k_vers_numbers vnm
1153: ,hr_organization_information oin
1154: ,gl_sets_of_books sob
1155: ,okc_statuses_b sts
1156: WHERE 1 = 1
1157: AND khr.buy_or_sell = 'S'
1158: AND khr.template_yn = 'N'

Line 1220: TYPE sob_acct_period_tab_typ IS TABLE OF gl_sets_of_books.accounted_period_type%TYPE INDEX BY BINARY_INTEGER;

1216: TYPE date_tab_typ IS TABLE OF oki_sales_k_hdrs.start_date%TYPE INDEX BY BINARY_INTEGER;
1217: TYPE currency_tab_typ IS TABLE OF oki_sales_k_hdrs.currency_code%TYPE INDEX BY BINARY_INTEGER;
1218: TYPE rate_tab_typ IS TABLE OF gl_daily_rates.conversion_rate%TYPE INDEX BY BINARY_INTEGER;
1219:
1220: TYPE sob_acct_period_tab_typ IS TABLE OF gl_sets_of_books.accounted_period_type%TYPE INDEX BY BINARY_INTEGER;
1221: TYPE sob_id_tab_typ IS TABLE OF gl_sets_of_books.set_of_books_id%TYPE INDEX BY BINARY_INTEGER;
1222: TYPE period_set_name_tab_typ IS TABLE OF gl_sets_of_books.period_set_name%TYPE INDEX BY BINARY_INTEGER;
1223:
1224: l_no_update_refresh exception;

Line 1221: TYPE sob_id_tab_typ IS TABLE OF gl_sets_of_books.set_of_books_id%TYPE INDEX BY BINARY_INTEGER;

1217: TYPE currency_tab_typ IS TABLE OF oki_sales_k_hdrs.currency_code%TYPE INDEX BY BINARY_INTEGER;
1218: TYPE rate_tab_typ IS TABLE OF gl_daily_rates.conversion_rate%TYPE INDEX BY BINARY_INTEGER;
1219:
1220: TYPE sob_acct_period_tab_typ IS TABLE OF gl_sets_of_books.accounted_period_type%TYPE INDEX BY BINARY_INTEGER;
1221: TYPE sob_id_tab_typ IS TABLE OF gl_sets_of_books.set_of_books_id%TYPE INDEX BY BINARY_INTEGER;
1222: TYPE period_set_name_tab_typ IS TABLE OF gl_sets_of_books.period_set_name%TYPE INDEX BY BINARY_INTEGER;
1223:
1224: l_no_update_refresh exception;
1225: chr_id_tab chr_id_tab_typ;

Line 1222: TYPE period_set_name_tab_typ IS TABLE OF gl_sets_of_books.period_set_name%TYPE INDEX BY BINARY_INTEGER;

1218: TYPE rate_tab_typ IS TABLE OF gl_daily_rates.conversion_rate%TYPE INDEX BY BINARY_INTEGER;
1219:
1220: TYPE sob_acct_period_tab_typ IS TABLE OF gl_sets_of_books.accounted_period_type%TYPE INDEX BY BINARY_INTEGER;
1221: TYPE sob_id_tab_typ IS TABLE OF gl_sets_of_books.set_of_books_id%TYPE INDEX BY BINARY_INTEGER;
1222: TYPE period_set_name_tab_typ IS TABLE OF gl_sets_of_books.period_set_name%TYPE INDEX BY BINARY_INTEGER;
1223:
1224: l_no_update_refresh exception;
1225: chr_id_tab chr_id_tab_typ;
1226: conversion_date_tab date_tab_typ;

Line 1262: gl_sets_of_books sob,

1258: FROM
1259: okc_k_headers_b khr,
1260: okc_k_vers_numbers vnm,
1261: okc_statuses_b sts,
1262: gl_sets_of_books sob,
1263: hr_organization_information oin
1264: WHERE 1 = 1
1265: AND khr.buy_or_sell = 'S'
1266: AND khr.template_yn = 'N'

Line 1313: gl_sets_of_books sob,

1309: SELECT count(*) INTO l_remainder
1310: FROM
1311: okc_k_headers_b khr,
1312: okc_statuses_b sts,
1313: gl_sets_of_books sob,
1314: hr_organization_information oin
1315: WHERE 1 = 1
1316: AND khr.buy_or_sell = 'S'
1317: AND khr.template_yn = 'N'

Line 2722: ,gl_sets_of_books sob

2718: ,cpd.period_name
2719: ,cpd.quarter_num
2720: ,cpd.period_year
2721: FROM gl_periods cpd
2722: ,gl_sets_of_books sob
2723: WHERE shd.close_date between cpd.start_date and cpd.end_date+0.99999
2724: and cpd.period_type = sob.accounted_period_type
2725: and cpd.period_set_name = sob.period_set_name
2726: and cpd.adjustment_period_flag = 'N'

Line 3183: ,gl_sets_of_books sob

3179: ,cpd.period_name
3180: ,cpd.quarter_num
3181: ,cpd.period_year
3182: FROM gl_periods cpd
3183: ,gl_sets_of_books sob
3184: WHERE shd.close_date between cpd.start_date and cpd.end_date+0.99999
3185: and cpd.period_type = sob.accounted_period_type
3186: and cpd.period_set_name = sob.period_set_name
3187: and cpd.adjustment_period_flag = 'N'