APPS.IGS_PR_CP_GPA dependencies on IGS_PR_ORG_STAT_REF

Line 167: FROM igs_pr_org_stat_ref ostr1

163:
164: CURSOR c_org_setup
165: IS
166: SELECT ostr1.include_or_exclude
167: FROM igs_pr_org_stat_ref ostr1
168: WHERE ostr1.stat_type = p_stat_type
169: AND ostr1.org_unit_cd = p_org_unit_cd;
170:
171: CURSOR c_org_included

Line 183: FROM igs_pr_org_stat_ref ostr1

179: AND refcd.reference_cd_type = rct.reference_cd_type
180: AND rct.s_reference_cd_type = 'STATS'
181: AND urc.deleted_date IS NULL
182: AND EXISTS ( SELECT 'X'
183: FROM igs_pr_org_stat_ref ostr1
184: WHERE ostr1.stat_type = p_stat_type
185: AND ostr1.org_unit_cd = p_org_unit_cd
186: AND ostr1.unit_ref_cd = refcd.reference_cd
187: AND ostr1.include_or_exclude = 'INCLUDE');

Line 201: FROM igs_pr_org_stat_ref ostr1

197: AND refcd.reference_cd_type = rct.reference_cd_type
198: AND rct.s_reference_cd_type = 'STATS'
199: AND urc.deleted_date IS NULL
200: AND EXISTS ( SELECT 'X'
201: FROM igs_pr_org_stat_ref ostr1
202: WHERE ostr1.stat_type = p_stat_type
203: AND ostr1.org_unit_cd = p_org_unit_cd
204: AND ostr1.unit_ref_cd = refcd.reference_cd
205: AND ostr1.include_or_exclude = 'EXCLUDE');

Line 627: FROM igs_pr_org_stat_ref ostr1

623: --------------------------------------------------------------------------
624:
625: CURSOR c_org_setup IS
626: SELECT ostr1.include_or_exclude
627: FROM igs_pr_org_stat_ref ostr1
628: WHERE ostr1.stat_type = p_stat_type AND ostr1.org_unit_cd =
629: p_org_unit_cd;
630:
631: CURSOR c_org_included IS

Line 639: FROM igs_pr_org_stat_ref ostr1

635: AND urc.version_number = p_unit_version_number
636: AND urc.reference_cd_type = rct.reference_cd_type
637: AND rct.s_reference_cd_type = 'STATS'
638: AND EXISTS( SELECT 'X'
639: FROM igs_pr_org_stat_ref ostr1
640: WHERE ostr1.stat_type = p_stat_type
641: AND ostr1.org_unit_cd = p_org_unit_cd
642: AND ostr1.unit_ref_cd = urc.reference_cd
643: AND ostr1.include_or_exclude = 'INCLUDE');

Line 653: FROM igs_pr_org_stat_ref ostr1

649: AND urc.version_number = p_unit_version_number
650: AND urc.reference_cd_type = rct.reference_cd_type
651: AND rct.s_reference_cd_type = 'STATS'
652: AND EXISTS( SELECT 'X'
653: FROM igs_pr_org_stat_ref ostr1
654: WHERE ostr1.stat_type = p_stat_type
655: AND ostr1.org_unit_cd = p_org_unit_cd
656: AND ostr1.unit_ref_cd = urc.reference_cd
657: AND ostr1.include_or_exclude = 'EXCLUDE');

Line 2597: FROM igs_pr_org_stat_ref ostr1

2593: RETURN VARCHAR2 AS
2594:
2595: CURSOR c_org_setup IS
2596: SELECT ostr1.include_or_exclude
2597: FROM igs_pr_org_stat_ref ostr1
2598: WHERE ostr1.stat_type = p_stat_type AND ostr1.org_unit_cd = p_org_unit_cd;
2599:
2600: CURSOR c_org_included IS
2601: SELECT 'X'

Line 2612: FROM igs_pr_org_stat_ref ostr1

2608: AND urc.deleted_date IS NULL
2609: AND rct.s_reference_cd_type = 'STATS'
2610: AND EXISTS (
2611: SELECT 'X'
2612: FROM igs_pr_org_stat_ref ostr1
2613: WHERE ostr1.stat_type = p_stat_type
2614: AND ostr1.org_unit_cd = p_org_unit_cd
2615: AND ostr1.unit_ref_cd = urc.reference_cd
2616: AND ostr1.include_or_exclude = 'INCLUDE');

Line 2629: FROM igs_pr_org_stat_ref ostr1

2625: AND urc.reference_cd_type = rct.reference_cd_type
2626: AND urc.deleted_date IS NULL
2627: AND rct.s_reference_cd_type = 'STATS'
2628: AND EXISTS( SELECT 'X'
2629: FROM igs_pr_org_stat_ref ostr1
2630: WHERE ostr1.stat_type = p_stat_type
2631: AND ostr1.org_unit_cd = p_org_unit_cd
2632: AND ostr1.unit_ref_cd = urc.reference_cd
2633: AND ostr1.include_or_exclude = 'EXCLUDE');