APPS.IGS_UC_EXPORT_TO_OSS dependencies on IGS_PE_SRC_TYPES_ALL

Line 24: p_source_type_id igs_pe_src_types_all.source_type_id%TYPE,

20:
21: PROCEDURE populate_imp_int (
22: p_app_no IN igs_uc_applicants.app_no%TYPE,
23: p_choice_no IN igs_uc_app_choices.choice_no%TYPE ,
24: p_source_type_id igs_pe_src_types_all.source_type_id%TYPE,
25: p_batch_id NUMBER,
26: p_orgid NUMBER) AS
27: /******************************************************************
28: Created By : smaddali

Line 681: p_source_type_id igs_pe_src_types_all.source_type_id%TYPE,

677: END populate_imp_int;
678:
679:
680: PROCEDURE import_process(
681: p_source_type_id igs_pe_src_types_all.source_type_id%TYPE,
682: p_batch_id NUMBER,
683: p_orgid NUMBER
684: ) IS
685:

Line 2253: FROM igs_pe_src_types_all

2249:
2250: -- Get the Source type ID of UCAS for admission import process
2251: CURSOR c_src_type_id IS
2252: SELECT source_type_id
2253: FROM igs_pe_src_types_all
2254: WHERE source_type LIKE 'UCAS APPL';
2255: c_src_type_id_rec c_src_type_id%ROWTYPE;
2256:
2257: -- Get the admission application instance interface record corresponding to the