APPS.PA_XLA_UPGRADE dependencies on PA_IMPLEMENTATIONS_ALL

Line 265: PA_IMPLEMENTATIONS_ALL imp,

261: to_char(cdl.dr_code_combination_id) DR_REFERENCE_2,
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: (select ledger_id,min(min_value) min_value, max(max_value) max_value from
267: PA_XLA_UPG_CTRL
268: where reference = 'GL_PERIOD_STATUSES'
269: AND status = 'P'

Line 341: PA_IMPLEMENTATIONS_ALL imp,

337: to_char(cdl.dr_code_combination_id) DR_REFERENCE_2,
338: to_char(cdl.cr_code_combination_id) CR_REFERENCE_2
339: FROM PA_CC_DIST_LINES_ALL cdl,
340: PA_EXPENDITURE_ITEMS_ALL ei,
341: PA_IMPLEMENTATIONS_ALL imp,
342: (select ledger_id,min(min_value) min_value, max(max_value) max_value from
343: PA_XLA_UPG_CTRL
344: where reference = 'GL_PERIOD_STATUSES'
345: AND status = 'P'

Line 1112: PA_IMPLEMENTATIONS_ALL imp,

1108: to_char('-99') CR_REFERENCE_2
1109: from PA_MC_COST_DIST_LINES_ALL mc,
1110: PA_COST_DISTRIBUTION_LINES_ALL cdl,
1111: PA_EXPENDITURE_ITEMS_ALL ei,
1112: PA_IMPLEMENTATIONS_ALL imp,
1113: XLA_EVENTS evt,
1114: HR_ORGANIZATION_INFORMATION hoi
1115: where mc.expenditure_item_id = cdl.expenditure_item_id
1116: and mc.line_num = cdl.line_num

Line 1163: PA_IMPLEMENTATIONS_ALL imp,

1159: to_char(cdl.cr_code_combination_id) CR_REFERENCE_2
1160: from PA_MC_CC_DIST_LINES_ALL mc,
1161: PA_CC_DIST_LINES_ALL cdl,
1162: PA_EXPENDITURE_ITEMS_ALL ei,
1163: PA_IMPLEMENTATIONS_ALL imp,
1164: XLA_EVENTS evt,
1165: HR_ORGANIZATION_INFORMATION hoi
1166: where mc.expenditure_item_id = cdl.expenditure_item_id
1167: and mc.line_num = cdl.line_num

Line 1581: AND exists (select 1 from pa_implementations_all where set_of_books_id

1577: SELECT 'GL_PERIOD_STATUSES', to_char(min(start_date),'J') , to_char(max(end_date),'J') , ledger_id, p_batch_id, 'P'
1578: FROM gl_period_statuses
1579: WHERE application_id = 275
1580: AND migration_status_code = 'P'
1581: AND exists (select 1 from pa_implementations_all where set_of_books_id
1582: = ledger_id and SAME_PA_GL_PERIOD = 'N')
1583: GROUP BY ledger_id;
1584:
1585: INSERT INTO pa_xla_upg_ctrl (REFERENCE, MIN_VALUE, MAX_VALUE,

Line 1591: AND exists (select 1 from pa_implementations_all where set_of_books_id

1587: SELECT 'GL_PERIOD_STATUSES', to_char(min(start_date),'J') , to_char(max(end_date),'J') , ledger_id, p_batch_id, 'P'
1588: FROM gl_period_statuses
1589: WHERE application_id = 8721
1590: AND migration_status_code = 'P'
1591: AND exists (select 1 from pa_implementations_all where set_of_books_id
1592: = ledger_id and SAME_PA_GL_PERIOD = 'Y')
1593: GROUP BY ledger_id;
1594:
1595: select min(to_date(min_value,'J') ) , max(to_date(max_value,'J') )

Line 1622: from pa_implementations_all

1618: AND per1.ledger_id = per.ledger_id
1619: AND (per1.start_date between per.start_date and per.end_date OR
1620: per1.end_date between per.start_date and per.end_date)
1621: AND EXISTS ( Select null
1622: from pa_implementations_all
1623: where set_of_books_id = per.ledger_id
1624: and (((per.application_id = 275 and
1625: SAME_PA_GL_PERIOD = 'N')
1626: or (per.application_id = 8721 and

Line 1642: pa_implementations_all imp

1638: per.period_name,
1639: p_batch_id
1640: FROM PA_PRIM_REP_LEGER_tmp per,
1641: gl_mc_reporting_options_11i mc,
1642: pa_implementations_all imp
1643: WHERE per.prim_ledger_id = mc.primary_set_of_books_id
1644: AND mc.application_id in( 275,8721)
1645: AND imp.org_id = mc.org_id;
1646: