APPS.IGF_AW_RULE dependencies on HZ_PARTIES

Line 199: hz_parties hz

195: fa.person_id,
196: hz.party_number
197: FROM
198: igf_ap_fa_base_rec fa,
199: hz_parties hz
200: WHERE
201: fa.ci_cal_type = x_ci_cal_type AND
202: fa.ci_sequence_NUMBER = x_ci_sequence_NUMBER AND
203: hz.party_id = fa.person_id;

Line 241: TYPE CstudTyp IS RECORD ( party_id hz_parties.party_id%TYPE, party_number hz_parties.party_number%TYPE);

237:
238:
239: TYPE CstudCurTyp IS REF CURSOR ;
240: c_stud CstudCurTyp ;
241: TYPE CstudTyp IS RECORD ( party_id hz_parties.party_id%TYPE, party_number hz_parties.party_number%TYPE);
242: l_stud CstudTyp ;
243:
244:
245: CURSOR c_check_group(p_base_id igf_ap_fa_base_rec.base_id%type ) IS

Line 296: hz_parties hz

292: IF l_stud_proc THEN
293: --Bug #5021084. Passing Group ID if the group type is STATIC.
294: IF lv_group_type = 'STATIC' THEN
295: OPEN c_stud FOR 'SELECT hz.party_id , hz.party_number FROM
296: hz_parties hz
297: WHERE
298: hz.party_id in ( '||lv_sql_stmt||' ) ' USING p_pergrp_id;
299: ELSIF lv_group_type = 'DYNAMIC' THEN
300: OPEN c_stud FOR 'SELECT hz.party_id , hz.party_number FROM

Line 301: hz_parties hz

297: WHERE
298: hz.party_id in ( '||lv_sql_stmt||' ) ' USING p_pergrp_id;
299: ELSIF lv_group_type = 'DYNAMIC' THEN
300: OPEN c_stud FOR 'SELECT hz.party_id , hz.party_number FROM
301: hz_parties hz
302: WHERE
303: hz.party_id in ( '||lv_sql_stmt||' ) ';
304: END IF;
305: