APPS.IGF_SE_PAYMENT_PKG dependencies on HZ_PARTIES

Line 182: PROCEDURE get_fk_hz_parties (

178:
179: END get_pk_for_validation;
180:
181:
182: PROCEDURE get_fk_hz_parties (
183: x_party_id IN NUMBER
184: ) AS
185: /*
186: || Created By : ssawhney

Line 218: END get_fk_hz_parties;

214: RETURN;
215: END IF;
216: CLOSE cur_rowid;
217:
218: END get_fk_hz_parties;
219:
220: PROCEDURE check_constraints AS
221: ------------------------------------------------------------------
222: --Created by : veramach, Oracle India

Line 270: cp_person_id hz_parties.party_id%TYPE

266: AND enabled_flag = 'Y';
267: l_lookup c_lookup%ROWTYPE;
268:
269: CURSOR c_pers_num(
270: cp_person_id hz_parties.party_id%TYPE
271: ) IS
272: SELECT party_number
273: FROM hz_parties
274: WHERE party_id = cp_person_id;

Line 273: FROM hz_parties

269: CURSOR c_pers_num(
270: cp_person_id hz_parties.party_id%TYPE
271: ) IS
272: SELECT party_number
273: FROM hz_parties
274: WHERE party_id = cp_person_id;
275: l_pers_num hz_parties.party_number%TYPE;
276:
277: BEGIN

Line 275: l_pers_num hz_parties.party_number%TYPE;

271: ) IS
272: SELECT party_number
273: FROM hz_parties
274: WHERE party_id = cp_person_id;
275: l_pers_num hz_parties.party_number%TYPE;
276:
277: BEGIN
278:
279: IF new_references.payroll_date IS NULL THEN