APPS.PAY_NL_SI_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1517: ,PER_ASSIGNMENT_STATUS_TYPES past

1513: CURSOR csr_asg_dates (p_other_assignment_id NUMBER) IS
1514: SELECT MIN(asg.effective_start_date) asg_start_date
1515: ,MAX(asg.effective_end_date) asg_end_date
1516: FROM PER_ASSIGNMENTS_F asg
1517: ,PER_ASSIGNMENT_STATUS_TYPES past
1518: WHERE asg.assignment_id = p_other_assignment_id
1519: AND past.per_system_status = 'ACTIVE_ASSIGN'
1520: AND asg.assignment_status_type_id = past.assignment_status_type_id
1521: AND asg.effective_start_date <= p_period_end_date

Line 1543: PER_ASSIGNMENT_STATUS_TYPES past,

1539: CURSOR csr_person_dates IS
1540: SELECT MIN(asg.effective_start_date) per_start_date
1541: ,MAX(asg.effective_end_date) per_end_date
1542: FROM PER_ASSIGNMENTS_F asg,
1543: PER_ASSIGNMENT_STATUS_TYPES past,
1544: PAY_OBJECT_GROUPS pog
1545: WHERE asg.person_id in
1546: (select asg2.person_id from PER_ASSIGNMENTS_F asg2, PAY_OBJECT_GROUPS pog2
1547: where asg2.assignment_id = p_assignment_id

Line 1981: ,PER_ASSIGNMENT_STATUS_TYPES past

1977: CURSOR csr_asg_dates (p_other_assignment_id NUMBER) IS
1978: SELECT MIN(asg.effective_start_date) asg_start_date
1979: ,MAX(asg.effective_end_date) asg_end_date
1980: FROM PER_ASSIGNMENTS_F asg
1981: ,PER_ASSIGNMENT_STATUS_TYPES past
1982: WHERE asg.assignment_id = p_other_assignment_id
1983: AND past.per_system_status = 'ACTIVE_ASSIGN'
1984: AND asg.assignment_status_type_id = past.assignment_status_type_id
1985: AND asg.effective_start_date <= p_period_end_date

Line 2008: PER_ASSIGNMENT_STATUS_TYPES past,

2004: CURSOR csr_person_dates IS
2005: SELECT MIN(asg.effective_start_date) per_start_date
2006: ,MAX(asg.effective_end_date) per_end_date
2007: FROM PER_ASSIGNMENTS_F asg,
2008: PER_ASSIGNMENT_STATUS_TYPES past,
2009: PAY_OBJECT_GROUPS pog
2010: WHERE asg.person_id in
2011: (select asg2.person_id from PER_ASSIGNMENTS_F asg2, PAY_OBJECT_GROUPS pog2
2012: where asg2.assignment_id = p_assignment_id