DBA Data[Home] [Help]

APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 1077: FROM per_all_people_f ppf,

1073:
1074: CURSOR csr_get_agg_info(p_assignment_id IN NUMBER)
1075: IS
1076: SELECT per_information10
1077: FROM per_all_people_f ppf,
1078: per_all_assignments_f paf
1079: WHERE paf.assignment_id = p_assignment_id
1080: and ppf.person_id = paf.person_id
1081: and p_effective_date between

Line 1766: FROM per_all_people_f ppf,

1762: -- The Payroll ID was used as parameter, so restrict by this
1763: --
1764: hr_utility.trace('Range Cursor using Payroll Restriction');
1765: sqlstr := 'SELECT DISTINCT ppf.person_id
1766: FROM per_all_people_f ppf,
1767: pay_payroll_actions ppa,
1768: per_all_assignments_f paaf
1769: WHERE ppa.payroll_action_id = :payroll_action_id
1770: AND ppf.business_group_id +0 = ppa.business_group_id