APPS.IGF_SE_GEN_001 dependencies on IGF_AW_AWARD_ALL

Line 330: cp_award_id igf_aw_award_all.award_id%TYPE

326: WHERE party_id = cv_person_id
327: AND SYSDATE BETWEEN EFFECTIVE_START_DATE AND NVL(EFFECTIVE_END_DATE, SYSDATE);
328:
329: CURSOR c_accept_amnt(
330: cp_award_id igf_aw_award_all.award_id%TYPE
331: ) IS
332: SELECT NVL(awd.accepted_amt,0) accepted_amt
333: FROM igf_aw_award awd
334: WHERE awd.award_id = cp_award_id;

Line 828: FROM igf_aw_award_all awd,

824: fa.person_id person_id,
825: awd.base_id,
826: hz.party_number person_number,
827: fmast.fund_code
828: FROM igf_aw_award_all awd,
829: igf_aw_fund_mast_all fmast,
830: igf_aw_fund_cat_all fcat,
831: igf_ap_fa_base_rec_all fa,
832: hz_parties hz

Line 846: cp_award_id igf_aw_award_all.award_id%TYPE

842: AND fa.person_id = hz.party_id;
843:
844: -- Check if authorization already exists
845: CURSOR c_auth_exists(
846: cp_award_id igf_aw_award_all.award_id%TYPE
847: ) IS
848: SELECT 'x'
849: FROM igf_se_auth
850: WHERE award_id = cp_award_id

Line 856: cp_award_id igf_aw_award_all.award_id%TYPE

852: l_auth_exists c_auth_exists%ROWTYPE;
853:
854: -- Check if accepted amounts are equal at the award and authorization levels
855: CURSOR c_amounts(
856: cp_award_id igf_aw_award_all.award_id%TYPE
857: ) IS
858: SELECT awd.accepted_amt accepted_amt,
859: auth.accepted_amnt accepted_amnt
860: FROM igf_aw_award_all awd,

Line 860: FROM igf_aw_award_all awd,

856: cp_award_id igf_aw_award_all.award_id%TYPE
857: ) IS
858: SELECT awd.accepted_amt accepted_amt,
859: auth.accepted_amnt accepted_amnt
860: FROM igf_aw_award_all awd,
861: igf_se_auth auth
862: WHERE awd.award_id = auth.award_id
863: AND awd.award_id = cp_award_id
864: AND auth.flag = 'A';

Line 1260: FROM igf_aw_award_all awd,

1256: cv_auth_id igf_se_auth.auth_id%TYPE
1257: ) IS
1258: SELECT NVL(accepted_amt,NVL(offered_amt,0)) accepted_amt,
1259: base_id
1260: FROM igf_aw_award_all awd,
1261: igf_se_auth se
1262: WHERE se.award_id = awd.award_id
1263: AND se.auth_id = cv_auth_id
1264: AND se.flag = 'A';

Line 1558: p_award_id IN igf_aw_award_all.award_id%TYPE

1554: PROCEDURE se_notify(p_person_id IN hz_parties.party_id%TYPE,
1555: p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,
1556: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
1557: p_ld_seq_no IN igs_ca_inst.sequence_number%TYPE,
1558: p_award_id IN igf_aw_award_all.award_id%TYPE
1559: ) IS
1560: ------------------------------------------------------------------------------------
1561: --Created by : ssawhney ( Oracle IDC)
1562: --Date created: 2nd jan