eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AW_GEN_002 dependencies on IGF_AP_ISIR_MATCHED

Line 78: FROM igf_ap_isir_matched isir,

74: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
75: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE)
76: IS
77: SELECT COUNT (isir.base_id)
78: FROM igf_ap_isir_matched isir,
79: igf_ap_fa_base_rec fa
80: WHERE isir.dependency_status=cp_depend_stat
81: AND NVL(isir.auto_zero_efc,'N') <> 'Y'
82: AND isir.active_isir ='Y'

Line 113: FROM igf_ap_isir_matched isir,

109: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE,
110: cp_efc VARCHAR2 )
111: IS
112: SELECT COUNT (isir.base_id)
113: FROM igf_ap_isir_matched isir,
114: igf_ap_fa_base_rec fa
115: WHERE isir.dependency_status=cp_depend_stat
116: AND NVL(isir.auto_zero_efc,'N') <> 'Y'
117: AND isir.active_isir ='Y'

Line 151: FROM igf_ap_isir_matched isir,

147: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE,
148: cp_efc VARCHAR2)
149: IS
150: SELECT COUNT (isir.base_id)
151: FROM igf_ap_isir_matched isir,
152: igf_ap_fa_base_rec fa
153: WHERE isir.dependency_status=cp_depend_stat
154: AND isir.auto_zero_efc = 'Y'
155: AND isir.active_isir ='Y'

Line 189: FROM igf_ap_isir_matched isir,

185: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE,
186: cp_efc VARCHAR2)
187: IS
188: SELECT COUNT (isir.base_id)
189: FROM igf_ap_isir_matched isir,
190: igf_ap_fa_base_rec fa
191: WHERE isir.dependency_status=cp_depend_stat
192: AND isir.auto_zero_efc = 'Y'
193: AND isir.active_isir ='Y'

Line 402: FROM igf_ap_isir_matched isir,

398: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
399: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE )
400: IS
401: SELECT NVL(SUM(awd.paid_amt),0)
402: FROM igf_ap_isir_matched isir,
403: igf_aw_award_v awd,
404: igf_ap_fa_base_rec fa
405: WHERE awd.base_id =isir.base_id
406: AND fa.base_id =isir.base_id

Line 434: FROM igf_ap_isir_matched isir,

430: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
431: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE )
432: IS
433: SELECT NVL(SUM(awd.paid_amt),0)
434: FROM igf_ap_isir_matched isir,
435: igf_aw_award_v awd,
436: igf_ap_fa_base_rec fa
437: WHERE awd.base_id =isir.base_id
438: AND fa.base_id =isir.base_id

Line 466: FROM igf_ap_isir_matched isir,

462: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
463: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE )
464: IS
465: SELECT NVL(SUM(awd.paid_amt),0)
466: FROM igf_ap_isir_matched isir,
467: igf_aw_award_v awd,
468: igf_ap_fa_base_rec fa
469: WHERE awd.base_id =isir.base_id
470: AND fa.base_id =isir.base_id

Line 498: FROM igf_ap_isir_matched isir,

494: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
495: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE )
496: IS
497: SELECT NVL(SUM(awd.paid_amt),0)
498: FROM igf_ap_isir_matched isir,
499: igf_aw_award_v awd,
500: igf_ap_fa_base_rec fa
501: WHERE awd.base_id =isir.base_id
502: AND fa.base_id =isir.base_id

Line 723: FROM igf_ap_isir_matched isir,

719: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
720: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE )
721: IS
722: SELECT COUNT (isir.base_id )
723: FROM igf_ap_isir_matched isir,
724: igf_aw_award_v awd,
725: igf_ap_fa_base_rec fa
726: WHERE isir.dependency_status =cp_depend_stat
727: AND fa.base_id =isir.base_id

Line 760: FROM igf_ap_isir_matched isir,

756: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
757: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE )
758: IS
759: SELECT COUNT (isir.base_id )
760: FROM igf_ap_isir_matched isir,
761: igf_aw_award_v awd,
762: igf_ap_fa_base_rec fa
763: WHERE isir.dependency_status =cp_depend_stat
764: AND awd.base_id= isir.base_id

Line 795: FROM igf_ap_isir_matched isir,

791: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
792: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE )
793: IS
794: SELECT COUNT (isir.base_id )
795: FROM igf_ap_isir_matched isir,
796: igf_aw_award_v awd,
797: igf_ap_fa_base_rec fa
798: WHERE isir.dependency_status IN ('I','D')
799: AND awd.base_id = isir.base_id

Line 829: FROM igf_ap_isir_matched isir,

825: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
826: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE )
827: IS
828: SELECT COUNT ( isir.base_id )
829: FROM igf_ap_isir_matched isir,
830: igf_aw_award_v awd,
831: igf_ap_fa_base_rec fa
832: WHERE isir.dependency_status IN ('I','D')
833: AND awd.base_id = isir.base_id

Line 862: FROM igf_ap_isir_matched isir,

858: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
859: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE )
860: IS
861: SELECT COUNT ( DISTINCT (isir.base_id ) )
862: FROM igf_ap_isir_matched isir,
863: igf_aw_award_v awd,
864: igf_ap_fa_base_rec fa
865: WHERE isir.dependency_status = cp_depend_stat
866: AND awd.base_id = isir.base_id

Line 898: FROM igf_ap_isir_matched isir,

894: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
895: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
896: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE ) IS
897: SELECT COUNT (DISTINCT (isir.base_id ) )
898: FROM igf_ap_isir_matched isir,
899: igf_aw_award_v awd,
900: igf_ap_fa_base_rec fa
901: WHERE isir.dependency_status =cp_depend_stat
902: AND awd.base_id = isir.base_id

Line 934: FROM igf_ap_isir_matched isir,

930: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
931: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE )
932: IS
933: SELECT COUNT (DISTINCT(isir.base_id ))
934: FROM igf_ap_isir_matched isir,
935: igf_aw_award_v awd,
936: igf_ap_fa_base_rec fa
937: WHERE isir.dependency_status IN ('I','D')
938: AND awd.base_id = isir.base_id

Line 969: FROM igf_ap_isir_matched isir,

965: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
966: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE )
967: IS
968: SELECT COUNT (DISTINCT(isir.base_id ))
969: FROM igf_ap_isir_matched isir,
970: igf_aw_award_v awd,
971: igf_ap_fa_base_rec fa
972: WHERE isir.dependency_status IN ('I','D')
973: AND awd.fed_fund_code IN ('FWS','FSEOG','PRK')

Line 1255: p_isir_id igf_ap_isir_matched_all.isir_id%TYPE,

1251:
1252:
1253: --Procedure for Comparing ISIR Applications
1254: PROCEDURE compare_isirs(
1255: p_isir_id igf_ap_isir_matched_all.isir_id%TYPE,
1256: p_corr_isir_id igf_ap_isir_matched_all.isir_id%TYPE,
1257: p_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1258: p_seq_num igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
1259: p_corr_status igf_ap_isir_corr.correction_status%TYPE

Line 1256: p_corr_isir_id igf_ap_isir_matched_all.isir_id%TYPE,

1252:
1253: --Procedure for Comparing ISIR Applications
1254: PROCEDURE compare_isirs(
1255: p_isir_id igf_ap_isir_matched_all.isir_id%TYPE,
1256: p_corr_isir_id igf_ap_isir_matched_all.isir_id%TYPE,
1257: p_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1258: p_seq_num igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
1259: p_corr_status igf_ap_isir_corr.correction_status%TYPE
1260: ) AS

Line 1277: CURSOR c_get_org_isir( cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE ) IS

1273: brajendr 28-Nov-2002 Modified the parameters. Removed the Row Type and changed to ISIR ID
1274: ***************************************************************/
1275:
1276: -- Get ISIR details
1277: CURSOR c_get_org_isir( cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE ) IS
1278: SELECT *
1279: FROM igf_ap_isir_matched
1280: WHERE isir_id = cp_isir_id;
1281:

Line 1279: FROM igf_ap_isir_matched

1275:
1276: -- Get ISIR details
1277: CURSOR c_get_org_isir( cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE ) IS
1278: SELECT *
1279: FROM igf_ap_isir_matched
1280: WHERE isir_id = cp_isir_id;
1281:
1282: p_isir_corr c_get_org_isir%ROWTYPE;
1283: p_isir_pay c_get_org_isir%ROWTYPE;