DBA Data[Home] [Help]

APPS.PAY_NO_SAL_STATISTICS_ARCHIVE dependencies on PER_PERSON_TYPES

Line 508: per_person_types ppt

504: paa.payroll_id
505: FROM per_all_assignments_f paa,
506: per_all_people_f pap,
507: HR_SOFT_CODING_KEYFLEX hsc,
508: per_person_types ppt
509: WHERE pap.person_id BETWEEN p_start_person AND p_end_person
510: AND pap.effective_start_date <= p_report_date
511: AND pap.effective_end_date >= trunc(p_report_date,'Y')
512: AND ppt.system_person_type like 'EMP%'