DBA Data[Home] [Help]

APPS.PA_XLA_UPGRADE dependencies on HR_ORGANIZATION_INFORMATION

Line 267: HR_ORGANIZATION_INFORMATION hoi

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
271: AND cdl.acct_event_id is null

Line 338: HR_ORGANIZATION_INFORMATION hoi

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
342: AND cdl.acct_event_id is null

Line 1103: HR_ORGANIZATION_INFORMATION hoi

1099: PA_COST_DISTRIBUTION_LINES_ALL cdl,
1100: PA_EXPENDITURE_ITEMS_ALL ei,
1101: PA_IMPLEMENTATIONS_ALL imp,
1102: XLA_EVENTS evt,
1103: HR_ORGANIZATION_INFORMATION hoi
1104: where mc.expenditure_item_id = cdl.expenditure_item_id
1105: and mc.line_num = cdl.line_num
1106: and mc.xla_migrated_flag is null
1107: and mc.batch_name is not null

Line 1154: HR_ORGANIZATION_INFORMATION hoi

1150: PA_CC_DIST_LINES_ALL cdl,
1151: PA_EXPENDITURE_ITEMS_ALL ei,
1152: PA_IMPLEMENTATIONS_ALL imp,
1153: XLA_EVENTS evt,
1154: HR_ORGANIZATION_INFORMATION hoi
1155: where mc.expenditure_item_id = cdl.expenditure_item_id
1156: and mc.line_num = cdl.line_num
1157: and mc.xla_migrated_flag is null
1158: and mc.transfer_status_code = 'A'