DBA Data[Home] [Help]

APPS.PAY_GB_REP dependencies on PER_ALL_PEOPLE_F

Line 35: from per_all_people_f ppf,

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
39: where ppf.business_group_id = p_business_group_id

Line 136: from per_all_people_f ppf,

132: c_effective_date DATE) is
133: select paf.assignment_number,
134: ppf.full_name,
135: paf.assignment_id
136: from per_all_people_f ppf,
137: per_all_assignments_f paf,
138: per_assignment_status_types past
139: where paf.assignment_status_type_id = past.assignment_status_type_id
140: and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')