APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on PAY_BALANCE_TYPES

Line 137: ,ees_balance_name pay_balance_types.balance_name%TYPE

133: );
134:
135: TYPE r_pen_bal_dtls IS RECORD(
136: element_type_id NUMBER
137: ,ees_balance_name pay_balance_types.balance_name%TYPE
138: ,ees_bal_type_id NUMBER
139: ,ees_ptd_bal_id NUMBER
140: -- For 115.9
141: ,ees_ytd_bal_id NUMBER

Line 142: ,ers_balance_name pay_balance_types.balance_name%TYPE

138: ,ees_bal_type_id NUMBER
139: ,ees_ptd_bal_id NUMBER
140: -- For 115.9
141: ,ees_ytd_bal_id NUMBER
142: ,ers_balance_name pay_balance_types.balance_name%TYPE
143: ,ers_bal_type_id NUMBER
144: ,ers_ptd_bal_id NUMBER
145: -- For 115.9
146: ,ers_ytd_bal_id NUMBER

Line 148: /* ,add_balance_name pay_balance_types.balance_name%TYPE

144: ,ers_ptd_bal_id NUMBER
145: -- For 115.9
146: ,ers_ytd_bal_id NUMBER
147: -- Commenting the below variables as they are not used
148: /* ,add_balance_name pay_balance_types.balance_name%TYPE
149: ,add_bal_type_id NUMBER
150: ,add_ptd_bal_id NUMBER
151: ,ayr_balance_name pay_balance_types.balance_name%TYPE
152: ,ayr_bal_type_id NUMBER

Line 151: ,ayr_balance_name pay_balance_types.balance_name%TYPE

147: -- Commenting the below variables as they are not used
148: /* ,add_balance_name pay_balance_types.balance_name%TYPE
149: ,add_bal_type_id NUMBER
150: ,add_ptd_bal_id NUMBER
151: ,ayr_balance_name pay_balance_types.balance_name%TYPE
152: ,ayr_bal_type_id NUMBER
153: ,ayr_ptd_bal_id NUMBER
154: ,fwd_balance_name pay_balance_types.balance_name%TYPE
155: ,fwd_bal_type_id NUMBER

Line 154: ,fwd_balance_name pay_balance_types.balance_name%TYPE

150: ,add_ptd_bal_id NUMBER
151: ,ayr_balance_name pay_balance_types.balance_name%TYPE
152: ,ayr_bal_type_id NUMBER
153: ,ayr_ptd_bal_id NUMBER
154: ,fwd_balance_name pay_balance_types.balance_name%TYPE
155: ,fwd_bal_type_id NUMBER
156: ,fwd_ptd_bal_id NUMBER */
157: ,ayfwd_balance_name pay_balance_types.balance_name%TYPE
158: ,ayfwd_bal_type_id NUMBER

Line 157: ,ayfwd_balance_name pay_balance_types.balance_name%TYPE

153: ,ayr_ptd_bal_id NUMBER
154: ,fwd_balance_name pay_balance_types.balance_name%TYPE
155: ,fwd_bal_type_id NUMBER
156: ,fwd_ptd_bal_id NUMBER */
157: ,ayfwd_balance_name pay_balance_types.balance_name%TYPE
158: ,ayfwd_bal_type_id NUMBER
159: ,ayfwd_ptd_bal_id NUMBER
160: -- For 115.9
161: ,ayfwd_ytd_bal_id NUMBER

Line 163: /* ,ayfb_balance_name pay_balance_types.balance_name%TYPE

159: ,ayfwd_ptd_bal_id NUMBER
160: -- For 115.9
161: ,ayfwd_ytd_bal_id NUMBER
162: --For Bug 6082532 (Added Years Family Benefit)
163: /* ,ayfb_balance_name pay_balance_types.balance_name%TYPE
164: ,ayfb_bal_type_id NUMBER
165: ,ayfb_ptd_bal_id NUMBER */
166: --For Nuvos
167: ,nuvos_sa_balance_name pay_balance_types.balance_name%TYPE

Line 167: ,nuvos_sa_balance_name pay_balance_types.balance_name%TYPE

163: /* ,ayfb_balance_name pay_balance_types.balance_name%TYPE
164: ,ayfb_bal_type_id NUMBER
165: ,ayfb_ptd_bal_id NUMBER */
166: --For Nuvos
167: ,nuvos_sa_balance_name pay_balance_types.balance_name%TYPE
168: ,nuvos_sa_bal_type_id NUMBER
169: ,nuvos_sa_ptd_bal_id NUMBER
170: -- For 115.9
171: ,nuvos_sa_ytd_bal_id NUMBER

Line 174: ,extra_contrib_balance_name pay_balance_types.balance_name%TYPE

170: -- For 115.9
171: ,nuvos_sa_ytd_bal_id NUMBER
172:
173: -- For Classic Extra Contributions
174: ,extra_contrib_balance_name pay_balance_types.balance_name%TYPE
175: ,extra_contrib_bal_type_id NUMBER
176: ,extra_contrib_ptd_bal_id NUMBER
177: ,extra_contrib_ytd_bal_id NUMBER
178:

Line 182: balance_name pay_balance_types.balance_name%TYPE

178:
179: );
180:
181: TYPE r_ele_bal_dtls IS RECORD(
182: balance_name pay_balance_types.balance_name%TYPE
183: ,balance_type_id NUMBER
184: ,defined_balance_id NUMBER
185: ,pen_defined_balance_id NUMBER
186: );