DBA Data[Home] [Help]

APPS.PAY_US_OVER_LIMIT_PKG dependencies on PER_ALL_PEOPLE_F

Line 231: ,p_person_id IN per_all_people_f.person_id%type

227:
228: procedure insert_action(pactid IN number
229: ,chunk IN number
230: ,p_greid IN number
231: ,p_person_id IN per_all_people_f.person_id%type
232: ,p_assignid IN number
233: ) is
234:
235: -- Cursor to get the assignment actions

Line 488: per_all_people_f ppf,

484: 'SELECT paa.rowid
485: FROM pay_payroll_actions ppa,
486: pay_assignment_actions paa,
487: per_all_assignments_f paf,
488: per_all_people_f ppf,
489: hr_organization_units hou,
490: hr_locations_all hl
491: WHERE ppa.payroll_action_id = :pactid
492: AND paa.payroll_action_id = ppa.payroll_action_id