APPS.AR_UNACCOUNTED_TRX_SWEEP dependencies on GL_PERIOD_STATUSES

Line 1295: CURSOR c_get_period_dates (p_period_name gl_period_statuses.period_name%type default g_period_name

1291: ,p_validation_message out nocopy varchar2
1292: )
1293: is
1294:
1295: CURSOR c_get_period_dates (p_period_name gl_period_statuses.period_name%type default g_period_name
1296: ,p_include_adj_period gl_period_statuses.adjustment_period_flag%type default null
1297: )
1298: IS
1299: SELECT start_date, end_date, closing_status

Line 1296: ,p_include_adj_period gl_period_statuses.adjustment_period_flag%type default null

1292: )
1293: is
1294:
1295: CURSOR c_get_period_dates (p_period_name gl_period_statuses.period_name%type default g_period_name
1296: ,p_include_adj_period gl_period_statuses.adjustment_period_flag%type default null
1297: )
1298: IS
1299: SELECT start_date, end_date, closing_status
1300: FROM gl_period_statuses

Line 1300: FROM gl_period_statuses

1296: ,p_include_adj_period gl_period_statuses.adjustment_period_flag%type default null
1297: )
1298: IS
1299: SELECT start_date, end_date, closing_status
1300: FROM gl_period_statuses
1301: WHERE period_name = p_period_name
1302: AND application_id = G_AR_APPLICATION_ID
1303: AND set_of_books_id = g_ledger_id
1304: AND (p_include_adj_period is null or (nvl(adjustment_period_flag,'N') = p_include_adj_period));

Line 1306: ld_period_start_date gl_period_statuses.start_date%type;

1302: AND application_id = G_AR_APPLICATION_ID
1303: AND set_of_books_id = g_ledger_id
1304: AND (p_include_adj_period is null or (nvl(adjustment_period_flag,'N') = p_include_adj_period));
1305:
1306: ld_period_start_date gl_period_statuses.start_date%type;
1307: ld_period_end_date gl_period_statuses.end_date%type;
1308: lv_closing_status gl_period_statuses.closing_status%type;
1309: ld_sweep_to_end_date gl_period_statuses.end_date%type;
1310:

Line 1307: ld_period_end_date gl_period_statuses.end_date%type;

1303: AND set_of_books_id = g_ledger_id
1304: AND (p_include_adj_period is null or (nvl(adjustment_period_flag,'N') = p_include_adj_period));
1305:
1306: ld_period_start_date gl_period_statuses.start_date%type;
1307: ld_period_end_date gl_period_statuses.end_date%type;
1308: lv_closing_status gl_period_statuses.closing_status%type;
1309: ld_sweep_to_end_date gl_period_statuses.end_date%type;
1310:
1311: begin

Line 1308: lv_closing_status gl_period_statuses.closing_status%type;

1304: AND (p_include_adj_period is null or (nvl(adjustment_period_flag,'N') = p_include_adj_period));
1305:
1306: ld_period_start_date gl_period_statuses.start_date%type;
1307: ld_period_end_date gl_period_statuses.end_date%type;
1308: lv_closing_status gl_period_statuses.closing_status%type;
1309: ld_sweep_to_end_date gl_period_statuses.end_date%type;
1310:
1311: begin
1312:

Line 1309: ld_sweep_to_end_date gl_period_statuses.end_date%type;

1305:
1306: ld_period_start_date gl_period_statuses.start_date%type;
1307: ld_period_end_date gl_period_statuses.end_date%type;
1308: lv_closing_status gl_period_statuses.closing_status%type;
1309: ld_sweep_to_end_date gl_period_statuses.end_date%type;
1310:
1311: begin
1312:
1313: if g_period_name is not null then