APPS.PAY_GB_REP dependencies on FND_DATE

Line 17: fnd_date.canonical_to_date(p_effective_date),

13:
14: cursor header_details is
15: select distinct
16: pbg.name,
17: fnd_date.canonical_to_date(p_effective_date),
18: decode(p_payroll_id,null, ' ',papf.payroll_id, papf.payroll_name)
19: from per_business_groups pbg,
20: pay_all_payrolls_f papf
21: where pbg.business_group_id = p_business_group_id

Line 24: and fnd_date.canonical_to_date(p_effective_date) between

20: pay_all_payrolls_f papf
21: where pbg.business_group_id = p_business_group_id
22: and pbg.business_group_id = papf.business_group_id
23: and papf.payroll_id = nvl(to_number(p_payroll_id),papf.payroll_id)
24: and fnd_date.canonical_to_date(p_effective_date) between
25: papf.effective_start_date and papf.effective_end_date;
26:
27: cursor body_details is
28: select /*+ ORDERED

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 48: and fnd_date.canonical_to_date(p_effective_date) between ppf.effective_start_date and ppf.effective_end_date

44: or
45: papf.payroll_id = p_payroll_id)
46: and papf.payroll_id = paf.payroll_id
47: and ppt.system_person_type = 'EMP'
48: and fnd_date.canonical_to_date(p_effective_date) between ppf.effective_start_date and ppf.effective_end_date
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

Line 49: and fnd_date.canonical_to_date(p_effective_date) between papf.effective_start_date and papf.effective_end_date

45: papf.payroll_id = p_payroll_id)
46: and papf.payroll_id = paf.payroll_id
47: and ppt.system_person_type = 'EMP'
48: and fnd_date.canonical_to_date(p_effective_date) between ppf.effective_start_date and ppf.effective_end_date
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

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,' ') ||

Line 105: fnd_date.canonical_to_date(c_effective_date),

101: cursor csr_header_details(c_business_group_id NUMBER,
102: c_payroll_id NUMBER,
103: c_effective_date VARCHAR2) is
104: select pbg.name,
105: fnd_date.canonical_to_date(c_effective_date),
106: decode(c_payroll_id,null, ' ',papf.payroll_id, papf.payroll_name)
107: from per_business_groups pbg,
108: pay_all_payrolls_f papf
109: where pbg.business_group_id = c_business_group_id

Line 112: and fnd_date.canonical_to_date(c_effective_date) between

108: pay_all_payrolls_f papf
109: where pbg.business_group_id = c_business_group_id
110: and pbg.business_group_id = papf.business_group_id
111: and papf.payroll_id = nvl(to_number(c_payroll_id),papf.payroll_id)
112: and fnd_date.canonical_to_date(c_effective_date) between
113: papf.effective_start_date and papf.effective_end_date;
114:
115: cursor csr_payroll_details(c_business_group_id NUMBER,
116: c_payroll_id NUMBER,

Line 183: l_effective_date := fnd_date.canonical_to_date(p_effective_date);

179: BEGIN
180: --
181: -- conveting the paramter value to date, effective date
182: --
183: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
184:
185: OPEN csr_header_details(p_business_group_id, p_payroll_id, p_effective_date);
186: FETCH csr_header_details into l_bg_name, l_date, l_payroll_name;
187: CLOSE csr_header_details;