DBA Data[Home] [Help]

APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 1010: FROM per_all_people_f ppf,

1006:
1007: CURSOR csr_get_agg_info(p_assignment_id IN NUMBER)
1008: IS
1009: SELECT per_information10
1010: FROM per_all_people_f ppf,
1011: per_all_assignments_f paf
1012: WHERE paf.assignment_id = p_assignment_id
1013: and ppf.person_id = paf.person_id
1014: and p_effective_date between

Line 1699: FROM per_all_people_f ppf,

1695: -- The Payroll ID was used as parameter, so restrict by this
1696: --
1697: hr_utility.trace('Range Cursor using Payroll Restriction');
1698: sqlstr := 'SELECT DISTINCT ppf.person_id
1699: FROM per_all_people_f ppf,
1700: pay_payroll_actions ppa,
1701: per_all_assignments_f paaf
1702: WHERE ppa.payroll_action_id = :payroll_action_id
1703: AND ppf.business_group_id +0 = ppa.business_group_id