APPS.IGS_AD_ACT_ASSESSMENTS_PKG dependencies on IGS_PE_PERSON_ID_TYP

Line 18: G_SSN_Person_Id_Type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;

14: ---------------------------------------------------------------------------------------------------------------------------*/
15: /******************************************************************************
16: -- GLOBAL VARIABLES AND CONSTANTS
17:
18: G_SSN_Person_Id_Type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
19: G_ACT_Person_Id_Type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
20: G_Score_Source_id IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
21: G_Transcript_Source IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
22: G_Grading_Scale IGS_AD_CODE_CLASSES.CODE_ID%TYPE;

Line 19: G_ACT_Person_Id_Type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;

15: /******************************************************************************
16: -- GLOBAL VARIABLES AND CONSTANTS
17:
18: G_SSN_Person_Id_Type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
19: G_ACT_Person_Id_Type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
20: G_Score_Source_id IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
21: G_Transcript_Source IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
22: G_Grading_Scale IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
23: G_Unit_Difficulty IGS_AD_CODE_CLASSES.CODE_ID%TYPE;

Line 77: -- Cursor to select the Person_ID_Type from IGS_PE_PERSON_ID_TYP where Sys_ID_Type = 'SSN'

73:
74: l_return NUMBER;
75: -- l_Country_Code VARCHAR2(30);
76:
77: -- Cursor to select the Person_ID_Type from IGS_PE_PERSON_ID_TYP where Sys_ID_Type = 'SSN'
78: CURSOR c_ssn_Person_Id_Type IS
79: SELECT
80: PERSON_ID_TYPE
81: FROM IGS_PE_PERSON_ID_TYP

Line 81: FROM IGS_PE_PERSON_ID_TYP

77: -- Cursor to select the Person_ID_Type from IGS_PE_PERSON_ID_TYP where Sys_ID_Type = 'SSN'
78: CURSOR c_ssn_Person_Id_Type IS
79: SELECT
80: PERSON_ID_TYPE
81: FROM IGS_PE_PERSON_ID_TYP
82: WHERE S_PERSON_ID_TYPE = 'SSN'
83: AND CLOSED_IND ='N';
84:
85: -- Cursor to select the Person_ID_Type from IGS_PE_PERSON_ID_TYP where Sys_ID_Type = 'ACTID'

Line 85: -- Cursor to select the Person_ID_Type from IGS_PE_PERSON_ID_TYP where Sys_ID_Type = 'ACTID'

81: FROM IGS_PE_PERSON_ID_TYP
82: WHERE S_PERSON_ID_TYPE = 'SSN'
83: AND CLOSED_IND ='N';
84:
85: -- Cursor to select the Person_ID_Type from IGS_PE_PERSON_ID_TYP where Sys_ID_Type = 'ACTID'
86: CURSOR c_Act_Person_Id_Type IS
87: SELECT
88: PERSON_ID_TYPE
89: FROM IGS_PE_PERSON_ID_TYP

Line 89: FROM IGS_PE_PERSON_ID_TYP

85: -- Cursor to select the Person_ID_Type from IGS_PE_PERSON_ID_TYP where Sys_ID_Type = 'ACTID'
86: CURSOR c_Act_Person_Id_Type IS
87: SELECT
88: PERSON_ID_TYPE
89: FROM IGS_PE_PERSON_ID_TYP
90: WHERE S_PERSON_ID_TYPE = 'ACTID'
91: AND CLOSED_IND ='N';
92:
93: -- Cursor to check and select the corresponding cod_id for Test_Score_Source = ELEC