APPS.IGF_SE_GEN_001 dependencies on IGS_PE_PERSON

Line 56: l_base_id igs_pe_person.person_number%TYPE := NULL;

52: l_person_number igf_lookups_view.meaning%TYPE;
53: l_para_pass igf_lookups_view.meaning%TYPE;
54: l_awd_alternate_code igs_ca_inst.alternate_code%TYPE := NULL;
55: l_fund_id igf_aw_fund_mast_all.fund_code%TYPE := NULL;
56: l_base_id igs_pe_person.person_number%TYPE := NULL;
57:
58: BEGIN
59:
60: -- Get all the Parameters

Line 113: PROCEDURE display_auth_process_log(p_person_number IN igs_pe_person.person_number%TYPE,

109:
110: END display_auth_params;
111:
112:
113: PROCEDURE display_auth_process_log(p_person_number IN igs_pe_person.person_number%TYPE,
114: p_fund_code IN igf_aw_fund_mast_all.fund_code%TYPE,
115: p_award_id IN igf_aw_award_v.award_id%TYPE
116: ) IS
117: ------------------------------------------------------------------------------------

Line 284: igs_pe_person_id_typ pit_2

280: igf_aw_fund_cat fcat,
281: igf_aw_fund_mast fmast,
282: igf_ap_fa_base_rec farec,
283: igs_pe_alt_pers_id_v pit,
284: igs_pe_person_id_typ pit_2
285: WHERE awd.fund_id = fmast.fund_id
286: AND awd.base_id = cv_base_id
287: AND awd.base_id = farec.base_id
288: AND fcat.fund_code = fmast.fund_code

Line 312: FROM igs_pe_person_base_v

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:
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

Line 1285: l_person_id igs_pe_person.person_id%TYPE;

1281: sum_rec c_sum%ROWTYPE;
1282: l_award c_award%ROWTYPE;
1283: auth_rec c_auth%ROWTYPE;
1284: l_fund_id igf_aw_fund_mast.fund_id%TYPE;
1285: l_person_id igs_pe_person.person_id%TYPE;
1286: ln_total_paid_amount igf_se_payment.paid_amount%TYPE;
1287: l_notification_date igf_se_auth.notification_date%TYPE;
1288:
1289: -----------local function begin

Line 1573: FROM igs_pe_person_base_v fa

1569: --veramach July 2004 FA 151 HR integration - process raises a business event instead of initiating workflow
1570: -------------------------------------------------------------------------------------
1571: CURSOR c_person IS
1572: SELECT fa.person_number, fa.full_name
1573: FROM igs_pe_person_base_v fa
1574: WHERE fa.person_id = p_person_id ;
1575:
1576: CURSOR c_fund IS
1577: SELECT fund_code,threshold_perct,threshold_value