DBA Data[Home] [Help]

APPS.HR_PROCESS_PERSON_SS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1814: per_assignment_status_types pas

1810: cursor check_payroll is
1811: select asg.assignment_id,
1812: asg.payroll_id, asg.soft_coding_keyflex_id
1813: from per_all_assignments_f asg,
1814: per_assignment_status_types pas
1815: where asg.assignment_status_type_id = pas.assignment_status_type_id
1816: and asg.person_id = p_person_id
1817: and p_effective_date between asg.effective_start_date
1818: and asg.effective_end_date

Line 5631: per_assignment_status_types pas

5627: cursor check_payroll is
5628: select asg.assignment_id,
5629: asg.payroll_id, asg.soft_coding_keyflex_id
5630: from per_all_assignments_f asg,
5631: per_assignment_status_types pas
5632: where asg.assignment_status_type_id = pas.assignment_status_type_id
5633: and asg.person_id = l_person_id
5634: and l_effective_date between asg.effective_start_date
5635: and asg.effective_end_date