APPS.PAY_GB_REP dependencies on PAY_ALL_PAYROLLS_F

Line 20: pay_all_payrolls_f papf

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
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

Line 38: pay_all_payrolls_f papf

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
39: where ppf.business_group_id = p_business_group_id
40: and papf.business_group_id = p_business_group_id
41: and ppt.business_group_id = p_business_group_id
42: --and papf.payroll_id = nvl(p_payroll_id,papf.payroll_id)

Line 108: pay_all_payrolls_f papf

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
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

Line 122: pay_all_payrolls_f papf

118: select distinct
119: papf.payroll_id,
120: papf.payroll_name
121: from per_business_groups pbg,
122: pay_all_payrolls_f papf
123: where pbg.business_group_id = c_business_group_id
124: and pbg.business_group_id = papf.business_group_id
125: and papf.payroll_id = nvl(to_number(c_payroll_id),papf.payroll_id)
126: and c_effective_date between