DBA Data[Home] [Help]

APPS.PER_PERRPFP2_XMLP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 370: per_all_assignments_f pa

366: begin
367: select count(*)
368: into v_detailcount
369: from per_secondary_ass_statuses ast,
370: per_all_assignments_f pa
371: where ast.assignment_id = pa.assignment_id
372: and pa.person_id = p_person_id
373: and pa.business_group_id = p_business_group_id;
374:

Line 384: per_all_assignments_f pa

380: begin
381: select count(*)
382: into v_detailcount
383: from per_events pe,
384: per_all_assignments_f pa
385: where pe.event_or_interview = 'I'
386: and pa.person_id = p_person_id
387: and pa.business_group_id = p_business_group_id
388: and pa.assignment_id = pe.assignment_id;