APPS.PAY_GB_STUDENT_LOANS_PKG dependencies on HR_GBBAL

Line 161: p_ptd_balance := NVL(hr_gbbal.calc_element_ptd_bal(

157: p_ptd_balance := NULL;
158: close c_ptd_asgact;
159: else
160: if l_name = 'Court Order' then
161: p_ptd_balance := NVL(hr_gbbal.calc_element_ptd_bal(
162: l_ptd_action_id,
163: l_balance_type_id,
164: l_ptd_source_id),0.00);
165: elsif l_name = 'Student Loan' then

Line 166: p_ptd_balance := NVL(hr_gbbal.calc_asg_tfr_ptd_action(

162: l_ptd_action_id,
163: l_balance_type_id,
164: l_ptd_source_id),0.00);
165: elsif l_name = 'Student Loan' then
166: p_ptd_balance := NVL(hr_gbbal.calc_asg_tfr_ptd_action(
167: l_ptd_action_id,
168: l_balance_type_id,
169: NULL),0.00);
170: elsif l_name = 'CAO Scotland Payments CMA' then

Line 171: p_ptd_balance := NVL(hr_gbbal.calc_asg_proc_ptd_action(

167: l_ptd_action_id,
168: l_balance_type_id,
169: NULL),0.00);
170: elsif l_name = 'CAO Scotland Payments CMA' then
171: p_ptd_balance := NVL(hr_gbbal.calc_asg_proc_ptd_action(
172: l_ptd_action_id,
173: l_balance_type_id,
174: NULL),0.00) +
175: NVL(hr_gbbal.calc_asg_proc_ptd_action(

Line 175: NVL(hr_gbbal.calc_asg_proc_ptd_action(

171: p_ptd_balance := NVL(hr_gbbal.calc_asg_proc_ptd_action(
172: l_ptd_action_id,
173: l_balance_type_id,
174: NULL),0.00) +
175: NVL(hr_gbbal.calc_asg_proc_ptd_action(
176: l_ptd_action_id,
177: l_balance_type_id2,
178: NULL),0.00);
179: else

Line 180: p_ptd_balance := NVL(hr_gbbal.calc_asg_proc_ptd_action(

176: l_ptd_action_id,
177: l_balance_type_id2,
178: NULL),0.00);
179: else
180: p_ptd_balance := NVL(hr_gbbal.calc_asg_proc_ptd_action(
181: l_ptd_action_id,
182: l_balance_type_id,
183: NULL),0.00);
184: end if;

Line 197: p_itd_balance := NVL(hr_gbbal.calc_element_itd_bal(

193: p_itd_balance := NULL;
194: close c_itd_asgact;
195: else
196: if l_name = 'Court Order' then
197: p_itd_balance := NVL(hr_gbbal.calc_element_itd_bal(
198: l_itd_action_id,
199: l_balance_type_id,
200: l_itd_source_id),0.00);
201: elsif l_name = 'Student Loan' then

Line 206: p_itd_balance := NVL(hr_gbbal.calc_asg_td_ytd_action(

202:
203: /* Use the same variables, even though they are really for itd,
204: and let the balance retrieval code handle the expiration */
205:
206: p_itd_balance := NVL(hr_gbbal.calc_asg_td_ytd_action(
207: l_itd_action_id,
208: l_balance_type_id,
209: NULL),0.00);
210: else