DBA Data[Home] [Help]

APPS.XLA_THIRD_PARTY_MERGE dependencies on GL_PERIOD_STATUSES

Line 2340: FROM gl_period_statuses

2336: IF(p_array_merge_option(i) = 'TRANSFER') THEN
2337: IF(p_array_ledger_category(i) in ('PRIMARY', 'SECONDARY')) THEN
2338: SELECT period_name, start_date, decode(closing_status, 'O', 'F', 'N', 'I', 'F', 'F')
2339: INTO p_gl_period_name(i), p_gl_date(i), p_entry_status(i)
2340: FROM gl_period_statuses
2341: WHERE ledger_id = p_array_ledger_id(i)
2342: AND application_id = 101
2343: AND end_date >= p_merge_date
2344: AND closing_status in ('O', 'F', 'N')

Line 2347: FROM gl_period_statuses

2343: AND end_date >= p_merge_date
2344: AND closing_status in ('O', 'F', 'N')
2345: AND start_date =
2346: (SELECT min(start_date)
2347: FROM gl_period_statuses
2348: WHERE ledger_id = p_array_ledger_id(i)
2349: AND application_id = 101
2350: AND end_date >= p_merge_date
2351: AND closing_status in ('O', 'F', 'N'));

Line 2370: FROM gl_period_statuses

2366: p_entry_status(i) := v_entry_status;
2367: ELSE
2368: SELECT period_name, start_date, decode(closing_status, 'O', 'F', 'N', 'I', 'F', 'F')
2369: INTO p_gl_period_name(i), p_gl_date(i), p_entry_status(i)
2370: FROM gl_period_statuses
2371: WHERE ledger_id = p_array_ledger_id(i)
2372: AND application_id = 101
2373: AND end_date >= p_merge_date
2374: AND closing_status in ('O', 'F', 'N')

Line 2377: FROM gl_period_statuses

2373: AND end_date >= p_merge_date
2374: AND closing_status in ('O', 'F', 'N')
2375: AND start_date =
2376: (SELECT min(start_date)
2377: FROM gl_period_statuses
2378: WHERE ledger_id = p_array_ledger_id(i)
2379: AND application_id = 101
2380: AND end_date >= p_merge_date
2381: AND closing_status in ('O', 'F', 'N'));

Line 5078: FROM gl_period_statuses

5074:
5075: UPDATE xla_ae_headers_gt xah
5076: SET (accounting_date, period_name) =
5077: (SELECT start_date, period_name
5078: FROM gl_period_statuses
5079: WHERE ledger_id = xah.ledger_id
5080: AND application_id = 101
5081: AND adjustment_period_flag = 'N'
5082: AND closing_status in ('O', 'F')

Line 5085: FROM gl_period_statuses gps

5081: AND adjustment_period_flag = 'N'
5082: AND closing_status in ('O', 'F')
5083: AND start_date =
5084: (SELECT min(gps.start_date)
5085: FROM gl_period_statuses gps
5086: WHERE ledger_id = xah.ledger_id
5087: AND application_id = 101
5088: AND adjustment_period_flag = 'N'
5089: AND start_date > xah.accounting_date

Line 5093: FROM gl_period_statuses gps2

5089: AND start_date > xah.accounting_date
5090: AND closing_status in ('O', 'F')))
5091: WHERE period_name in
5092: (SELECT period_name
5093: FROM gl_period_statuses gps2
5094: WHERE gps2.ledger_id = xah.ledger_id
5095: AND gps2.adjustment_period_flag = 'N'
5096: AND gps2.closing_status = 'C'
5097: AND gps2.period_name = xah.period_name);