DBA Data[Home] [Help]

APPS.HR_DM_CLEANUP dependencies on HR_DM_TABLES

Line 68: FROM hr_dm_tables tbl,

64: lp.parameter4, lp.parameter6,
65: lp.parameter5, lp.parameter8,
66: lp.parameter7, lp.parameter10,
67: lp.application_id
68: FROM hr_dm_tables tbl,
69: hr_dm_loader_params lp,
70: hr_dm_phase_items pi
71: WHERE (pi.phase_item_id = p_phase_item_id)
72: AND (pi.loader_params_id = lp.loader_params_id)

Line 252: hr_dm_tables tbl

248:
249: CURSOR csr_get_pi IS
250: SELECT pi.phase_item_id, pi.loader_name, pi.status
251: FROM hr_dm_phase_items pi,
252: hr_dm_tables tbl
253: WHERE (pi.status = 'NS')
254: AND (pi.phase_id = l_phase_id)
255: AND (pi.loader_name = tbl.loader_name);
256: