DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_API dependencies on PER_TIME_PERIODS

Line 1631: from per_time_periods tpe

1627: and ast.per_system_status = 'TERM_CWK_ASG';
1628: --
1629: cursor csr_get_period_end_date is
1630: select tpe.end_date
1631: from per_time_periods tpe
1632: where tpe.payroll_id = l_payroll_id
1633: and l_actual_termination_date between tpe.start_date
1634: and tpe.end_date;
1635: --

Line 2541: from per_time_periods tpe

2537: and ast.per_system_status = 'TERM_ASSIGN';
2538: --
2539: cursor csr_get_period_end_date is
2540: select tpe.end_date
2541: from per_time_periods tpe
2542: where tpe.payroll_id = l_payroll_id
2543: and l_actual_termination_date between tpe.start_date
2544: and tpe.end_date;
2545: --