DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_RESPON_PKG dependencies on HR_LOOKUPS

Line 13: FROM hr_lookups

9: l_resp_app PER_RI_CONFIG_RESPONSIBILITY.RESPONSIBILITY_APPLICATION%TYPE;
10: -- Cursor to check the
11: CURSOR csr_cnf_resp IS
12: SELECT lookup_code
13: FROM hr_lookups
14: WHERE lookup_type = 'PER_RI_CONFIG_PRODUCTS'
15: AND lookup_code in (select responsibility_application
16: from per_Ri_config_responsibility
17: where responsibility_application like p_responsibility_application