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.IGS_AD_SS_GEN_001 dependencies on IGS_AD_SS_LOOKUPS

Line 3598: FROM igs_ad_ss_lookups

3594: AND addr.STATUS = 'A'
3595: AND addr.party_site_id = use.party_site_id
3596: AND use.site_use_type IN
3597: (SELECT SS_Lookup_code
3598: FROM igs_ad_ss_lookups
3599: WHERE ss_lookup_type = 'SITE_USE_CODE'
3600: AND admission_application_type = cp_ApplType
3601: AND Closed_flag <> 'Y');
3602:

Line 3612: FROM igs_ad_ss_lookups

3608: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
3609: AND STATUS = 'A'
3610: AND PHONE_LINE_TYPE IN
3611: (SELECT SS_Lookup_code
3612: FROM igs_ad_ss_lookups
3613: WHERE ss_lookup_type = 'PHONE_LINE_TYPE'
3614: AND admission_application_type = cp_ApplType
3615: AND Closed_flag <> 'Y')
3616: AND OWNER_TABLE_ID = cp_person_id;

Line 3634: FROM igs_ad_ss_lookups

3630: FROM IGS_PE_ALT_PERS_ID
3631: WHERE PE_PERSON_ID = cp_person_id
3632: AND PERSON_ID_TYPE IN
3633: (SELECT SS_Lookup_code
3634: FROM igs_ad_ss_lookups
3635: WHERE ss_lookup_type = 'PERSON_ID_TYPE'
3636: AND admission_application_type = cp_ApplType
3637: AND Closed_flag <> 'Y')
3638: AND (END_DT IS NULL OR START_DT <> END_DT);

Line 3647: FROM igs_ad_ss_lookups

3643: FROM IGS_PE_PERSON_ALIAS_V pon
3644: WHERE pon.PERSON_ID = cp_person_id
3645: AND ALIAS_TYPE IN
3646: (SELECT SS_Lookup_code
3647: FROM igs_ad_ss_lookups
3648: WHERE ss_lookup_type = 'PE_ALIAS_TYPE'
3649: AND admission_application_type = cp_ApplType
3650: AND Closed_flag <> 'Y');
3651: -- Ask PM for Date Check

Line 3672: FROM igs_ad_ss_lookups

3668: FROM IGS_PE_PRIV_LEVEL priv
3669: WHERE PERSON_ID = cp_person_id
3670: AND to_char(DATA_GROUP_ID) IN
3671: (SELECT SS_Lookup_code
3672: FROM igs_ad_ss_lookups
3673: WHERE ss_lookup_type = 'PRIVACY_PREF_DATA_GROUP'
3674: AND admission_application_type = cp_ApplType
3675: AND Closed_flag <> 'Y');
3676:

Line 3688: FROM igs_ad_ss_lookups

3684: AND rel.STATUS = 'A'
3685: AND SYSDATE BETWEEN rel.START_DATE AND NVL(rel.END_DATE, SYSDATE)
3686: AND RELATIONSHIP_CODE IN
3687: (SELECT SS_Lookup_code
3688: FROM igs_ad_ss_lookups
3689: WHERE ss_lookup_type = 'PARTY_RELATIONS_TYPE'
3690: AND admission_application_type = cp_ApplType
3691: AND Closed_flag <> 'Y');
3692:

Line 3862: FROM igs_ad_ss_lookups

3858: FROM IGS_AD_TEST_RESULTS
3859: WHERE PERSON_ID = cp_person_id
3860: AND ADMISSION_TEST_TYPE IN
3861: (SELECT SS_Lookup_code
3862: FROM igs_ad_ss_lookups
3863: WHERE ss_lookup_type = 'ADMISSION_TEST_TYPE'
3864: AND admission_application_type = cp_ApplType
3865: AND Closed_flag <> 'Y');
3866:

Line 3934: FROM igs_ad_ss_lookups

3930: FROM IGS_PE_CREDENTIALS
3931: WHERE person_id = cp_person_id
3932: AND to_char(CREDENTIAL_TYPE_ID) IN
3933: (SELECT SS_Lookup_code
3934: FROM igs_ad_ss_lookups
3935: WHERE ss_lookup_type = 'CREDENTIAL_TYPE'
3936: AND admission_application_type = cp_ApplType
3937: AND Closed_flag <> 'Y');
3938:

Line 5575: PROCEDURE get_ss_lookup_desc(p_application_type IN igs_ad_ss_lookups.admission_application_type%type,

5571: END ADD_PERSTMT_ATTACHMENT_UP;
5572: -- PERSONAL_STMTS
5573:
5574: /* Get Concatenated Enabled SS Lookup Code Descriptions for a given lookup type with given delimiter */
5575: PROCEDURE get_ss_lookup_desc(p_application_type IN igs_ad_ss_lookups.admission_application_type%type,
5576: p_lookup_type IN igs_ad_ss_lookups.ss_lookup_type%TYPE,
5577: p_delimiter IN VARCHAR2,
5578: x_message_name OUT NOCOPY VARCHAR2,
5579: x_return_status OUT NOCOPY VARCHAR2,

Line 5576: p_lookup_type IN igs_ad_ss_lookups.ss_lookup_type%TYPE,

5572: -- PERSONAL_STMTS
5573:
5574: /* Get Concatenated Enabled SS Lookup Code Descriptions for a given lookup type with given delimiter */
5575: PROCEDURE get_ss_lookup_desc(p_application_type IN igs_ad_ss_lookups.admission_application_type%type,
5576: p_lookup_type IN igs_ad_ss_lookups.ss_lookup_type%TYPE,
5577: p_delimiter IN VARCHAR2,
5578: x_message_name OUT NOCOPY VARCHAR2,
5579: x_return_status OUT NOCOPY VARCHAR2,
5580: x_concat_desc OUT NOCOPY VARCHAR2) AS

Line 5587: AND EXISTS (SELECT 1 FROM IGS_AD_SS_LOOKUPS sslkps

5583: SELECT al.meaning lookup_desc
5584: FROM AR_LOOKUPS al
5585: WHERE al.LOOKUP_TYPE = 'PARTY_SITE_USE_CODE'
5586: AND al.ENABLED_FLAG = 'Y'
5587: AND EXISTS (SELECT 1 FROM IGS_AD_SS_LOOKUPS sslkps
5588: WHERE sslkps.SS_LOOKUP_TYPE = 'SITE_USE_CODE' AND
5589: sslkps.admission_application_type = p_application_type AND
5590: sslkps.ss_lookup_code = al.lookup_code AND
5591: sslkps.closed_flag <> 'Y');

Line 5602: (SELECT 1 FROM IGS_AD_SS_LOOKUPS sslkps

5598: AND lv.VIEW_APPLICATION_ID = 222
5599: AND lv.SECURITY_GROUP_ID = 0
5600: AND lv.ENABLED_FLAG = 'Y'
5601: AND EXISTS
5602: (SELECT 1 FROM IGS_AD_SS_LOOKUPS sslkps
5603: WHERE sslkps.SS_LOOKUP_TYPE = 'PHONE_LINE_TYPE' AND
5604: sslkps.admission_application_type = p_application_type AND
5605: sslkps.ss_lookup_code = lv.lookup_code AND
5606: sslkps.closed_flag <> 'Y');

Line 5612: AND EXISTS (SELECT 1 FROM IGS_AD_SS_LOOKUPS sslkps

5608: CURSOR c_person_id_type IS
5609: SELECT pit.description lookup_desc
5610: FROM IGS_PE_PERSON_ID_TYP pit
5611: WHERE pit.closed_ind <> 'Y'
5612: AND EXISTS (SELECT 1 FROM IGS_AD_SS_LOOKUPS sslkps
5613: WHERE sslkps.SS_LOOKUP_TYPE = 'PERSON_ID_TYPE' AND
5614: sslkps.admission_application_type = p_application_type AND
5615: sslkps.ss_lookup_code = pit.person_id_type AND
5616: sslkps.closed_flag <> 'Y');

Line 5631: AND EXISTS (SELECT 1 FROM IGS_AD_SS_LOOKUPS sslkps

5627: AND lv.LANGUAGE(+) = USERENV('LANG')
5628: AND lv.VIEW_APPLICATION_ID = 222
5629: AND lv.SECURITY_GROUP_ID = 0
5630: AND lv.ENABLED_FLAG = 'Y'
5631: AND EXISTS (SELECT 1 FROM IGS_AD_SS_LOOKUPS sslkps
5632: WHERE sslkps.SS_LOOKUP_TYPE = 'PARTY_RELATIONS_TYPE' AND
5633: sslkps.admission_application_type = p_application_type AND
5634: sslkps.ss_lookup_code = lv.lookup_code AND
5635: sslkps.closed_flag <> 'Y');

Line 5641: AND EXISTS (SELECT 1 FROM IGS_AD_SS_LOOKUPS sslkps

5637: CURSOR c_privacy_data IS
5638: SELECT pdg.description lookup_desc
5639: FROM IGS_PE_DATA_GROUPS_ALL pdg
5640: WHERE pdg.closed_ind <> 'Y'
5641: AND EXISTS (SELECT 1 FROM IGS_AD_SS_LOOKUPS sslkps
5642: WHERE sslkps.ss_lookup_type = 'PRIVACY_PREF_DATA_GROUP' AND
5643: sslkps.admission_application_type = p_application_type AND
5644: sslkps.ss_lookup_code = to_char(pdg.data_group_id) AND
5645: sslkps.closed_flag <> 'Y');

Line 5652: AND EXISTS (SELECT 1 FROM IGS_AD_SS_LOOKUPS sslkps

5648: SELECT lv.meaning lookup_desc
5649: FROM igs_lookup_values lv
5650: WHERE lv.LOOKUP_TYPE = 'PE_ALIAS_TYPE'
5651: AND lv.ENABLED_FLAG = 'Y'
5652: AND EXISTS (SELECT 1 FROM IGS_AD_SS_LOOKUPS sslkps
5653: WHERE sslkps.SS_LOOKUP_TYPE = 'PE_ALIAS_TYPE' AND
5654: sslkps.admission_application_type = p_application_type AND
5655: sslkps.ss_lookup_code = lv.lookup_code AND
5656: sslkps.closed_flag <> 'Y');

Line 5662: AND EXISTS (SELECT 1 FROM IGS_AD_SS_LOOKUPS sslkps

5658: CURSOR c_credential_type IS
5659: SELECT act.description lookup_desc
5660: FROM IGS_AD_CRED_TYPES act
5661: WHERE act.closed_ind <> 'Y'
5662: AND EXISTS (SELECT 1 FROM IGS_AD_SS_LOOKUPS sslkps
5663: WHERE sslkps.ss_lookup_type = 'CREDENTIAL_TYPE' AND
5664: sslkps.admission_application_type = p_application_type AND
5665: sslkps.ss_lookup_code = to_char(act.credential_type_id) AND
5666: sslkps.closed_flag <> 'Y');

Line 5672: AND EXISTS (SELECT 1 FROM IGS_AD_SS_LOOKUPS sslkps

5668: CURSOR c_admission_test_type IS
5669: SELECT att.description lookup_desc
5670: FROM IGS_AD_TEST_TYPE att
5671: WHERE att.closed_ind <> 'Y'
5672: AND EXISTS (SELECT 1 FROM IGS_AD_SS_LOOKUPS sslkps
5673: WHERE sslkps.SS_LOOKUP_TYPE = 'ADMISSION_TEST_TYPE' AND
5674: sslkps.admission_application_type = p_application_type AND
5675: sslkps.ss_lookup_code = att.admission_test_type AND
5676: sslkps.closed_flag <> 'Y');