APPS.IGF_AW_GEN_004 dependencies on IGF_AW_AWD_PRD_TERM

Line 90: cp_award_prd_cd igf_aw_awd_prd_term.award_prd_cd%TYPE

86: cp_fa_sequence_number igs_ca_inst_all.sequence_number%TYPE,
87: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
88: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE,
89: cp_fund_id igf_aw_fund_mast.fund_id%TYPE,
90: cp_award_prd_cd igf_aw_awd_prd_term.award_prd_cd%TYPE
91: ) IS
92: SELECT
93: cai.start_dt,
94: cai.alternate_code,

Line 127: FROM igf_aw_awd_prd_term apt

123: WHERE
124: disb.award_id = awd.award_id
125: MINUS
126: SELECT ld_cal_type, ld_sequence_number
127: FROM igf_aw_awd_prd_term apt
128: WHERE apt.ci_cal_type = cp_fa_cal_type AND
129: apt.ci_sequence_number = cp_fa_sequence_number AND
130: apt.award_prd_cd = NVL(cp_award_prd_cd, award_prd_cd))
131: GROUP BY

Line 145: cp_award_prd_cd igf_aw_awd_prd_term.award_prd_cd%TYPE

141: (
142: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
143: cp_fa_cal_type igs_ca_inst_all.cal_type%TYPE,
144: cp_fa_sequence_number igs_ca_inst_all.sequence_number%TYPE,
145: cp_award_prd_cd igf_aw_awd_prd_term.award_prd_cd%TYPE
146: ) IS
147: SELECT
148: DISTINCT
149: cai.start_dt,

Line 176: FROM igf_aw_awd_prd_term apt

172: WHERE
173: disb.award_id = awd.award_id
174: MINUS
175: SELECT ld_cal_type, ld_sequence_number
176: FROM igf_aw_awd_prd_term apt
177: WHERE apt.ci_cal_type = cp_fa_cal_type AND
178: apt.ci_sequence_number = cp_fa_sequence_number AND
179: apt.award_prd_cd = NVL(cp_award_prd_cd, award_prd_cd))
180: order by cai.start_dt;

Line 321: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE

317: END build_sql_stmt;
318:
319: FUNCTION efc_i(
320: l_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
321: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE
322: ) RETURN NUMBER AS
323: ------------------------------------------------------------------
324: --Created by : veramach, Oracle India
325: --Date created: 06-OCT-2003

Line 379: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL

375: -- ADDED BY GMURALID FOR BUG 2737925 ON 8-JAN-2003
376:
377: FUNCTION efc_f(
378: l_base_id IN NUMBER,
379: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
380: )
381: RETURN NUMBER
382: IS
383: /*************************************************************

Line 582: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL

578: -- ADDED BY GMURALID FOR BUG 2737925 ON 8-JAN-2003
579:
580: FUNCTION unmetneed_f(
581: l_base_id IN NUMBER,
582: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
583: ) RETURN NUMBER IS
584: /*************************************************************
585: Created By : Gautam S.M
586: Date Created on : 0*-JAN-2003

Line 624: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL

620: END unmetneed_f;
621:
622: FUNCTION unmetneed_i(
623: l_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
624: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
625: ) RETURN NUMBER AS
626: ------------------------------------------------------------------
627: --Created by : veramach, Oracle India
628: --Date created: 06-SEP-2003

Line 664: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE

660:
661:
662: FUNCTION need_f(
663: l_base_id IN NUMBER,
664: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE
665: ) RETURN NUMBER IS
666: /*************************************************************
667: Created By : Gautam S.M
668: Date Created on : 08-JAN-2003

Line 698: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL

694:
695:
696: FUNCTION need_i(
697: l_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
698: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL
699: ) RETURN NUMBER AS
700: ------------------------------------------------------------------
701: --Created by : veramach, Oracle India
702: --Date created: 06-SEP-2003

Line 1176: FROM igf_aw_awd_prd_term apt

1172: WHERE
1173: disb.award_id = awd.award_id
1174: MINUS
1175: SELECT ld_cal_type, ld_sequence_number
1176: FROM igf_aw_awd_prd_term apt
1177: WHERE apt.ci_cal_type = RTRIM (SUBSTR (p_param1, 1, 10))
1178: AND apt.ci_sequence_number = TO_NUMBER (RTRIM (SUBSTR (p_param1, 11)))
1179: AND apt.award_prd_cd = NVL(p_param2, award_prd_cd))
1180: UNION

Line 1441: FROM igf_aw_awd_prd_term apt

1437: WHERE
1438: disb.award_id = awd.award_id
1439: MINUS
1440: SELECT ld_cal_type, ld_sequence_number
1441: FROM igf_aw_awd_prd_term apt
1442: WHERE apt.ci_cal_type = LTRIM(RTRIM(SUBSTR(p_parameter_1, 1, 10))) AND
1443: apt.ci_sequence_number = TO_NUMBER(LTRIM(RTRIM(SUBSTR(p_parameter_1, 11)))) AND
1444: apt.award_prd_cd = NVL(p_parameter_2, award_prd_cd));
1445: END IF; -- END Select Type - S-Person/G-Group/A-Auto select