APPS.IGF_SL_GEN dependencies on IGF_AP_FA_ANT_DATA

Line 1979: || table (igf_ap_fa_ant_data) directly

1975: || museshad 15-Jul-2005 Build FA 140.
1976: || Modified the logic for getting the anticipated
1977: || Org Unit. Anticipated Org Unit is derived by -
1978: || 1) Get anticipated Org Unit from anticipated
1979: || table (igf_ap_fa_ant_data) directly
1980: || 2) If step 1 does not give a valid Org Unit,
1981: || then get the anticipated key program and
1982: || get the Org Unit corresponding to this
1983: || key program.

Line 1993: FROM igf_ap_fa_ant_data fant

1989: -- data is available for the current term
1990: CURSOR c_ant_data_curr_term(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
1991: IS
1992: SELECT fant.*
1993: FROM igf_ap_fa_ant_data fant
1994: WHERE fant.base_id = cp_base_id;
1995:
1996: lv_ant_data_curr_term_rec c_ant_data_curr_term%ROWTYPE;
1997:

Line 2006: igf_ap_fa_ant_data ant_data

2002: IS
2003: SELECT ant_data.*
2004: FROM
2005: igf_aw_awd_ld_cal_v awd_year_terms,
2006: igf_ap_fa_ant_data ant_data
2007: WHERE
2008: ant_data.ld_cal_type = awd_year_terms.ld_cal_type AND
2009: ant_data.ld_sequence_number = awd_year_terms.ld_sequence_number AND
2010: ant_data.base_id = cp_base_id AND

Line 2025: igf_ap_fa_ant_data ant_data,

2021: IS
2022: SELECT prog.*
2023: FROM
2024: igf_aw_awd_ld_cal_v awd_year_terms,
2025: igf_ap_fa_ant_data ant_data,
2026: igs_ps_ver_all prog
2027: WHERE
2028: ant_data.ld_cal_type = awd_year_terms.ld_cal_type AND
2029: ant_data.ld_sequence_number = awd_year_terms.ld_sequence_number AND

Line 2056: lv_ant_org_unit_cd igf_ap_fa_ant_data.org_unit_cd%TYPE := NULL;

2052:
2053: lv_start_dt DATE;
2054: lv_end_dt DATE;
2055: l_person_id NUMBER;
2056: lv_ant_org_unit_cd igf_ap_fa_ant_data.org_unit_cd%TYPE := NULL;
2057:
2058: BEGIN
2059: -- initialize
2060: x_return_status := 'S';