APPS.PAY_NL_SI_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1500: ,PER_ASSIGNMENT_STATUS_TYPES past

1496: CURSOR csr_asg_dates (p_other_assignment_id NUMBER) IS
1497: SELECT MIN(asg.effective_start_date) asg_start_date
1498: ,MAX(asg.effective_end_date) asg_end_date
1499: FROM PER_ASSIGNMENTS_F asg
1500: ,PER_ASSIGNMENT_STATUS_TYPES past
1501: WHERE asg.assignment_id = p_other_assignment_id
1502: AND past.per_system_status = 'ACTIVE_ASSIGN'
1503: AND asg.assignment_status_type_id = past.assignment_status_type_id
1504: AND asg.effective_start_date <= p_period_end_date

Line 1526: PER_ASSIGNMENT_STATUS_TYPES past,

1522: CURSOR csr_person_dates IS
1523: SELECT MIN(asg.effective_start_date) per_start_date
1524: ,MAX(asg.effective_end_date) per_end_date
1525: FROM PER_ASSIGNMENTS_F asg,
1526: PER_ASSIGNMENT_STATUS_TYPES past,
1527: PAY_OBJECT_GROUPS pog
1528: WHERE asg.person_id in
1529: (select asg2.person_id from PER_ASSIGNMENTS_F asg2, PAY_OBJECT_GROUPS pog2
1530: where asg2.assignment_id = p_assignment_id

Line 1928: ,PER_ASSIGNMENT_STATUS_TYPES past

1924: CURSOR csr_asg_dates (p_other_assignment_id NUMBER) IS
1925: SELECT MIN(asg.effective_start_date) asg_start_date
1926: ,MAX(asg.effective_end_date) asg_end_date
1927: FROM PER_ASSIGNMENTS_F asg
1928: ,PER_ASSIGNMENT_STATUS_TYPES past
1929: WHERE asg.assignment_id = p_other_assignment_id
1930: AND past.per_system_status = 'ACTIVE_ASSIGN'
1931: AND asg.assignment_status_type_id = past.assignment_status_type_id
1932: AND asg.effective_start_date <= p_period_end_date

Line 1955: PER_ASSIGNMENT_STATUS_TYPES past,

1951: CURSOR csr_person_dates IS
1952: SELECT MIN(asg.effective_start_date) per_start_date
1953: ,MAX(asg.effective_end_date) per_end_date
1954: FROM PER_ASSIGNMENTS_F asg,
1955: PER_ASSIGNMENT_STATUS_TYPES past,
1956: PAY_OBJECT_GROUPS pog
1957: WHERE asg.person_id in
1958: (select asg2.person_id from PER_ASSIGNMENTS_F asg2, PAY_OBJECT_GROUPS pog2
1959: where asg2.assignment_id = p_assignment_id