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.PQP_GB_PENSION_FUNCTIONS dependencies on PQP_PENSION_TYPES_F

Line 103: FROM pqp_pension_types_f

99: IS
100: SELECT pension_type_id, pension_type_name, pension_category
101: ,NVL (minimum_age, 0) minimum_age, NVL (maximum_age, 0) maximum_age
102: ,effective_start_date, effective_end_date
103: FROM pqp_pension_types_f
104: WHERE pension_type_id = c_pension_type_id
105: AND ( ( business_group_id IS NOT NULL
106: AND business_group_id = c_business_group_id
107: )

Line 117: pension_type_id pqp_pension_types_f.pension_type_id%TYPE

113: AND c_effective_date BETWEEN effective_start_date
114: AND effective_end_date;
115:
116: TYPE r_pension_types IS RECORD (
117: pension_type_id pqp_pension_types_f.pension_type_id%TYPE
118: ,pension_type_name pqp_pension_types_f.pension_type_name%TYPE
119: ,pension_category pqp_pension_types_f.pension_category%TYPE
120: ,minimum_age pqp_pension_types_f.minimum_age%TYPE
121: ,maximum_age pqp_pension_types_f.maximum_age%TYPE

Line 118: ,pension_type_name pqp_pension_types_f.pension_type_name%TYPE

114: AND effective_end_date;
115:
116: TYPE r_pension_types IS RECORD (
117: pension_type_id pqp_pension_types_f.pension_type_id%TYPE
118: ,pension_type_name pqp_pension_types_f.pension_type_name%TYPE
119: ,pension_category pqp_pension_types_f.pension_category%TYPE
120: ,minimum_age pqp_pension_types_f.minimum_age%TYPE
121: ,maximum_age pqp_pension_types_f.maximum_age%TYPE
122: ,effective_start_date pqp_pension_types_f.effective_start_date%TYPE

Line 119: ,pension_category pqp_pension_types_f.pension_category%TYPE

115:
116: TYPE r_pension_types IS RECORD (
117: pension_type_id pqp_pension_types_f.pension_type_id%TYPE
118: ,pension_type_name pqp_pension_types_f.pension_type_name%TYPE
119: ,pension_category pqp_pension_types_f.pension_category%TYPE
120: ,minimum_age pqp_pension_types_f.minimum_age%TYPE
121: ,maximum_age pqp_pension_types_f.maximum_age%TYPE
122: ,effective_start_date pqp_pension_types_f.effective_start_date%TYPE
123: ,effective_end_date pqp_pension_types_f.effective_end_date%TYPE);

Line 120: ,minimum_age pqp_pension_types_f.minimum_age%TYPE

116: TYPE r_pension_types IS RECORD (
117: pension_type_id pqp_pension_types_f.pension_type_id%TYPE
118: ,pension_type_name pqp_pension_types_f.pension_type_name%TYPE
119: ,pension_category pqp_pension_types_f.pension_category%TYPE
120: ,minimum_age pqp_pension_types_f.minimum_age%TYPE
121: ,maximum_age pqp_pension_types_f.maximum_age%TYPE
122: ,effective_start_date pqp_pension_types_f.effective_start_date%TYPE
123: ,effective_end_date pqp_pension_types_f.effective_end_date%TYPE);
124:

Line 121: ,maximum_age pqp_pension_types_f.maximum_age%TYPE

117: pension_type_id pqp_pension_types_f.pension_type_id%TYPE
118: ,pension_type_name pqp_pension_types_f.pension_type_name%TYPE
119: ,pension_category pqp_pension_types_f.pension_category%TYPE
120: ,minimum_age pqp_pension_types_f.minimum_age%TYPE
121: ,maximum_age pqp_pension_types_f.maximum_age%TYPE
122: ,effective_start_date pqp_pension_types_f.effective_start_date%TYPE
123: ,effective_end_date pqp_pension_types_f.effective_end_date%TYPE);
124:
125: TYPE t_pension_types IS TABLE OF r_pension_types

Line 122: ,effective_start_date pqp_pension_types_f.effective_start_date%TYPE

118: ,pension_type_name pqp_pension_types_f.pension_type_name%TYPE
119: ,pension_category pqp_pension_types_f.pension_category%TYPE
120: ,minimum_age pqp_pension_types_f.minimum_age%TYPE
121: ,maximum_age pqp_pension_types_f.maximum_age%TYPE
122: ,effective_start_date pqp_pension_types_f.effective_start_date%TYPE
123: ,effective_end_date pqp_pension_types_f.effective_end_date%TYPE);
124:
125: TYPE t_pension_types IS TABLE OF r_pension_types
126: INDEX BY BINARY_INTEGER;

Line 123: ,effective_end_date pqp_pension_types_f.effective_end_date%TYPE);

119: ,pension_category pqp_pension_types_f.pension_category%TYPE
120: ,minimum_age pqp_pension_types_f.minimum_age%TYPE
121: ,maximum_age pqp_pension_types_f.maximum_age%TYPE
122: ,effective_start_date pqp_pension_types_f.effective_start_date%TYPE
123: ,effective_end_date pqp_pension_types_f.effective_end_date%TYPE);
124:
125: TYPE t_pension_types IS TABLE OF r_pension_types
126: INDEX BY BINARY_INTEGER;
127: