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;