DBA Data[Home] [Help]

APPS.PQP_ALIEN_EXPAT_TAXATION_PKG dependencies on PER_TIME_PERIOD_TYPES

Line 3363: ,per_time_period_types ptt

3359: ,p_effective_date in date ) is
3360: select min(trunc((52/ number_per_fiscal_year) * 7)) days_in_cycle
3361: from per_time_periods ptp
3362: ,per_assignments_f paf
3363: ,per_time_period_types ptt
3364: where ptp.payroll_id = paf.payroll_id
3365: and ptp.period_type = ptt.period_type
3366: and paf.person_id = p_person_id
3367: and paf.effective_start_date <= p_effective_date;