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_AS_CALC_AWARD_MARK dependencies on IGS_PS_USEC_REF

Line 45: FROM igs_ps_usec_ref_cd refcd,

41: cp_unit_cd igs_en_su_attempt_all.unit_cd%TYPE,
42: cp_version_number igs_en_su_attempt_all.version_number%TYPE)
43: IS
44: SELECT 'X'
45: FROM igs_ps_usec_ref_cd refcd,
46: igs_ps_usec_ref usecref,
47: igs_ge_ref_cd_type rct
48: WHERE usecref.uoo_id = cp_uoo_id
49: AND usecref.unit_section_reference_id = refcd.unit_section_reference_id

Line 46: igs_ps_usec_ref usecref,

42: cp_version_number igs_en_su_attempt_all.version_number%TYPE)
43: IS
44: SELECT 'X'
45: FROM igs_ps_usec_ref_cd refcd,
46: igs_ps_usec_ref usecref,
47: igs_ge_ref_cd_type rct
48: WHERE usecref.uoo_id = cp_uoo_id
49: AND usecref.unit_section_reference_id = refcd.unit_section_reference_id
50: AND refcd.reference_code_type = rct.reference_cd_type

Line 60: FROM igs_ps_usec_ref_cd refcd,

56: AND urc.version_number = cp_version_number
57: AND urc.reference_cd_type = rct.reference_cd_type
58: AND rct.s_reference_cd_type = 'SUMMEAS'
59: AND NOT EXISTS ( SELECT refcd.reference_code_type
60: FROM igs_ps_usec_ref_cd refcd,
61: igs_ps_usec_ref usecref,
62: igs_ps_unit_ofr_opt_all opt,
63: igs_ge_ref_cd_type rct
64: WHERE usecref.uoo_id = cp_uoo_id

Line 61: igs_ps_usec_ref usecref,

57: AND urc.reference_cd_type = rct.reference_cd_type
58: AND rct.s_reference_cd_type = 'SUMMEAS'
59: AND NOT EXISTS ( SELECT refcd.reference_code_type
60: FROM igs_ps_usec_ref_cd refcd,
61: igs_ps_usec_ref usecref,
62: igs_ps_unit_ofr_opt_all opt,
63: igs_ge_ref_cd_type rct
64: WHERE usecref.uoo_id = cp_uoo_id
65: AND usecref.unit_section_reference_id =

Line 72: igs_ps_usec_ref usecref,

68: AND rct.s_reference_cd_type = 'SUMMEAS')
69: UNION
70: SELECT 'X'
71: FROM igs_ps_us_req_ref_cd refcd,
72: igs_ps_usec_ref usecref,
73: igs_ps_unit_ofr_opt_all opt,
74: igs_ge_ref_cd_type rct
75: WHERE usecref.uoo_id = cp_uoo_id
76: AND usecref.unit_section_reference_id = refcd.unit_section_reference_id

Line 88: igs_ps_usec_ref usecref,

84: AND urc.reference_cd_type = rct.reference_cd_type
85: AND rct.s_reference_cd_type = 'SUMMEAS'
86: AND NOT EXISTS ( SELECT refcd.reference_cd_type
87: FROM igs_ps_us_req_ref_cd refcd,
88: igs_ps_usec_ref usecref,
89: igs_ps_unit_ofr_opt_all opt,
90: igs_ge_ref_cd_type rct
91: WHERE usecref.uoo_id = cp_uoo_id
92: AND usecref.unit_section_reference_id =