APPS.IGF_SL_DL_GEN_XML dependencies on IGF_AP_FA_BASE_REC_ALL

Line 964: FUNCTION per_in_fa ( p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,

960: ROLLBACK TO IGFSL25B_PROCESS_LOAN;
961: END IF;
962: END process_loan;
963:
964: FUNCTION per_in_fa ( p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
965: p_ci_cal_type VARCHAR2,
966: p_ci_sequence_number NUMBER,
967: p_base_id OUT NOCOPY NUMBER
968: )

Line 971: CURSOR cur_get_pers_num ( p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)

967: p_base_id OUT NOCOPY NUMBER
968: )
969: RETURN VARCHAR2
970: IS
971: CURSOR cur_get_pers_num ( p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
972: IS
973: SELECT person_number
974: FROM igs_pe_person_base_v
975: WHERE

Line 982: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)

978: get_pers_num_rec cur_get_pers_num%ROWTYPE;
979:
980: CURSOR cur_get_base (p_cal_type igs_ca_inst_all.cal_type%TYPE,
981: p_sequence_number igs_ca_inst_all.sequence_number%TYPE,
982: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
983: IS
984: SELECT
985: base_id
986: FROM

Line 987: igf_ap_fa_base_rec_all

983: IS
984: SELECT
985: base_id
986: FROM
987: igf_ap_fa_base_rec_all
988: WHERE
989: person_id = p_person_id AND
990: ci_cal_type = p_cal_type AND
991: ci_sequence_number = p_sequence_number;

Line 1186: FROM igf_ap_fa_base_rec_all

1182: p_cal_type VARCHAR2,
1183: p_seq_number NUMBER)
1184: IS
1185: SELECT base_id
1186: FROM igf_ap_fa_base_rec_all
1187: WHERE base_id = p_base_id AND
1188: ci_cal_type = p_cal_type AND
1189: ci_sequence_number = p_seq_number;
1190: