DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_API dependencies on PER_TIME_PERIODS

Line 2192: from per_time_periods tpe

2188: and ast.per_system_status = 'TERM_CWK_ASG';
2189: --
2190: cursor csr_get_period_end_date is
2191: select tpe.end_date
2192: from per_time_periods tpe
2193: where tpe.payroll_id = l_payroll_id
2194: and l_actual_termination_date between tpe.start_date
2195: and tpe.end_date;
2196: --

Line 3108: from per_time_periods tpe

3104: and ast.per_system_status = 'TERM_ASSIGN';
3105: --
3106: cursor csr_get_period_end_date is
3107: select tpe.end_date
3108: from per_time_periods tpe
3109: where tpe.payroll_id = l_payroll_id
3110: and l_actual_termination_date between tpe.start_date
3111: and tpe.end_date;
3112: --