APPS.HRI_OPL_JOB_JOB_ROLE dependencies on HRI_CS_JOB_JOB_ROLE_V

Line 101: FROM hri_cs_job_job_role_v;

97: ,l_current_time
98: ,l_current_time
99: ,l_user_id
100: ,l_user_id
101: FROM hri_cs_job_job_role_v;
102: --
103: dbg('Inserted '||sql%rowcount||' records.');
104: --
105: output('Finished Fully refreshing the Job Role table.');

Line 168: FROM hri_cs_job_job_role_v jbrlv

164: ,l_current_time
165: ,l_current_time
166: ,l_user_id
167: ,l_user_id
168: FROM hri_cs_job_job_role_v jbrlv
169: WHERE NOT EXISTS
170: (SELECT null
171: FROM hri_cs_job_job_role_ct jbrl
172: WHERE jbrlv.job_id = jbrl.job_id);

Line 183: FROM hri_cs_job_job_role_v jbrlv

179: --
180: DELETE FROM hri_cs_job_job_role_ct jbrl
181: WHERE NOT EXISTS
182: (SELECT null
183: FROM hri_cs_job_job_role_v jbrlv
184: WHERE jbrlv.job_id = jbrl.job_id);
185: --
186: dbg('Deleted '||sql%rowcount||' records.');
187: --

Line 198: FROM hri_cs_job_job_role_v jbrlv

194: ,primary_role_for_job_flag) =
195: (SELECT
196: jbrlv.job_role_code
197: ,primary_role_for_job_flag
198: FROM hri_cs_job_job_role_v jbrlv
199: WHERE jbrlv.job_id = jbrl.job_id)
200: WHERE EXISTS
201: (SELECT NULL
202: FROM hri_cs_job_job_role_v jbrlv

Line 202: FROM hri_cs_job_job_role_v jbrlv

198: FROM hri_cs_job_job_role_v jbrlv
199: WHERE jbrlv.job_id = jbrl.job_id)
200: WHERE EXISTS
201: (SELECT NULL
202: FROM hri_cs_job_job_role_v jbrlv
203: WHERE jbrlv.job_id = jbrl.job_id
204: AND (
205: (jbrlv.job_role_code <> jbrl.job_role_code)
206: OR