DBA Data[Home] [Help]

APPS.IGS_PE_GEN_003 dependencies on FND_RESPONSIBILITY_VL

Line 185: FROM igs_pe_typ_rsp_dflt oss , fnd_responsibility_vl default_resp

181: -- Exclusively for Insert.
182: ---- Get the responsibilities associated with the System Person Type, which are not associated with the person already. INSERT CASE
183: CURSOR get_resp_info_cur(cp_system_person_typ igs_pe_typ_rsp_dflt.s_person_type%type, cp_user_id fnd_user.user_id%type) IS
184: SELECT default_resp.responsibility_key, oss.application_short_name, default_resp.responsibility_id, default_resp.application_id, default_resp.description
185: FROM igs_pe_typ_rsp_dflt oss , fnd_responsibility_vl default_resp
186: WHERE oss.s_person_type= cp_system_person_typ
187: AND oss.responsibility_key = default_resp.responsibility_key
188: AND NOT EXISTS
189: (SELECT 1