DBA Data[Home] [Help]

APPS.HR_NZBAL dependencies on PER_TIME_PERIOD_TYPES

Line 703: , per_time_period_types TPTYPE

699: cursor get_pay_period_start_date(p_assignment_id in number) is
700: SELECT TPERIOD.start_date FROM
701: pay_payroll_actions PACTION
702: , per_time_periods TPERIOD
703: , per_time_period_types TPTYPE
704: where PACTION.payroll_action_id = (select max(paa.payroll_action_id)
705: from pay_assignment_actions paa,pay_payroll_actions ppa
706: where paa.assignment_id=p_assignment_id
707: and ppa.action_type in ('R','Q')