APPS.PA_XLA_UPGRADE dependencies on PA_XLA_UPG_CTRL

Line 266: PA_XLA_UPG_CTRL ctrl,

262: to_char('-99') CR_REFERENCE_2
263: FROM PA_COST_DISTRIBUTION_LINES_ALL cdl,
264: PA_EXPENDITURE_ITEMS_ALL ei,
265: PA_IMPLEMENTATIONS_ALL imp,
266: PA_XLA_UPG_CTRL ctrl,
267: HR_ORGANIZATION_INFORMATION hoi
268: WHERE cdl.expenditure_item_id between l_start_eiid and l_end_eiid
269: AND cdl.transfer_status_code = 'A'
270: AND cdl.batch_name is not null

Line 337: PA_XLA_UPG_CTRL ctrl,

333: to_char(cdl.cr_code_combination_id) CR_REFERENCE_2
334: FROM PA_CC_DIST_LINES_ALL cdl,
335: PA_EXPENDITURE_ITEMS_ALL ei,
336: PA_IMPLEMENTATIONS_ALL imp,
337: PA_XLA_UPG_CTRL ctrl,
338: HR_ORGANIZATION_INFORMATION hoi
339: WHERE cdl.expenditure_item_id between l_start_eiid and l_end_eiid
340: AND cdl.transfer_status_code = 'A'
341: AND cdl.gl_batch_name is not null

Line 1563: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE,

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)
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

Line 1573: from pa_xla_upg_ctrl

1569: GROUP BY ledger_id;
1570:
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:

Line 1642: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE, LEDGER_ID, BATCH_ID, STATUS)

1638:
1639: l_jeh_min_id := null;
1640: l_jeh_max_id := null;
1641:
1642: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE, LEDGER_ID, BATCH_ID, STATUS)
1643: VALUES ('GL_JE_HEADERS', l_jeh_min_id, l_jeh_max_id, '', p_batch_id, 'P');
1644:
1645: ---------------------------------------------------------------------------------------------------
1646: -- Min and max expenditure item ids are stored in the control table to drive the cost and cross

Line 1690: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE, LEDGER_ID, BATCH_ID, STATUS)

1686: 3 Only Cross Charge is there
1687:
1688: */
1689:
1690: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE, LEDGER_ID, BATCH_ID, STATUS)
1691: VALUES ('COST_CROSS_FLAG', l_cost_cross, l_cost_cross, '', p_batch_id, 'P');
1692:
1693:
1694: l_min_eiid := 0;

Line 1724: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE, LEDGER_ID, BATCH_ID, STATUS)

1720: end if;
1721: end if;
1722:
1723:
1724: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE, LEDGER_ID, BATCH_ID, STATUS)
1725: VALUES ('PA_EXPENDITURE_ITEMS_ALL', l_min_eiid, l_max_eiid, '', p_batch_id, 'P');
1726:
1727:
1728:

Line 1746: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE, LEDGER_ID, BATCH_ID, STATUS)

1742: END;
1743:
1744: IF l_cnt > 0
1745: THEN
1746: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE, LEDGER_ID, BATCH_ID, STATUS)
1747: VALUES ('MRC', l_min_eiid, l_max_eiid, '', p_batch_id, 'P');
1748:
1749: x_mrc_enabled := 'Y';
1750: ELSE