DBA Data[Home] [Help]

APPS.PA_XLA_UPGRADE dependencies on HR_ORGANIZATION_INFORMATION

Line 272: HR_ORGANIZATION_INFORMATION hoi

268: where reference = 'GL_PERIOD_STATUSES'
269: AND status = 'P'
270: AND batch_id = p_upg_batch_id
271: group by ledger_id) ctrl,
272: HR_ORGANIZATION_INFORMATION hoi
273: WHERE cdl.expenditure_item_id between l_start_eiid and l_end_eiid
274: AND cdl.transfer_status_code = 'A'
275: AND cdl.batch_name is not null
276: AND cdl.acct_event_id is null

Line 348: HR_ORGANIZATION_INFORMATION hoi

344: where reference = 'GL_PERIOD_STATUSES'
345: AND status = 'P'
346: AND batch_id = p_upg_batch_id
347: group by ledger_id) ctrl,
348: HR_ORGANIZATION_INFORMATION hoi
349: WHERE cdl.expenditure_item_id between l_start_eiid and l_end_eiid
350: AND cdl.transfer_status_code = 'A'
351: AND cdl.gl_batch_name is not null
352: AND cdl.acct_event_id is null

Line 1114: HR_ORGANIZATION_INFORMATION hoi

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
1117: and mc.xla_migrated_flag is null
1118: -- and mc.batch_name is not null ....Commented for bug 7415060

Line 1165: HR_ORGANIZATION_INFORMATION hoi

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
1168: and mc.xla_migrated_flag is null
1169: and mc.transfer_status_code = 'A'