APPS.PAY_GB_REP dependencies on HR_GBBAL

Line 34: -- hr_gbbal.calc_all_balances(fnd_date.canonical_to_date(p_effective_date), paf.assignment_id, p_def_bal_id ) ni_arrears

30: use_index(ppt, PER_PERSON_TYPES_N1) */
31: paf.assignment_number,
32: ppf.full_name,
33: paf.assignment_id
34: -- hr_gbbal.calc_all_balances(fnd_date.canonical_to_date(p_effective_date), paf.assignment_id, p_def_bal_id ) ni_arrears
35: from per_all_people_f ppf,
36: per_person_types ppt,
37: per_all_assignments_f paf,
38: pay_all_payrolls_f papf

Line 53: -- and hr_gbbal.calc_all_balances(fnd_date.canonical_to_date(p_effective_date), paf.assignment_id, p_def_bal_id) > 0

49: and fnd_date.canonical_to_date(p_effective_date) between papf.effective_start_date and papf.effective_end_date
50: and ppf.effective_end_date between paf.effective_start_date and paf.effective_end_date
51: and ppt.person_type_id = ppf.person_type_id
52: and paf.person_id = ppf.person_id
53: -- and hr_gbbal.calc_all_balances(fnd_date.canonical_to_date(p_effective_date), paf.assignment_id, p_def_bal_id) > 0
54: order by assignment_number;
55:
56: l_total_arrears number;
57: l_ni_arrears number;

Line 79: l_ni_arrears := nvl(hr_gbbal.calc_all_balances(fnd_date.canonical_to_date(p_effective_date),

75: fnd_file.put_line(fnd_file.output,rpad('-',15,'-') || ' ' || rpad('-',35,'-') || ' ' || rpad('-',15,'-'));
76: l_total_arrears := 0;
77:
78: for l_body in body_details loop
79: l_ni_arrears := nvl(hr_gbbal.calc_all_balances(fnd_date.canonical_to_date(p_effective_date),
80: l_body.assignment_id,
81: p_def_bal_id),0);
82: if (l_ni_arrears > 0) then
83: fnd_file.put_line(fnd_file.output,rpad(l_body.assignment_number,15,' ') || ' ' || rpad(l_body.full_name,35,' ') ||