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.

[Home] [Help]

APPS.IGS_AD_SS_GEN_001 dependencies on IGS_PE_PERSON_TYPES

Line 668: l_person_type_code IGS_PE_PERSON_TYPES.person_type_code%TYPE;

664:
665: l_rowid VARCHAR2(25);
666: l_org_id NUMBER(15);
667: l_type_instance_id NUMBER;
668: l_person_type_code IGS_PE_PERSON_TYPES.person_type_code%TYPE;
669:
670: CURSOR c_person_type_code(l_system_type IGS_PE_PERSON_TYPES.system_type%TYPE) IS
671: SELECT person_type_code
672: FROM igs_pe_person_types

Line 670: CURSOR c_person_type_code(l_system_type IGS_PE_PERSON_TYPES.system_type%TYPE) IS

666: l_org_id NUMBER(15);
667: l_type_instance_id NUMBER;
668: l_person_type_code IGS_PE_PERSON_TYPES.person_type_code%TYPE;
669:
670: CURSOR c_person_type_code(l_system_type IGS_PE_PERSON_TYPES.system_type%TYPE) IS
671: SELECT person_type_code
672: FROM igs_pe_person_types
673: WHERE system_type = l_system_type;
674: lv_mode VARCHAR2(1) DEFAULT 'R';

Line 672: FROM igs_pe_person_types

668: l_person_type_code IGS_PE_PERSON_TYPES.person_type_code%TYPE;
669:
670: CURSOR c_person_type_code(l_system_type IGS_PE_PERSON_TYPES.system_type%TYPE) IS
671: SELECT person_type_code
672: FROM igs_pe_person_types
673: WHERE system_type = l_system_type;
674: lv_mode VARCHAR2(1) DEFAULT 'R';
675: BEGIN
676: --Begin Local Loop 1