APPS.HRI_OPL_WRKFC_EVT_TYPE dependencies on HRI_CL_WEVT_EVTYPCMB_CT

Line 21: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.HRI_CL_WEVT_EVTYPCMB_CT';

17: BEGIN
18:
19: -- Get HRI schema name - get_app_info populates l_schema
20: IF fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema) THEN
21: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.HRI_CL_WEVT_EVTYPCMB_CT';
22: END IF;
23:
24: -- Insert -1 row
25: INSERT INTO hri_cl_wevt_evtypcmb_ct

Line 25: INSERT INTO hri_cl_wevt_evtypcmb_ct

21: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.HRI_CL_WEVT_EVTYPCMB_CT';
22: END IF;
23:
24: -- Insert -1 row
25: INSERT INTO hri_cl_wevt_evtypcmb_ct
26: (etcb_evtypcmb_pk
27: ,etcb_evtypcmb_code
28: ,etcb_assgnmnt_chng_flag_code
29: ,etcb_salary_chng_flag_code

Line 117: SELECT hri_cl_wevt_evtypcmb_ct_s.nextval

113:
114: BEGIN
115:
116: -- Get next sequence value
117: SELECT hri_cl_wevt_evtypcmb_ct_s.nextval
118: INTO l_evtypcmb_fk
119: FROM dual;
120:
121: -- Insert row

Line 122: INSERT INTO hri_cl_wevt_evtypcmb_ct

118: INTO l_evtypcmb_fk
119: FROM dual;
120:
121: -- Insert row
122: INSERT INTO hri_cl_wevt_evtypcmb_ct
123: (etcb_evtypcmb_pk
124: ,etcb_evtypcmb_code
125: ,etcb_assgnmnt_chng_flag_code
126: ,etcb_salary_chng_flag_code

Line 241: FROM hri_cl_wevt_evtypcmb_ct

237: RETURN NUMBER IS
238:
239: CURSOR evtypcmb_csr(v_evtypcmb_code IN VARCHAR2) IS
240: SELECT etcb_evtypcmb_pk
241: FROM hri_cl_wevt_evtypcmb_ct
242: WHERE etcb_evtypcmb_code = v_evtypcmb_code;
243:
244: l_evtypcmb_fk NUMBER;
245: