DBA Data[Home] [Help]

APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on PER_ORGANIZATION_UNITS

Line 994: from per_organization_units pou,

990: decode(pou.frequency, 'Y', 1,
991: 'M', 12,
992: 'W', 52,
993: 'D', 365, 1)
994: from per_organization_units pou,
995: per_assignments_f paf
996: where paf.assignment_id = cp_assignment_id
997: and cp_period_end_date between paf.effective_start_date
998: and paf.effective_end_date