APPS.PA_XLA_UPGRADE dependencies on GL_PERIOD_STATUSES

Line 277: AND ctrl.reference = 'GL_PERIOD_STATUSES'

273: AND (cdl.line_type in ('C','D') OR ei.system_linkage_function in ('BTC','INV','ST','PJ','USG','WIP','OT'))
274: AND cdl.org_id = imp.org_id
275: AND cdl.gl_date between to_date(ctrl.min_value,'J') and to_date (ctrl.max_value,'J')
276: AND ctrl.ledger_id = imp.set_of_books_id
277: AND ctrl.reference = 'GL_PERIOD_STATUSES'
278: AND ctrl.status = 'P'
279: AND ctrl.batch_id = p_upg_batch_id
280: AND hoi.organization_id = imp.org_id
281: AND hoi.org_information_context = 'Operating Unit Information'

Line 347: AND ctrl.reference = 'GL_PERIOD_STATUSES'

343: AND cdl.expenditure_item_id = ei.expenditure_item_id
344: AND cdl.org_id = imp.org_id
345: AND cdl.gl_date between to_date(ctrl.min_value,'J') and to_date (ctrl.max_value,'J')
346: AND ctrl.ledger_id = imp.set_of_books_id
347: AND ctrl.reference = 'GL_PERIOD_STATUSES'
348: AND ctrl.status = 'P'
349: AND ctrl.batch_id = p_upg_batch_id
350: AND hoi.organization_id = imp.org_id
351: AND hoi.org_information_context = 'Operating Unit Information'

Line 1537: FROM gl_period_statuses

1533: IS
1534:
1535: CURSOR c_date_range is
1536: SELECT ledger_id, to_char(min(start_date),'J') min_date, to_char(max(end_date),'J') max_date
1537: FROM gl_period_statuses
1538: WHERE application_id = 275
1539: AND migration_status_code = 'P'
1540: GROUP BY ledger_id;
1541:

Line 1560: -- with gl_period_statuses table in the main upgrade

1556: BEGIN
1557:
1558: --------------------------------------------------------------------------------------------------
1559: -- For each ledger min and max gl dates are stored in the control table so as to avoid joining
1560: -- with gl_period_statuses table in the main upgrade
1561: ---------------------------------------------------------------------------------------------------
1562:
1563: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE,
1564: LEDGER_ID, BATCH_ID, STATUS)

Line 1565: SELECT 'GL_PERIOD_STATUSES', to_char(min(start_date),'J') , to_char(max(end_date),'J') , ledger_id, p_batch_id, 'P'

1561: ---------------------------------------------------------------------------------------------------
1562:
1563: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE,
1564: LEDGER_ID, BATCH_ID, STATUS)
1565: SELECT 'GL_PERIOD_STATUSES', to_char(min(start_date),'J') , to_char(max(end_date),'J') , ledger_id, p_batch_id, 'P'
1566: FROM gl_period_statuses
1567: WHERE application_id = 275
1568: AND migration_status_code = 'P'
1569: GROUP BY ledger_id;

Line 1566: FROM gl_period_statuses

1562:
1563: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE,
1564: LEDGER_ID, BATCH_ID, STATUS)
1565: SELECT 'GL_PERIOD_STATUSES', to_char(min(start_date),'J') , to_char(max(end_date),'J') , ledger_id, p_batch_id, 'P'
1566: FROM gl_period_statuses
1567: WHERE application_id = 275
1568: AND migration_status_code = 'P'
1569: GROUP BY ledger_id;
1570:

Line 1575: and reference = 'GL_PERIOD_STATUSES';

1571: select min(to_date(min_value,'J') ) , max(to_date(max_value,'J') )
1572: into l_start_date, l_end_date
1573: from pa_xla_upg_ctrl
1574: where batch_id = p_batch_id
1575: and reference = 'GL_PERIOD_STATUSES';
1576:
1577:
1578:
1579:

Line 1589: FROM gl_period_statuses per,

1585: SELECT distinct per1.ledger_id,
1586: per1.ledger_id,
1587: per1.period_name,
1588: p_batch_id
1589: FROM gl_period_statuses per,
1590: gl_period_statuses per1
1591: WHERE per.application_id =275
1592: AND per.migration_status_code ='P'
1593: AND per1.application_id =101

Line 1590: gl_period_statuses per1

1586: per1.ledger_id,
1587: per1.period_name,
1588: p_batch_id
1589: FROM gl_period_statuses per,
1590: gl_period_statuses per1
1591: WHERE per.application_id =275
1592: AND per.migration_status_code ='P'
1593: AND per1.application_id =101
1594: AND per1.ledger_id = per.ledger_id