APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on PAY_BALANCE_TYPES

Line 124: ,ees_balance_name pay_balance_types.balance_name%TYPE

120: );
121:
122: TYPE r_pen_bal_dtls IS RECORD(
123: element_type_id NUMBER
124: ,ees_balance_name pay_balance_types.balance_name%TYPE
125: ,ees_bal_type_id NUMBER
126: ,ees_ptd_bal_id NUMBER
127: -- For 115.9
128: ,ees_ytd_bal_id NUMBER

Line 129: ,ers_balance_name pay_balance_types.balance_name%TYPE

125: ,ees_bal_type_id NUMBER
126: ,ees_ptd_bal_id NUMBER
127: -- For 115.9
128: ,ees_ytd_bal_id NUMBER
129: ,ers_balance_name pay_balance_types.balance_name%TYPE
130: ,ers_bal_type_id NUMBER
131: ,ers_ptd_bal_id NUMBER
132: -- For 115.9
133: ,ers_ytd_bal_id NUMBER

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

131: ,ers_ptd_bal_id NUMBER
132: -- For 115.9
133: ,ers_ytd_bal_id NUMBER
134: -- Commenting the below variables as they are not used
135: /* ,add_balance_name pay_balance_types.balance_name%TYPE
136: ,add_bal_type_id NUMBER
137: ,add_ptd_bal_id NUMBER
138: ,ayr_balance_name pay_balance_types.balance_name%TYPE
139: ,ayr_bal_type_id NUMBER

Line 138: ,ayr_balance_name pay_balance_types.balance_name%TYPE

134: -- Commenting the below variables as they are not used
135: /* ,add_balance_name pay_balance_types.balance_name%TYPE
136: ,add_bal_type_id NUMBER
137: ,add_ptd_bal_id NUMBER
138: ,ayr_balance_name pay_balance_types.balance_name%TYPE
139: ,ayr_bal_type_id NUMBER
140: ,ayr_ptd_bal_id NUMBER
141: ,fwd_balance_name pay_balance_types.balance_name%TYPE
142: ,fwd_bal_type_id NUMBER

Line 141: ,fwd_balance_name pay_balance_types.balance_name%TYPE

137: ,add_ptd_bal_id NUMBER
138: ,ayr_balance_name pay_balance_types.balance_name%TYPE
139: ,ayr_bal_type_id NUMBER
140: ,ayr_ptd_bal_id NUMBER
141: ,fwd_balance_name pay_balance_types.balance_name%TYPE
142: ,fwd_bal_type_id NUMBER
143: ,fwd_ptd_bal_id NUMBER */
144: ,ayfwd_balance_name pay_balance_types.balance_name%TYPE
145: ,ayfwd_bal_type_id NUMBER

Line 144: ,ayfwd_balance_name pay_balance_types.balance_name%TYPE

140: ,ayr_ptd_bal_id NUMBER
141: ,fwd_balance_name pay_balance_types.balance_name%TYPE
142: ,fwd_bal_type_id NUMBER
143: ,fwd_ptd_bal_id NUMBER */
144: ,ayfwd_balance_name pay_balance_types.balance_name%TYPE
145: ,ayfwd_bal_type_id NUMBER
146: ,ayfwd_ptd_bal_id NUMBER
147: -- For 115.9
148: ,ayfwd_ytd_bal_id NUMBER

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

146: ,ayfwd_ptd_bal_id NUMBER
147: -- For 115.9
148: ,ayfwd_ytd_bal_id NUMBER
149: --For Bug 6082532 (Added Years Family Benefit)
150: /* ,ayfb_balance_name pay_balance_types.balance_name%TYPE
151: ,ayfb_bal_type_id NUMBER
152: ,ayfb_ptd_bal_id NUMBER */
153: --For Nuvos
154: ,nuvos_sa_balance_name pay_balance_types.balance_name%TYPE

Line 154: ,nuvos_sa_balance_name pay_balance_types.balance_name%TYPE

150: /* ,ayfb_balance_name pay_balance_types.balance_name%TYPE
151: ,ayfb_bal_type_id NUMBER
152: ,ayfb_ptd_bal_id NUMBER */
153: --For Nuvos
154: ,nuvos_sa_balance_name pay_balance_types.balance_name%TYPE
155: ,nuvos_sa_bal_type_id NUMBER
156: ,nuvos_sa_ptd_bal_id NUMBER
157: -- For 115.9
158: ,nuvos_sa_ytd_bal_id NUMBER

Line 163: balance_name pay_balance_types.balance_name%TYPE

159:
160: );
161:
162: TYPE r_ele_bal_dtls IS RECORD(
163: balance_name pay_balance_types.balance_name%TYPE
164: ,balance_type_id NUMBER
165: ,defined_balance_id NUMBER
166: ,pen_defined_balance_id NUMBER
167: );