APPS.IGS_PE_WF_GEN dependencies on HZ_PARTIES

Line 138: l_person_number hz_parties.party_number%TYPE;

134: l_user_name fnd_user.user_name%TYPE;
135: l_date DATE;
136: l_action VARCHAR2(30);
137: l_name hz_person_profiles.person_name%TYPE;
138: l_person_number hz_parties.party_number%TYPE;
139: l_message VARCHAR2(2000);
140: res_dtl_rec res_dtl_cur%ROWTYPE;
141: BEGIN
142:

Line 306: FROM hz_parties hp, hz_party_sites hps

302: IS
303:
304: CURSOR cur_get_party_id(cp_party_site_id NUMBER) IS
305: SELECT party_number, party_name, location_id,hp.party_type,hp.party_id
306: FROM hz_parties hp, hz_party_sites hps
307: WHERE hp.party_id = hps.party_id AND
308: (hp.party_type = 'PERSON' OR hp.party_type = 'ORGANIZATION') AND
309: hp.status = 'A' AND
310: hps.party_site_id = cp_party_site_id;

Line 319: hz_parties hzp

315: hzp.party_name,hps.identifying_address_flag
316: FROM
317: hz_party_sites hps,
318: hz_locations hzl,
319: hz_parties hzp
320: WHERE
321: hps.party_site_id=cp_party_site_id AND
322: hps.location_id=hzl.location_id AND
323: hzp.party_id=hps.party_id;

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 1058: CURSOR c_person(cp_person_id hz_parties.party_id%TYPE) IS

1054: l_c_document VARCHAR2(32000);
1055: l_c_itemtype VARCHAR2(100);
1056: l_c_itemkey WF_ITEM_ATTRIBUTE_VALUES.ITEM_KEY%TYPE;
1057:
1058: CURSOR c_person(cp_person_id hz_parties.party_id%TYPE) IS
1059: SELECT ''||party_number||'
'|| person_last_name||', '||person_first_name|| '
' person_record
1060: FROM hz_parties
1061: WHERE party_id = cp_person_id;
1062: l_person_record VARCHAR2(2000);

Line 1060: FROM hz_parties

1056: l_c_itemkey WF_ITEM_ATTRIBUTE_VALUES.ITEM_KEY%TYPE;
1057:
1058: CURSOR c_person(cp_person_id hz_parties.party_id%TYPE) IS
1059: SELECT ''||party_number||'
'|| person_last_name||', '||person_first_name|| '
' person_record
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

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