APPS.IGS_PR_CP_GPA dependencies on IGS_PR_INST_STA_REF

Line 210: FROM igs_pr_inst_sta_ref INSTR

206:
207: CURSOR c_inst_setup
208: IS
209: SELECT INSTR.include_or_exclude
210: FROM igs_pr_inst_sta_ref INSTR
211: WHERE INSTR.stat_type = p_stat_type;
212:
213: CURSOR c_inst_included
214: IS

Line 225: FROM igs_pr_inst_sta_ref instr1

221: AND refcd.reference_cd_type = rct.reference_cd_type
222: AND rct.s_reference_cd_type = 'STATS'
223: AND urc.deleted_date IS NULL
224: AND EXISTS ( SELECT 'X'
225: FROM igs_pr_inst_sta_ref instr1
226: WHERE instr1.stat_type = p_stat_type
227: AND instr1.unit_ref_cd = refcd.reference_cd
228: AND instr1.include_or_exclude = 'INCLUDE');
229:

Line 242: FROM igs_pr_inst_sta_ref instr1

238: AND refcd.reference_cd_type = rct.reference_cd_type
239: AND rct.s_reference_cd_type = 'STATS'
240: AND urc.deleted_date IS NULL
241: AND EXISTS ( SELECT 'X'
242: FROM igs_pr_inst_sta_ref instr1
243: WHERE instr1.stat_type = p_stat_type
244: AND instr1.unit_ref_cd = refcd.reference_cd
245: AND instr1.include_or_exclude = 'EXCLUDE');
246:

Line 661: FROM igs_pr_inst_sta_ref INSTR

657: AND ostr1.include_or_exclude = 'EXCLUDE');
658:
659: CURSOR c_inst_setup IS
660: SELECT INSTR.include_or_exclude
661: FROM igs_pr_inst_sta_ref INSTR
662: WHERE INSTR.stat_type = p_stat_type;
663:
664: CURSOR c_inst_included IS
665: SELECT 'X'

Line 672: FROM igs_pr_inst_sta_ref instr1

668: AND urc.version_number = p_unit_version_number
669: AND urc.reference_cd_type = rct.reference_cd_type
670: AND rct.s_reference_cd_type = 'STATS'
671: AND EXISTS( SELECT 'X'
672: FROM igs_pr_inst_sta_ref instr1
673: WHERE instr1.stat_type = p_stat_type
674: AND instr1.unit_ref_cd = urc.reference_cd
675: AND instr1.include_or_exclude = 'INCLUDE');
676:

Line 685: FROM igs_pr_inst_sta_ref instr1

681: AND urc.version_number = p_unit_version_number
682: AND urc.reference_cd_type = rct.reference_cd_type
683: AND rct.s_reference_cd_type = 'STATS'
684: AND EXISTS( SELECT 'X'
685: FROM igs_pr_inst_sta_ref instr1
686: WHERE instr1.stat_type = p_stat_type
687: AND instr1.unit_ref_cd = urc.reference_cd
688: AND instr1.include_or_exclude = 'EXCLUDE');
689:

Line 2637: FROM igs_pr_inst_sta_ref INSTR

2633: AND ostr1.include_or_exclude = 'EXCLUDE');
2634:
2635: CURSOR c_inst_setup IS
2636: SELECT INSTR.include_or_exclude
2637: FROM igs_pr_inst_sta_ref INSTR
2638: WHERE INSTR.stat_type = p_stat_type;
2639:
2640: CURSOR c_inst_included IS
2641: SELECT 'X'

Line 2650: FROM igs_pr_inst_sta_ref instr1

2646: AND urc.reference_cd_type = rct.reference_cd_type
2647: AND urc.deleted_date IS NULL
2648: AND rct.s_reference_cd_type = 'STATS'
2649: AND EXISTS( SELECT 'X'
2650: FROM igs_pr_inst_sta_ref instr1
2651: WHERE instr1.stat_type = p_stat_type
2652: AND instr1.unit_ref_cd = urc.reference_cd
2653: AND instr1.include_or_exclude = 'INCLUDE');
2654:

Line 2666: FROM igs_pr_inst_sta_ref instr1

2662: AND src.reference_cd_type = rct.reference_cd_type
2663: AND src.deleted_date IS NULL
2664: AND rct.s_reference_cd_type = 'STATS'
2665: AND EXISTS( SELECT 'X'
2666: FROM igs_pr_inst_sta_ref instr1
2667: WHERE instr1.stat_type = p_stat_type
2668: AND instr1.unit_ref_cd = src.reference_cd
2669: AND instr1.include_or_exclude = 'EXCLUDE');
2670: