DBA Data[Home] [Help]

APPS.HRI_OPL_PERSON_TYPE_CTGRY dependencies on HRI_CS_PRSNTYP_V

Line 158: hri_cs_prsntyp_v pty' ||

154: ,:l_user_id
155: ,:l_user_id
156: ,:l_current_time
157: FROM
158: hri_cs_prsntyp_v pty' ||
159: l_incr_check;
160:
161: EXECUTE IMMEDIATE l_sql_stmt USING
162: l_current_time,

Line 402: FROM hri_cs_prsntyp_v vw

398: ,vw.wkth_wktyp_code
399: ,vw.wkth_lvl1_code
400: ,vw.wkth_lvl2_code
401: ,vw.include_flag_code
402: FROM hri_cs_prsntyp_v vw
403: WHERE vw.person_type_id = dim.person_type_id
404: AND vw.employment_category_code = dim.employment_category_code
405: AND vw.primary_flag_code = dim.primary_flag_code
406: AND vw.assignment_type_code = dim.assignment_type_code)

Line 409: FROM hri_cs_prsntyp_v vw

405: AND vw.primary_flag_code = dim.primary_flag_code
406: AND vw.assignment_type_code = dim.assignment_type_code)
407: WHERE EXISTS
408: (SELECT null
409: FROM hri_cs_prsntyp_v vw
410: WHERE vw.person_type_id = dim.person_type_id
411: AND vw.employment_category_code = dim.employment_category_code
412: AND vw.primary_flag_code = dim.primary_flag_code
413: AND vw.assignment_type_code = dim.assignment_type_code