APPS.IGS_AD_IMP_026 dependencies on IGS_OR_UNIT

Line 80: ' SELECT ou1.org_unit_cd FROM igs_or_unit ou1,igs_or_status org_status WHERE org_status.s_org_status = ''ACTIVE''

76: WHERE person_id = cp_person_id;
77:
78: --kumma, 2941138, PKM_ISSUE, Used the bind variable instead of using the conact for preparing the statement
79: l_select_clause VARCHAR2(2000):=
80: ' SELECT ou1.org_unit_cd FROM igs_or_unit ou1,igs_or_status org_status WHERE org_status.s_org_status = ''ACTIVE''
81: AND org_status.org_status = ou1.org_status AND ou1.org_unit_cd = :agent_org_unit_cd';
82:
83: TYPE org_unit_ref_cur IS REF CURSOR;
84: org_unit_cur org_unit_ref_cur;

Line 85: l_org_unit_cd igs_or_unit.org_unit_cd%TYPE;

81: AND org_status.org_status = ou1.org_status AND ou1.org_unit_cd = :agent_org_unit_cd';
82:
83: TYPE org_unit_ref_cur IS REF CURSOR;
84: org_unit_cur org_unit_ref_cur;
85: l_org_unit_cd igs_or_unit.org_unit_cd%TYPE;
86:
87: CURSOR party_id_cur IS
88: SELECT person_id
89: FROM igs_pe_person_base_v