DBA Data[Home] [Help]

APPS.IGS_PE_WF_GEN dependencies on IGS_OR_INST_ORG_BASE_V

Line 1064: CURSOR c_inst(cp_party_id igs_or_inst_org_base_v.party_id%TYPE) IS

1060: FROM hz_parties
1061: WHERE party_id = cp_person_id;
1062: l_person_record VARCHAR2(2000);
1063:
1064: CURSOR c_inst(cp_party_id igs_or_inst_org_base_v.party_id%TYPE) IS
1065: SELECT ''||party_number||'
'|| party_name|| '
' person_record
1066: FROM igs_or_inst_org_base_v
1067: WHERE party_id = cp_party_id
1068: AND inst_org_ind='I';

Line 1066: FROM igs_or_inst_org_base_v

1062: l_person_record VARCHAR2(2000);
1063:
1064: CURSOR c_inst(cp_party_id igs_or_inst_org_base_v.party_id%TYPE) IS
1065: SELECT ''||party_number||'
'|| party_name|| '
' person_record
1066: FROM igs_or_inst_org_base_v
1067: WHERE party_id = cp_party_id
1068: AND inst_org_ind='I';
1069:
1070: TYPE person_id IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;