APPS.IGS_HE_EXTRACT_PKG dependencies on IGS_HE_EX_RN_DAT_LN

Line 984: LINE - Igs_He_Ex_Rn_Dat_Ln

980: p_extract_run_id IN The Extract Run Id
981: p_line_number IN Line Number
982: p_table_name IN Table Name
983: Values : INTERIM - Igs_He_Ext_Run_Interim
984: LINE - Igs_He_Ex_Rn_Dat_Ln
985: FIELD - Igs_He_Ex_Rn_Dat_Fd
986: ERROR - Igs_He_Ext_Run_Excp
987: WHO: AYEDUBAT
988: WHAT: Removed the 'PROCEDURE delete_rows' as all the call to this procedure are placed

Line 1886: igs_he_ex_rn_dat_ln b,

1882: CURSOR c_get_mod (p_stdnt_extract_run_id NUMBER)
1883: IS
1884: SELECT DISTINCT Nvl(a.override_value, a.value) module_id
1885: FROM igs_he_ex_rn_dat_fd a,
1886: igs_he_ex_rn_dat_ln b,
1887: igs_he_st_prog c
1888: WHERE a.extract_run_id = b.extract_run_id
1889: AND b.extract_run_id = p_stdnt_extract_run_id
1890: AND b.course_cd = c.course_cd

Line 2211: FROM igs_he_ex_rn_dat_ln

2207: crv_version_number,
2208: unit_cd,
2209: uv_version_number,
2210: recalculate_flag
2211: FROM igs_he_ex_rn_dat_ln
2212: WHERE extract_run_id = p_extract_run_id
2213: AND manually_inserted = 'N'
2214: AND (recalculate_flag = 'Y'
2215: OR person_id IN (SELECT only from igs_he_ext_run_prms WHERE param_type = 'RECALC-PERSON' AND extract_run_id = p_extract_run_id)

Line 2534: -- Delete from igs_he_ex_rn_dat_ln

2530:
2531: -- Delete from igs_he_ex_rn_dat_fd
2532: DELETE FROM igs_he_ex_rn_dat_fd WHERE extract_run_id = p_extract_run_id;
2533:
2534: -- Delete from igs_he_ex_rn_dat_ln
2535: DELETE FROM igs_he_ex_rn_dat_ln WHERE extract_run_id = p_extract_run_id;
2536:
2537: -- Delete from igs_he_ext_run_excp
2538: DELETE FROM igs_he_ext_run_excp WHERE extract_run_id = p_extract_run_id;

Line 2535: DELETE FROM igs_he_ex_rn_dat_ln WHERE extract_run_id = p_extract_run_id;

2531: -- Delete from igs_he_ex_rn_dat_fd
2532: DELETE FROM igs_he_ex_rn_dat_fd WHERE extract_run_id = p_extract_run_id;
2533:
2534: -- Delete from igs_he_ex_rn_dat_ln
2535: DELETE FROM igs_he_ex_rn_dat_ln WHERE extract_run_id = p_extract_run_id;
2536:
2537: -- Delete from igs_he_ext_run_excp
2538: DELETE FROM igs_he_ext_run_excp WHERE extract_run_id = p_extract_run_id;
2539: