APPS.XLA_THIRD_PARTY_MERGE dependencies on GL_PERIOD_STATUSES

Line 2354: FROM gl_period_statuses

2350: IF(p_array_merge_option(i) = 'TRANSFER') THEN
2351: IF(p_array_ledger_category(i) in ('PRIMARY', 'SECONDARY')) THEN
2352: SELECT period_name, start_date, decode(closing_status, 'O', 'F', 'N', 'I', 'F', 'F')
2353: INTO p_gl_period_name(i), p_gl_date(i), p_entry_status(i)
2354: FROM gl_period_statuses
2355: WHERE ledger_id = p_array_ledger_id(i)
2356: AND application_id = 101
2357: AND end_date >= p_merge_date
2358: AND adjustment_period_flag = 'N' --Bug 12930775

Line 2362: FROM gl_period_statuses

2358: AND adjustment_period_flag = 'N' --Bug 12930775
2359: AND closing_status in ('O', 'F', 'N')
2360: AND start_date =
2361: (SELECT min(start_date)
2362: FROM gl_period_statuses
2363: WHERE ledger_id = p_array_ledger_id(i)
2364: AND application_id = 101
2365: AND end_date >= p_merge_date
2366: AND adjustment_period_flag = 'N' --Bug 12930775

Line 2386: FROM gl_period_statuses

2382: p_entry_status(i) := v_entry_status;
2383: ELSE
2384: SELECT period_name, start_date, decode(closing_status, 'O', 'F', 'N', 'I', 'F', 'F')
2385: INTO p_gl_period_name(i), p_gl_date(i), p_entry_status(i)
2386: FROM gl_period_statuses
2387: WHERE ledger_id = p_array_ledger_id(i)
2388: AND application_id = 101
2389: AND end_date >= p_merge_date
2390: AND adjustment_period_flag = 'N' --Bug 12930775

Line 2394: FROM gl_period_statuses

2390: AND adjustment_period_flag = 'N' --Bug 12930775
2391: AND closing_status in ('O', 'F', 'N')
2392: AND start_date =
2393: (SELECT min(start_date)
2394: FROM gl_period_statuses
2395: WHERE ledger_id = p_array_ledger_id(i)
2396: AND application_id = 101
2397: AND end_date >= p_merge_date
2398: AND adjustment_period_flag = 'N' --Bug 12930775

Line 5123: FROM gl_period_statuses

5119:
5120: UPDATE xla_ae_headers_gt xah
5121: SET (accounting_date, period_name) =
5122: (SELECT start_date, period_name
5123: FROM gl_period_statuses
5124: WHERE ledger_id = xah.ledger_id
5125: AND application_id = 101
5126: AND adjustment_period_flag = 'N'
5127: AND closing_status in ('O', 'F')

Line 5130: FROM gl_period_statuses gps

5126: AND adjustment_period_flag = 'N'
5127: AND closing_status in ('O', 'F')
5128: AND start_date =
5129: (SELECT min(gps.start_date)
5130: FROM gl_period_statuses gps
5131: WHERE ledger_id = xah.ledger_id
5132: AND application_id = 101
5133: AND adjustment_period_flag = 'N'
5134: AND start_date > xah.accounting_date

Line 5138: FROM gl_period_statuses gps2

5134: AND start_date > xah.accounting_date
5135: AND closing_status in ('O', 'F')))
5136: WHERE period_name in
5137: (SELECT period_name
5138: FROM gl_period_statuses gps2
5139: WHERE gps2.ledger_id = xah.ledger_id
5140: AND gps2.adjustment_period_flag = 'N'
5141: AND gps2.closing_status = 'C'
5142: AND gps2.period_name = xah.period_name);