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_FI_PRC_FEE_ASS dependencies on IGS_FI_FEE_AS_ITEMS

Line 80: person_id IGS_FI_FEE_AS_ITEMS.person_id%TYPE,

76:
77: g_v_include_audit VARCHAR2(1) := 'N';
78:
79: TYPE r_s_fee_as_items_typ IS RECORD (
80: person_id IGS_FI_FEE_AS_ITEMS.person_id%TYPE,
81: status IGS_FI_FEE_AS_ITEMS.status%TYPE,
82: fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
83: fee_cat IGS_FI_FEE_AS_ITEMS.fee_cat%TYPE,
84: fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,

Line 81: status IGS_FI_FEE_AS_ITEMS.status%TYPE,

77: g_v_include_audit VARCHAR2(1) := 'N';
78:
79: TYPE r_s_fee_as_items_typ IS RECORD (
80: person_id IGS_FI_FEE_AS_ITEMS.person_id%TYPE,
81: status IGS_FI_FEE_AS_ITEMS.status%TYPE,
82: fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
83: fee_cat IGS_FI_FEE_AS_ITEMS.fee_cat%TYPE,
84: fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
85: fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,

Line 82: fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,

78:
79: TYPE r_s_fee_as_items_typ IS RECORD (
80: person_id IGS_FI_FEE_AS_ITEMS.person_id%TYPE,
81: status IGS_FI_FEE_AS_ITEMS.status%TYPE,
82: fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
83: fee_cat IGS_FI_FEE_AS_ITEMS.fee_cat%TYPE,
84: fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
85: fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
86: rul_sequence_number IGS_FI_FEE_AS_ITEMS.rul_sequence_number%TYPE,

Line 83: fee_cat IGS_FI_FEE_AS_ITEMS.fee_cat%TYPE,

79: TYPE r_s_fee_as_items_typ IS RECORD (
80: person_id IGS_FI_FEE_AS_ITEMS.person_id%TYPE,
81: status IGS_FI_FEE_AS_ITEMS.status%TYPE,
82: fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
83: fee_cat IGS_FI_FEE_AS_ITEMS.fee_cat%TYPE,
84: fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
85: fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
86: rul_sequence_number IGS_FI_FEE_AS_ITEMS.rul_sequence_number%TYPE,
87: course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,

Line 84: fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,

80: person_id IGS_FI_FEE_AS_ITEMS.person_id%TYPE,
81: status IGS_FI_FEE_AS_ITEMS.status%TYPE,
82: fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
83: fee_cat IGS_FI_FEE_AS_ITEMS.fee_cat%TYPE,
84: fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
85: fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
86: rul_sequence_number IGS_FI_FEE_AS_ITEMS.rul_sequence_number%TYPE,
87: course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,
88: crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,

Line 85: fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,

81: status IGS_FI_FEE_AS_ITEMS.status%TYPE,
82: fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
83: fee_cat IGS_FI_FEE_AS_ITEMS.fee_cat%TYPE,
84: fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
85: fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
86: rul_sequence_number IGS_FI_FEE_AS_ITEMS.rul_sequence_number%TYPE,
87: course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,
88: crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
89: old_chg_method_type IGS_FI_FEE_AS_ITEMS.S_CHG_METHOD_TYPE%TYPE,

Line 86: rul_sequence_number IGS_FI_FEE_AS_ITEMS.rul_sequence_number%TYPE,

82: fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
83: fee_cat IGS_FI_FEE_AS_ITEMS.fee_cat%TYPE,
84: fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
85: fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
86: rul_sequence_number IGS_FI_FEE_AS_ITEMS.rul_sequence_number%TYPE,
87: course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,
88: crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
89: old_chg_method_type IGS_FI_FEE_AS_ITEMS.S_CHG_METHOD_TYPE%TYPE,
90: chg_method_type IGS_FI_FEE_AS_ITEMS.S_CHG_METHOD_TYPE%TYPE,

Line 87: course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,

83: fee_cat IGS_FI_FEE_AS_ITEMS.fee_cat%TYPE,
84: fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
85: fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
86: rul_sequence_number IGS_FI_FEE_AS_ITEMS.rul_sequence_number%TYPE,
87: course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,
88: crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
89: old_chg_method_type IGS_FI_FEE_AS_ITEMS.S_CHG_METHOD_TYPE%TYPE,
90: chg_method_type IGS_FI_FEE_AS_ITEMS.S_CHG_METHOD_TYPE%TYPE,
91: description IGS_FI_FEE_AS_ITEMS.description%TYPE,

Line 88: crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,

84: fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
85: fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
86: rul_sequence_number IGS_FI_FEE_AS_ITEMS.rul_sequence_number%TYPE,
87: course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,
88: crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
89: old_chg_method_type IGS_FI_FEE_AS_ITEMS.S_CHG_METHOD_TYPE%TYPE,
90: chg_method_type IGS_FI_FEE_AS_ITEMS.S_CHG_METHOD_TYPE%TYPE,
91: description IGS_FI_FEE_AS_ITEMS.description%TYPE,
92: old_chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,

Line 89: old_chg_method_type IGS_FI_FEE_AS_ITEMS.S_CHG_METHOD_TYPE%TYPE,

85: fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
86: rul_sequence_number IGS_FI_FEE_AS_ITEMS.rul_sequence_number%TYPE,
87: course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,
88: crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
89: old_chg_method_type IGS_FI_FEE_AS_ITEMS.S_CHG_METHOD_TYPE%TYPE,
90: chg_method_type IGS_FI_FEE_AS_ITEMS.S_CHG_METHOD_TYPE%TYPE,
91: description IGS_FI_FEE_AS_ITEMS.description%TYPE,
92: old_chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
93: chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,

Line 90: chg_method_type IGS_FI_FEE_AS_ITEMS.S_CHG_METHOD_TYPE%TYPE,

86: rul_sequence_number IGS_FI_FEE_AS_ITEMS.rul_sequence_number%TYPE,
87: course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,
88: crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
89: old_chg_method_type IGS_FI_FEE_AS_ITEMS.S_CHG_METHOD_TYPE%TYPE,
90: chg_method_type IGS_FI_FEE_AS_ITEMS.S_CHG_METHOD_TYPE%TYPE,
91: description IGS_FI_FEE_AS_ITEMS.description%TYPE,
92: old_chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
93: chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
94: old_amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,

Line 91: description IGS_FI_FEE_AS_ITEMS.description%TYPE,

87: course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,
88: crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
89: old_chg_method_type IGS_FI_FEE_AS_ITEMS.S_CHG_METHOD_TYPE%TYPE,
90: chg_method_type IGS_FI_FEE_AS_ITEMS.S_CHG_METHOD_TYPE%TYPE,
91: description IGS_FI_FEE_AS_ITEMS.description%TYPE,
92: old_chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
93: chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
94: old_amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,
95: amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,

Line 92: old_chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,

88: crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
89: old_chg_method_type IGS_FI_FEE_AS_ITEMS.S_CHG_METHOD_TYPE%TYPE,
90: chg_method_type IGS_FI_FEE_AS_ITEMS.S_CHG_METHOD_TYPE%TYPE,
91: description IGS_FI_FEE_AS_ITEMS.description%TYPE,
92: old_chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
93: chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
94: old_amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,
95: amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,
96: unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,

Line 93: chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,

89: old_chg_method_type IGS_FI_FEE_AS_ITEMS.S_CHG_METHOD_TYPE%TYPE,
90: chg_method_type IGS_FI_FEE_AS_ITEMS.S_CHG_METHOD_TYPE%TYPE,
91: description IGS_FI_FEE_AS_ITEMS.description%TYPE,
92: old_chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
93: chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
94: old_amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,
95: amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,
96: unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
97: location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,

Line 94: old_amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,

90: chg_method_type IGS_FI_FEE_AS_ITEMS.S_CHG_METHOD_TYPE%TYPE,
91: description IGS_FI_FEE_AS_ITEMS.description%TYPE,
92: old_chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
93: chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
94: old_amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,
95: amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,
96: unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
97: location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,
98: old_eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,

Line 95: amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,

91: description IGS_FI_FEE_AS_ITEMS.description%TYPE,
92: old_chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
93: chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
94: old_amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,
95: amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,
96: unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
97: location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,
98: old_eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,
99: eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,

Line 96: unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,

92: old_chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
93: chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
94: old_amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,
95: amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,
96: unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
97: location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,
98: old_eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,
99: eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,
100: old_credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,

Line 97: location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,

93: chg_elements IGS_FI_FEE_AS_ITEMS.chg_elements%TYPE,
94: old_amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,
95: amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,
96: unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
97: location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,
98: old_eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,
99: eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,
100: old_credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,
101: credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,

Line 98: old_eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,

94: old_amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,
95: amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,
96: unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
97: location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,
98: old_eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,
99: eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,
100: old_credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,
101: credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,
102: chg_rate IGS_FI_FEE_AS_RATE.chg_rate%TYPE,

Line 99: eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,

95: amount IGS_FI_FEE_AS_ITEMS.amount%TYPE,
96: unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
97: location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,
98: old_eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,
99: eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,
100: old_credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,
101: credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,
102: chg_rate IGS_FI_FEE_AS_RATE.chg_rate%TYPE,
103: org_unit_cd IGS_FI_FEE_AS_ITEMS.org_unit_cd%TYPE,

Line 100: old_credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,

96: unit_attempt_status IGS_FI_FEE_AS_ITEMS.unit_attempt_status%TYPE,
97: location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,
98: old_eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,
99: eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,
100: old_credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,
101: credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,
102: chg_rate IGS_FI_FEE_AS_RATE.chg_rate%TYPE,
103: org_unit_cd IGS_FI_FEE_AS_ITEMS.org_unit_cd%TYPE,
104: class_standing IGS_FI_FEE_AS_ITEMS.class_standing%TYPE,

Line 101: credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,

97: location_cd IGS_FI_FEE_AS_ITEMS.location_cd%TYPE,
98: old_eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,
99: eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,
100: old_credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,
101: credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,
102: chg_rate IGS_FI_FEE_AS_RATE.chg_rate%TYPE,
103: org_unit_cd IGS_FI_FEE_AS_ITEMS.org_unit_cd%TYPE,
104: class_standing IGS_FI_FEE_AS_ITEMS.class_standing%TYPE,
105: residency_status_cd IGS_FI_FEE_AS_ITEMS.residency_status_cd%TYPE,

Line 103: org_unit_cd IGS_FI_FEE_AS_ITEMS.org_unit_cd%TYPE,

99: eftsu IGS_FI_FEE_AS_ITEMS.eftsu%TYPE,
100: old_credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,
101: credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,
102: chg_rate IGS_FI_FEE_AS_RATE.chg_rate%TYPE,
103: org_unit_cd IGS_FI_FEE_AS_ITEMS.org_unit_cd%TYPE,
104: class_standing IGS_FI_FEE_AS_ITEMS.class_standing%TYPE,
105: residency_status_cd IGS_FI_FEE_AS_ITEMS.residency_status_cd%TYPE,
106: uoo_id IGS_FI_FEE_AS_ITEMS.UOO_ID%TYPE,
107: add_flag VARCHAR2(1) DEFAULT 'N',

Line 104: class_standing IGS_FI_FEE_AS_ITEMS.class_standing%TYPE,

100: old_credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,
101: credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,
102: chg_rate IGS_FI_FEE_AS_RATE.chg_rate%TYPE,
103: org_unit_cd IGS_FI_FEE_AS_ITEMS.org_unit_cd%TYPE,
104: class_standing IGS_FI_FEE_AS_ITEMS.class_standing%TYPE,
105: residency_status_cd IGS_FI_FEE_AS_ITEMS.residency_status_cd%TYPE,
106: uoo_id IGS_FI_FEE_AS_ITEMS.UOO_ID%TYPE,
107: add_flag VARCHAR2(1) DEFAULT 'N',
108: unit_set_cd igs_fi_fee_as_items.unit_set_cd%TYPE,

Line 105: residency_status_cd IGS_FI_FEE_AS_ITEMS.residency_status_cd%TYPE,

101: credit_points IGS_FI_FEE_AS_ITEMS.credit_points%TYPE,
102: chg_rate IGS_FI_FEE_AS_RATE.chg_rate%TYPE,
103: org_unit_cd IGS_FI_FEE_AS_ITEMS.org_unit_cd%TYPE,
104: class_standing IGS_FI_FEE_AS_ITEMS.class_standing%TYPE,
105: residency_status_cd IGS_FI_FEE_AS_ITEMS.residency_status_cd%TYPE,
106: uoo_id IGS_FI_FEE_AS_ITEMS.UOO_ID%TYPE,
107: add_flag VARCHAR2(1) DEFAULT 'N',
108: unit_set_cd igs_fi_fee_as_items.unit_set_cd%TYPE,
109: us_version_number igs_fi_fee_as_items.us_version_number%TYPE,

Line 106: uoo_id IGS_FI_FEE_AS_ITEMS.UOO_ID%TYPE,

102: chg_rate IGS_FI_FEE_AS_RATE.chg_rate%TYPE,
103: org_unit_cd IGS_FI_FEE_AS_ITEMS.org_unit_cd%TYPE,
104: class_standing IGS_FI_FEE_AS_ITEMS.class_standing%TYPE,
105: residency_status_cd IGS_FI_FEE_AS_ITEMS.residency_status_cd%TYPE,
106: uoo_id IGS_FI_FEE_AS_ITEMS.UOO_ID%TYPE,
107: add_flag VARCHAR2(1) DEFAULT 'N',
108: unit_set_cd igs_fi_fee_as_items.unit_set_cd%TYPE,
109: us_version_number igs_fi_fee_as_items.us_version_number%TYPE,
110: unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,

Line 108: unit_set_cd igs_fi_fee_as_items.unit_set_cd%TYPE,

104: class_standing IGS_FI_FEE_AS_ITEMS.class_standing%TYPE,
105: residency_status_cd IGS_FI_FEE_AS_ITEMS.residency_status_cd%TYPE,
106: uoo_id IGS_FI_FEE_AS_ITEMS.UOO_ID%TYPE,
107: add_flag VARCHAR2(1) DEFAULT 'N',
108: unit_set_cd igs_fi_fee_as_items.unit_set_cd%TYPE,
109: us_version_number igs_fi_fee_as_items.us_version_number%TYPE,
110: unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
111: unit_class igs_fi_fee_as_items.unit_class%TYPE,
112: unit_mode igs_fi_fee_as_items.unit_mode%TYPE,

Line 109: us_version_number igs_fi_fee_as_items.us_version_number%TYPE,

105: residency_status_cd IGS_FI_FEE_AS_ITEMS.residency_status_cd%TYPE,
106: uoo_id IGS_FI_FEE_AS_ITEMS.UOO_ID%TYPE,
107: add_flag VARCHAR2(1) DEFAULT 'N',
108: unit_set_cd igs_fi_fee_as_items.unit_set_cd%TYPE,
109: us_version_number igs_fi_fee_as_items.us_version_number%TYPE,
110: unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
111: unit_class igs_fi_fee_as_items.unit_class%TYPE,
112: unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
113: unit_cd igs_fi_fee_as_rate.unit_cd%TYPE,

Line 110: unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,

106: uoo_id IGS_FI_FEE_AS_ITEMS.UOO_ID%TYPE,
107: add_flag VARCHAR2(1) DEFAULT 'N',
108: unit_set_cd igs_fi_fee_as_items.unit_set_cd%TYPE,
109: us_version_number igs_fi_fee_as_items.us_version_number%TYPE,
110: unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
111: unit_class igs_fi_fee_as_items.unit_class%TYPE,
112: unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
113: unit_cd igs_fi_fee_as_rate.unit_cd%TYPE,
114: unit_level igs_fi_fee_as_items.unit_level%TYPE,

Line 111: unit_class igs_fi_fee_as_items.unit_class%TYPE,

107: add_flag VARCHAR2(1) DEFAULT 'N',
108: unit_set_cd igs_fi_fee_as_items.unit_set_cd%TYPE,
109: us_version_number igs_fi_fee_as_items.us_version_number%TYPE,
110: unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
111: unit_class igs_fi_fee_as_items.unit_class%TYPE,
112: unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
113: unit_cd igs_fi_fee_as_rate.unit_cd%TYPE,
114: unit_level igs_fi_fee_as_items.unit_level%TYPE,
115: unit_version_number igs_fi_fee_as_rate.unit_version_number%TYPE,

Line 112: unit_mode igs_fi_fee_as_items.unit_mode%TYPE,

108: unit_set_cd igs_fi_fee_as_items.unit_set_cd%TYPE,
109: us_version_number igs_fi_fee_as_items.us_version_number%TYPE,
110: unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
111: unit_class igs_fi_fee_as_items.unit_class%TYPE,
112: unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
113: unit_cd igs_fi_fee_as_rate.unit_cd%TYPE,
114: unit_level igs_fi_fee_as_items.unit_level%TYPE,
115: unit_version_number igs_fi_fee_as_rate.unit_version_number%TYPE,
116: fee_ass_item_id igs_fi_fee_as_items.fee_ass_item_id%TYPE,

Line 114: unit_level igs_fi_fee_as_items.unit_level%TYPE,

110: unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
111: unit_class igs_fi_fee_as_items.unit_class%TYPE,
112: unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
113: unit_cd igs_fi_fee_as_rate.unit_cd%TYPE,
114: unit_level igs_fi_fee_as_items.unit_level%TYPE,
115: unit_version_number igs_fi_fee_as_rate.unit_version_number%TYPE,
116: fee_ass_item_id igs_fi_fee_as_items.fee_ass_item_id%TYPE,
117: element_order NUMBER
118: );

Line 116: fee_ass_item_id igs_fi_fee_as_items.fee_ass_item_id%TYPE,

112: unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
113: unit_cd igs_fi_fee_as_rate.unit_cd%TYPE,
114: unit_level igs_fi_fee_as_items.unit_level%TYPE,
115: unit_version_number igs_fi_fee_as_rate.unit_version_number%TYPE,
116: fee_ass_item_id igs_fi_fee_as_items.fee_ass_item_id%TYPE,
117: element_order NUMBER
118: );
119:
120:

Line 135: chg_elements igs_fi_fee_as_items.chg_elements%TYPE,

131: location_cd igs_fi_fai_dtls.location_cd%TYPE,
132: uoo_id igs_fi_fai_dtls.uoo_id%TYPE,
133: unit_set_cd igs_fi_fai_dtls.unit_set_cd%TYPE,
134: us_version_number igs_fi_fai_dtls.us_version_number%TYPE,
135: chg_elements igs_fi_fee_as_items.chg_elements%TYPE,
136: unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
137: unit_class igs_fi_fee_as_items.unit_class%TYPE,
138: unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
139: unit_cd igs_fi_fee_as_items.unit_cd%TYPE,

Line 136: unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,

132: uoo_id igs_fi_fai_dtls.uoo_id%TYPE,
133: unit_set_cd igs_fi_fai_dtls.unit_set_cd%TYPE,
134: us_version_number igs_fi_fai_dtls.us_version_number%TYPE,
135: chg_elements igs_fi_fee_as_items.chg_elements%TYPE,
136: unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
137: unit_class igs_fi_fee_as_items.unit_class%TYPE,
138: unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
139: unit_cd igs_fi_fee_as_items.unit_cd%TYPE,
140: unit_level igs_fi_fee_as_items.unit_level%TYPE,

Line 137: unit_class igs_fi_fee_as_items.unit_class%TYPE,

133: unit_set_cd igs_fi_fai_dtls.unit_set_cd%TYPE,
134: us_version_number igs_fi_fai_dtls.us_version_number%TYPE,
135: chg_elements igs_fi_fee_as_items.chg_elements%TYPE,
136: unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
137: unit_class igs_fi_fee_as_items.unit_class%TYPE,
138: unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
139: unit_cd igs_fi_fee_as_items.unit_cd%TYPE,
140: unit_level igs_fi_fee_as_items.unit_level%TYPE,
141: unit_version_number igs_fi_fee_as_items.unit_version_number%TYPE

Line 138: unit_mode igs_fi_fee_as_items.unit_mode%TYPE,

134: us_version_number igs_fi_fai_dtls.us_version_number%TYPE,
135: chg_elements igs_fi_fee_as_items.chg_elements%TYPE,
136: unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
137: unit_class igs_fi_fee_as_items.unit_class%TYPE,
138: unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
139: unit_cd igs_fi_fee_as_items.unit_cd%TYPE,
140: unit_level igs_fi_fee_as_items.unit_level%TYPE,
141: unit_version_number igs_fi_fee_as_items.unit_version_number%TYPE
142: );

Line 139: unit_cd igs_fi_fee_as_items.unit_cd%TYPE,

135: chg_elements igs_fi_fee_as_items.chg_elements%TYPE,
136: unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
137: unit_class igs_fi_fee_as_items.unit_class%TYPE,
138: unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
139: unit_cd igs_fi_fee_as_items.unit_cd%TYPE,
140: unit_level igs_fi_fee_as_items.unit_level%TYPE,
141: unit_version_number igs_fi_fee_as_items.unit_version_number%TYPE
142: );
143:

Line 140: unit_level igs_fi_fee_as_items.unit_level%TYPE,

136: unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
137: unit_class igs_fi_fee_as_items.unit_class%TYPE,
138: unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
139: unit_cd igs_fi_fee_as_items.unit_cd%TYPE,
140: unit_level igs_fi_fee_as_items.unit_level%TYPE,
141: unit_version_number igs_fi_fee_as_items.unit_version_number%TYPE
142: );
143:
144: TYPE t_fai_unit_dtls_typ IS TABLE OF rec_fai_unit_dtls_typ INDEX BY BINARY_INTEGER;

Line 141: unit_version_number igs_fi_fee_as_items.unit_version_number%TYPE

137: unit_class igs_fi_fee_as_items.unit_class%TYPE,
138: unit_mode igs_fi_fee_as_items.unit_mode%TYPE,
139: unit_cd igs_fi_fee_as_items.unit_cd%TYPE,
140: unit_level igs_fi_fee_as_items.unit_level%TYPE,
141: unit_version_number igs_fi_fee_as_items.unit_version_number%TYPE
142: );
143:
144: TYPE t_fai_unit_dtls_typ IS TABLE OF rec_fai_unit_dtls_typ INDEX BY BINARY_INTEGER;
145:

Line 153: person_id IGS_FI_FEE_AS_ITEMS.person_id%TYPE,

149:
150: t_dummy_fee_as_items t_fee_as_items_typ;
151:
152: TYPE r_inst_fee_rec IS RECORD (
153: person_id IGS_FI_FEE_AS_ITEMS.person_id%TYPE,
154: fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
155: fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
156: fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
157: fcfl_status IGS_FI_F_CAT_FEE_LBL.FEE_LIABILITY_STATUS%TYPE);

Line 154: fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,

150: t_dummy_fee_as_items t_fee_as_items_typ;
151:
152: TYPE r_inst_fee_rec IS RECORD (
153: person_id IGS_FI_FEE_AS_ITEMS.person_id%TYPE,
154: fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
155: fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
156: fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
157: fcfl_status IGS_FI_F_CAT_FEE_LBL.FEE_LIABILITY_STATUS%TYPE);
158:

Line 155: fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,

151:
152: TYPE r_inst_fee_rec IS RECORD (
153: person_id IGS_FI_FEE_AS_ITEMS.person_id%TYPE,
154: fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
155: fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
156: fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
157: fcfl_status IGS_FI_F_CAT_FEE_LBL.FEE_LIABILITY_STATUS%TYPE);
158:
159: TYPE t_inst_fee_rec_type IS TABLE OF r_inst_fee_rec INDEX BY BINARY_INTEGER;

Line 156: fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,

152: TYPE r_inst_fee_rec IS RECORD (
153: person_id IGS_FI_FEE_AS_ITEMS.person_id%TYPE,
154: fee_type IGS_FI_FEE_AS_ITEMS.fee_type%TYPE,
155: fee_cal_type IGS_FI_FEE_AS_ITEMS.fee_cal_type%TYPE,
156: fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
157: fcfl_status IGS_FI_F_CAT_FEE_LBL.FEE_LIABILITY_STATUS%TYPE);
158:
159: TYPE t_inst_fee_rec_type IS TABLE OF r_inst_fee_rec INDEX BY BINARY_INTEGER;
160: