DBA Data[Home] [Help]

APPS.IGS_PE_USERID_PKG dependencies on IGS_PE_PERSON_TYPES

Line 1333: CURSOR c_resp(cp_system_type igs_pe_person_types.system_type%TYPE) IS

1329: WHERE c.person_id = cp_party_id
1330: AND cp_sysdate BETWEEN c.start_date AND NVL(c.end_date, cp_sysdate);
1331:
1332: -- Cursor to get the responsibilities associated with a particular person type
1333: CURSOR c_resp(cp_system_type igs_pe_person_types.system_type%TYPE) IS
1334: SELECT st.responsibility_key resp_name,
1335: st.application_short_name apps_name,
1336: rsp.application_id apps_id,
1337: rsp.responsibility_id resp_id