DBA Data[Home] [Help]

APPS.PAY_KR_PAYKRYRS_PKG dependencies on PER_PEOPLE_F

Line 316: from per_people_f per,

312: ------------------------------------------------------------------------------------
313: cursor csr_house_holder(p_assignment_id number,p_effective_date date) is
314: select
315: nvl(pei.pei_information3,'N') house_holder_flag
316: from per_people_f per,
317: per_assignments_f asg,
318: per_people_extra_info pei
319: where asg.assignment_id = p_assignment_id
320: and p_effective_date

Line 411: from per_people_f per,

407: select
408: per.person_id, -- bug 6012258
409: pds.date_start,
410: pds.actual_termination_date
411: from per_people_f per,
412: per_periods_of_service pds,
413: per_assignments_f asg
414: where
415: asg.assignment_id = p_assignment_id