eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SE_GEN_001 dependencies on HZ_PARTIES

Line 39: FROM hz_parties hz,

35: AND lookup_code IN ('AWARD_YEAR','FUND_CODE','PERSON_NUMBER','PARAMETER_PASS');
36:
37: CURSOR c_person_dtls (c_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
38: SELECT party_number
39: FROM hz_parties hz,
40: igf_ap_fa_base_rec_all fa
41: WHERE fa.person_id = hz.party_id
42: AND fa.base_id = c_base_id;
43:

Line 240: p_person_id IN hz_parties.party_id%TYPE,

236: END display_payroll_params;
237:
238:
239: PROCEDURE send_work_auth(p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
240: p_person_id IN hz_parties.party_id%TYPE,
241: p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,
242: p_award_id IN igf_aw_award.award_id%TYPE,
243: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
244: p_ld_seq_no IN igs_ca_inst.sequence_number%TYPE,

Line 304: CURSOR c_hzp (cv_person_id hz_parties.party_id%TYPE ) IS

300: FROM igf_lookups_view
301: WHERE lookup_type = 'IGF_MATCH_CRITERIA'
302: AND lookup_code = 'SSN';
303:
304: CURSOR c_hzp (cv_person_id hz_parties.party_id%TYPE ) IS
305: SELECT person_first_name, person_last_name, address1, address2, address3, address4, city,
306: state, province, county, country
307: FROM hz_parties
308: WHERE party_id = cv_person_id;

Line 307: FROM hz_parties

303:
304: CURSOR c_hzp (cv_person_id hz_parties.party_id%TYPE ) IS
305: SELECT person_first_name, person_last_name, address1, address2, address3, address4, city,
306: state, province, county, country
307: FROM hz_parties
308: WHERE party_id = cv_person_id;
309:
310: CURSOR c_pe (cv_person_id hz_parties.party_id%TYPE ) IS
311: SELECT gender sex, birth_date birth_dt

Line 310: CURSOR c_pe (cv_person_id hz_parties.party_id%TYPE ) IS

306: state, province, county, country
307: FROM hz_parties
308: WHERE party_id = cv_person_id;
309:
310: CURSOR c_pe (cv_person_id hz_parties.party_id%TYPE ) IS
311: SELECT gender sex, birth_date birth_dt
312: FROM igs_pe_person_base_v
313: WHERE person_id = cv_person_id;
314:

Line 315: CURSOR c_visa (cv_person_id hz_parties.party_id%TYPE ) IS

311: SELECT gender sex, birth_date birth_dt
312: FROM igs_pe_person_base_v
313: WHERE person_id = cv_person_id;
314:
315: CURSOR c_visa (cv_person_id hz_parties.party_id%TYPE ) IS
316: SELECT a.visa_type,a.visa_category,a.visa_number,a.visa_expiry_date, b.visit_start_date entry_date
317: FROM igs_pe_visa a,igs_pe_visit_histry b
318: WHERE a.person_id = cv_person_id
319: AND NVL(a.visa_expiry_date,SYSDATE) >= SYSDATE

Line 323: CURSOR c_stat (cv_person_id hz_parties.party_id%TYPE ) IS

319: AND NVL(a.visa_expiry_date,SYSDATE) >= SYSDATE
320: AND a.visa_id = b.visa_id
321: ORDER BY a.visa_expiry_date DESC;
322:
323: CURSOR c_stat (cv_person_id hz_parties.party_id%TYPE ) IS
324: SELECT NVL(marital_status,'NA') marital_status
325: FROM HZ_PERSON_PROFILES
326: WHERE party_id = cv_person_id
327: AND SYSDATE BETWEEN EFFECTIVE_START_DATE AND NVL(EFFECTIVE_END_DATE, SYSDATE);

Line 373: l_person_id hz_parties.party_id%TYPE;

369: old_auth_rec c_old_auth%ROWTYPE;
370: tokens_rec c_get_tokens%ROWTYPE;
371:
372: l_place VARCHAR2(30);
373: l_person_id hz_parties.party_id%TYPE;
374: l_fund_id igf_aw_fund_mast.fund_id%TYPE;
375: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
376: l_ld_seq_no igs_ca_inst.sequence_number%TYPE;
377: l_auth_id igf_se_auth.auth_id%TYPE := 0;

Line 832: hz_parties hz

828: FROM igf_aw_award_all awd,
829: igf_aw_fund_mast_all fmast,
830: igf_aw_fund_cat_all fcat,
831: igf_ap_fa_base_rec_all fa,
832: hz_parties hz
833: WHERE fcat.fed_fund_code = 'FWS'
834: AND awd.award_status = 'ACCEPTED'
835: AND awd.fund_id = NVL(cp_fund_id, awd.fund_id)
836: AND awd.base_id = NVL(cp_base_id, awd.base_id)

Line 996: cv_person_id hz_parties.party_id%TYPE) IS

992: ORDER BY auth_id, person_id
993: FOR UPDATE NOWAIT;
994:
995: CURSOR c_auth_count(cv_auth_id igf_se_auth.auth_id%TYPE,
996: cv_person_id hz_parties.party_id%TYPE) IS
997: SELECT COUNT(*) count
998: FROM igf_se_auth c,igf_aw_award a, igf_ap_fa_base_rec b
999: WHERE c.auth_id = cv_auth_id
1000: AND c.award_id = a.award_id

Line 1013: FROM igf_se_payment_int pint, hz_parties hz

1009: AND lookup_code = c_error_cd;
1010:
1011: CURSOR cur_pymt_int IS
1012: SELECT pint.status, pint.error_code, hz.party_number, pint.auth_id
1013: FROM igf_se_payment_int pint, hz_parties hz
1014: WHERE pint.status IN ('DONE','ERROR')
1015: AND pint.person_id = hz.party_id
1016: AND pint.batch_id = p_batch_id;
1017:

Line 1554: PROCEDURE se_notify(p_person_id IN hz_parties.party_id%TYPE,

1550: -- app_exception.raise_exception;
1551: END payroll_adjust;
1552:
1553:
1554: PROCEDURE se_notify(p_person_id IN hz_parties.party_id%TYPE,
1555: p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,
1556: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
1557: p_ld_seq_no IN igs_ca_inst.sequence_number%TYPE,
1558: p_award_id IN igf_aw_award_all.award_id%TYPE