DBA Data[Home] [Help]

APPS.PAY_JP_ITAX_ARCHIVE_PKG dependencies on PER_ALL_PEOPLE_F

Line 154: per_all_people_f per

150: --
151: p_sqlstr :=
152: 'SELECT DISTINCT per.person_id
153: FROM pay_payroll_actions ppa,
154: per_all_people_f per
155: WHERE ppa.payroll_action_id = :payroll_action_id
156: AND per.business_group_id + 0 = ppa.business_group_id
157: ORDER BY per.person_id';
158: --

Line 526: per_all_people_f per,

522: decode(adrr.address_id, null, adrc.country, adrr.country) country,
523: decode(adrr.address_id, null, adrc.town_or_city, adrr.town_or_city) district_code,
524: asg.organization_id
525: from per_all_assignments_f asg,
526: per_all_people_f per,
527: per_addresses adrr,
528: per_addresses adrc
529: where asg.assignment_id = cp_assignment_id
530: and cp_effective_date