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_FA_BASE_REC

Line 79: igf_ap_fa_base_rec fa

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'
83: AND isir.citizenship_status='1'

Line 89: FROM igf_ap_fa_base_rec_all base,igs_ps_ver_all pv,igs_en_stdnt_ps_att att

85: AND fa.ci_sequence_number =cp_ci_sequence_number
86: AND fa.base_id=isir.base_id
87: AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
88: AND EXISTS ( SELECT base.base_id
89: FROM igf_ap_fa_base_rec_all base,igs_ps_ver_all pv,igs_en_stdnt_ps_att att
90: WHERE base.base_id = isir.base_id
91: AND base.person_id = att.person_id
92: AND att.key_program = 'Y'
93: AND att.course_cd = pv.course_cd

Line 114: igf_ap_fa_base_rec fa

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'
118: AND isir.citizenship_status='1'

Line 125: FROM igf_ap_fa_base_rec_all base,igs_ps_ver_all pv,igs_en_stdnt_ps_att att

121: AND fa.base_id=isir.base_id
122: AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
123: AND EXISTS
124: (SELECT base.base_id
125: FROM igf_ap_fa_base_rec_all base,igs_ps_ver_all pv,igs_en_stdnt_ps_att att
126: WHERE base.base_id = isir.base_id
127: AND base.person_id = att.person_id
128: AND att.key_program = 'Y'
129: AND att.course_cd = pv.course_cd

Line 152: igf_ap_fa_base_rec fa

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'
156: AND isir.citizenship_status='1'

Line 164: FROM igf_ap_fa_base_rec_all base,

160: AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
161: AND EXISTS
162: (
163: SELECT base.base_id
164: FROM igf_ap_fa_base_rec_all base,
165: igs_ps_ver_all pv,
166: igs_en_stdnt_ps_att att
167: WHERE base.base_id = isir.base_id
168: AND base.person_id = att.person_id

Line 190: igf_ap_fa_base_rec fa

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'
194: AND isir.citizenship_status='1'

Line 202: FROM igf_ap_fa_base_rec_all base,igs_ps_ver_all pv,igs_en_stdnt_ps_att att

198: AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
199: AND EXISTS
200: (
201: SELECT base.base_id
202: FROM igf_ap_fa_base_rec_all base,igs_ps_ver_all pv,igs_en_stdnt_ps_att att
203: WHERE base.base_id = isir.base_id
204: AND base.person_id = att.person_id
205: AND att.key_program = 'Y'
206: AND att.course_cd = pv.course_cd

Line 404: igf_ap_fa_base_rec fa

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
407: AND isir.dependency_status =p_depend_stat
408: AND awd.fed_fund_code =cp_fund_type

Line 436: igf_ap_fa_base_rec fa

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
439: AND isir.dependency_status =p_depend_stat
440: AND awd.fed_fund_code =cp_fund_type

Line 468: igf_ap_fa_base_rec fa

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
471: AND isir.dependency_status IN ('I','D')
472: AND awd.fed_fund_code =cp_fund_type

Line 500: igf_ap_fa_base_rec fa

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
503: AND isir.dependency_status IN ('I','D')
504: AND awd.ci_cal_type =cp_ci_cal_type

Line 725: igf_ap_fa_base_rec fa

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
728: AND awd.base_id = isir.base_id
729: AND NVL(isir.auto_zero_efc,'N') <> 'Y'

Line 762: igf_ap_fa_base_rec fa

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
765: AND fa.base_id = isir.base_id
766: AND awd.fed_fund_code = cp_fund_type

Line 797: igf_ap_fa_base_rec fa

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
800: AND fa.base_id =isir.base_id
801: AND NVL(isir.auto_zero_efc,'N') <> 'Y'

Line 831: igf_ap_fa_base_rec fa

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
834: AND fa.base_id =isir.base_id
835: AND awd.fed_fund_code = cp_fund_type

Line 864: igf_ap_fa_base_rec fa

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
867: AND fa.base_id =isir.base_id
868: AND awd.fed_fund_code IN ('FWS','FSEOG','PRK')

Line 900: igf_ap_fa_base_rec fa

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
903: AND fa.base_id =isir.base_id
904: AND awd.fed_fund_code IN ('FWS','FSEOG','PRK')

Line 936: igf_ap_fa_base_rec fa

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
939: AND fa.base_id = isir.base_id
940: AND awd.fed_fund_code IN ('FWS','FSEOG','PRK')

Line 971: igf_ap_fa_base_rec fa

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')
974: AND awd.ci_cal_type =cp_ci_cal_type
975: AND awd.ci_sequence_number =cp_ci_sequence_number

Line 1257: p_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

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
1261:

Line 1258: p_seq_num igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,

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
1261:
1262: /***************************************************************

Line 1286: cp_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

1282: p_isir_corr c_get_org_isir%ROWTYPE;
1283: p_isir_pay c_get_org_isir%ROWTYPE;
1284: -- Get system award details
1285: CURSOR c_sys_awd_yr(
1286: cp_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1287: cp_seq_num igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
1288: ) IS
1289: SELECT sys_award_year
1290: FROM igf_ap_batch_aw_map

Line 1287: cp_seq_num igf_ap_fa_base_rec_all.ci_sequence_number%TYPE

1283: p_isir_pay c_get_org_isir%ROWTYPE;
1284: -- Get system award details
1285: CURSOR c_sys_awd_yr(
1286: cp_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1287: cp_seq_num igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
1288: ) IS
1289: SELECT sys_award_year
1290: FROM igf_ap_batch_aw_map
1291: WHERE ci_cal_type = cp_cal_type

Line 1589: p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,

1585:
1586:
1587: PROCEDURE get_resource_need
1588: (
1589: p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
1590: p_resource_f OUT NOCOPY NUMBER,
1591: p_resource_i OUT NOCOPY NUMBER,
1592: p_unmet_need_f OUT NOCOPY NUMBER,
1593: p_unmet_need_i OUT NOCOPY NUMBER,

Line 1667: igf_ap_fa_base_rec_all fa,

1663: FROM igf_aw_awd_disb_all disb,
1664: igf_aw_award_all awd,
1665: igf_aw_fund_mast_all fm,
1666: igf_aw_fund_cat_all fcat,
1667: igf_ap_fa_base_rec_all fa,
1668: igf_aw_awd_prd_term aprd,
1669: (SELECT base_id,
1670: ld_cal_type,
1671: ld_sequence_number