[Home] [Help]
1896: ) AS
1897: -- mnade 5/24/2005 using the base query from IGFAW016.pld for the same C_PROCESS_STATUS
1898: CURSOR c_process_status (cp_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
1899: cp_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1900: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
1901: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
1902: IS
1903: SELECT TO_CHAR(MIN(status_order)) min_award_status, MAX(notification_status_date) notification_status_date
1904: FROM
1927: WHERE
1928: DISB.AWARD_ID = AWD.AWARD_ID
1929: MINUS
1930: SELECT LD_CAL_TYPE, LD_SEQUENCE_NUMBER
1931: FROM IGF_AW_AWD_PRD_TERM APT
1932: WHERE APT.CI_CAL_TYPE = cp_ci_cal_type AND
1933: APT.CI_SEQUENCE_NUMBER = cp_ci_sequence_number AND
1934: APT.award_prd_cd = NVL(cp_award_prd_code, award_prd_cd))) temp;
1935: l_process_status c_process_status%ROWTYPE;
1990: ) AS
1991: -- mnade 5/24/2005 using the base query from IGFAW016.pld for the same C_PROCESS_STATUS
1992: CURSOR c_awards (cp_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
1993: cp_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1994: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
1995: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
1996: IS
1997: SELECT
1998: awd.award_id
2010: WHERE
2011: DISB.AWARD_ID = AWD.AWARD_ID
2012: MINUS
2013: SELECT LD_CAL_TYPE, LD_SEQUENCE_NUMBER
2014: FROM IGF_AW_AWD_PRD_TERM APT
2015: WHERE APT.CI_CAL_TYPE = cp_ci_cal_type AND
2016: APT.CI_SEQUENCE_NUMBER = cp_ci_sequence_number AND
2017: APT.award_prd_cd = NVL(cp_award_prd_code, award_prd_cd));
2018: award_rec c_awards%ROWTYPE;
2214: COUNT(awd.award_id) lock_count
2215: FROM
2216: igf_aw_award_all awd,
2217: igf_aw_awd_disb_all disb,
2218: igf_aw_awd_prd_term apt
2219: WHERE
2220: disb.award_id = awd.award_id
2221: AND disb.ld_cal_type = apt.ld_cal_type
2222: AND disb.ld_sequence_number = apt.ld_sequence_number