[Home] [Help]
328: 'Y', add_months(p.date_start,(12 * l_qualifying_los)),
329: 'W', p.date_start + (l_qualifying_los * 7),
330: add_months(p.date_start,l_qualifying_los))
331: from per_periods_of_service p,
332: per_all_assignments_f a
333: where a.assignment_id = p_assignment_id
334: and p.period_of_service_id = a.period_of_service_id;
335: --
336: cursor csr_age_date is
1390: -- rule date occurs...
1391: --
1392: select ptp.end_date
1393: into v_element_term_rule_date
1394: from per_all_assignments_f asg,
1395: per_time_periods ptp
1396: where asg.assignment_id = p_assignment_id
1397: and p_session_date between asg.effective_start_date and asg.effective_end_date
1398: and asg.payroll_id = ptp.payroll_id
1636: max(pay.effective_end_date)
1637: into v_payroll_start_date,
1638: v_payroll_end_date
1639: from pay_all_payrolls_f pay,
1640: per_all_assignments_f asg
1641: where p_session_date
1642: between asg.effective_start_date
1643: and asg.effective_end_date
1644: and asg.assignment_id = p_assignment_id
2872: -- Need assignment type for comparison purposes
2873: --
2874: select asg.assignment_type, asg.assignment_number
2875: into v_assignment_type, v_assignment_number
2876: from per_all_assignments_f asg
2877: where asg.assignment_id = p_assignment_id
2878: and p_session_date between asg.effective_start_date
2879: and asg.effective_end_date;
2880: --
3039: ,p_datetrack_mode => 'INSERT' --*
3040: ,p_base_table_name => 'pay_element_entries_f'
3041: ,p_base_key_column => 'element_entry_id'
3042: ,p_base_key_value => p_element_entry_id --*
3043: ,p_parent_table_name1 => 'per_all_assignments_f'
3044: ,p_parent_key_column1 => 'assignment_id'
3045: ,p_parent_key_value1 => p_assignment_id
3046: ,p_enforce_foreign_locking => true
3047: ,p_validation_start_date => l_validation_start_date