DBA Data[Home] [Help]

APPS.HR_ELEMENTS dependencies on PER_TIME_PERIOD_TYPES

Line 1663: FROM per_time_period_types TPT,

1659: AND payroll_id = p_payroll_id;
1660:
1661: SELECT TPT.number_per_fiscal_year
1662: INTO v_number_per_fy
1663: FROM per_time_period_types TPT,
1664: pay_payrolls_f PRL
1665: WHERE TPT.period_type = PRL.period_type
1666: AND PRL.business_group_id + 0 = p_bg_id
1667: AND p_passed_date BETWEEN prl.effective_start_date and prl.effective_end_date