APPS.IGS_PE_WF_GEN dependencies on IGS_PE_HZ_PARTIES

Line 329: igs_pe_hz_parties

325:
326: CURSOR chk_oss_party(cp_party_id NUMBER) IS
327: SELECT inst_org_ind
328: FROM
329: igs_pe_hz_parties
330: WHERE
331: party_id = cp_party_id;
332:
333:

Line 572: FROM hz_parties hp, hz_party_sites hps, igs_pe_hz_parties php

568:
569: CURSOR chk_oss_party(cp_party_site_id NUMBER) IS
570: SELECT hp.party_number, hp.party_name, hps.location_id,
571: php.inst_org_ind, hps.identifying_address_flag, php.oss_org_unit_cd
572: FROM hz_parties hp, hz_party_sites hps, igs_pe_hz_parties php
573: WHERE hp.party_id = hps.party_id
574: AND hp.party_id = php.party_id
575: AND hp.status = 'A'
576: AND hps.status = 'A'

Line 1210: CURSOR cur_inst_per (cp_party_id igs_pe_hz_parties.party_id%TYPE) IS

1206: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
1207: l_eventdata CLOB;
1208: l_str VARCHAR2(32767);
1209:
1210: CURSOR cur_inst_per (cp_party_id igs_pe_hz_parties.party_id%TYPE) IS
1211: SELECT inst_org_ind
1212: FROM igs_pe_hz_parties
1213: WHERE party_id=cp_party_id;
1214: l_c_per_org VARCHAR2(1);

Line 1212: FROM igs_pe_hz_parties

1208: l_str VARCHAR2(32767);
1209:
1210: CURSOR cur_inst_per (cp_party_id igs_pe_hz_parties.party_id%TYPE) IS
1211: SELECT inst_org_ind
1212: FROM igs_pe_hz_parties
1213: WHERE party_id=cp_party_id;
1214: l_c_per_org VARCHAR2(1);
1215:
1216: BEGIN