eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_SI_PKG dependencies on PER_ASSIGNMENTS_F

Line 1516: FROM PER_ASSIGNMENTS_F asg

1512: RETURN NUMBER IS
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

Line 1526: FROM per_assignments_f asg1

1522: AND NVL(asg.effective_end_date,p_period_end_date) >= p_period_start_date;
1523:
1524: CURSOR csr_any_other_asg IS
1525: SELECT DISTINCT asg1.assignment_id asgid
1526: FROM per_assignments_f asg1
1527: ,per_assignments_f asg2
1528: ,pay_object_groups pog1
1529: ,pay_object_groups pog2
1530: WHERE asg1.person_id = asg2.person_id

Line 1527: ,per_assignments_f asg2

1523:
1524: CURSOR csr_any_other_asg IS
1525: SELECT DISTINCT asg1.assignment_id asgid
1526: FROM per_assignments_f asg1
1527: ,per_assignments_f asg2
1528: ,pay_object_groups pog1
1529: ,pay_object_groups pog2
1530: WHERE asg1.person_id = asg2.person_id
1531: AND asg2.assignment_id = p_assignment_id

Line 1542: FROM PER_ASSIGNMENTS_F asg,

1538:
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

Line 1546: (select asg2.person_id from PER_ASSIGNMENTS_F asg2, PAY_OBJECT_GROUPS pog2

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
1548: and pog2.source_id = asg2.assignment_id
1549: and pog2.source_type = 'PAF'
1550: and pog.parent_object_group_id = pog2.parent_object_group_id)

Line 1980: FROM PER_ASSIGNMENTS_F asg

1976: RETURN NUMBER IS
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

Line 1990: FROM per_assignments_f asg1

1986: AND NVL(asg.effective_end_date,p_period_end_date) >= p_period_start_date;
1987:
1988: CURSOR csr_any_other_asg IS
1989: SELECT DISTINCT asg1.assignment_id asgid
1990: FROM per_assignments_f asg1
1991: ,per_assignments_f asg2
1992: ,pay_object_groups pog1
1993: ,pay_object_groups pog2
1994: WHERE asg1.person_id = asg2.person_id

Line 1991: ,per_assignments_f asg2

1987:
1988: CURSOR csr_any_other_asg IS
1989: SELECT DISTINCT asg1.assignment_id asgid
1990: FROM per_assignments_f asg1
1991: ,per_assignments_f asg2
1992: ,pay_object_groups pog1
1993: ,pay_object_groups pog2
1994: WHERE asg1.person_id = asg2.person_id
1995: AND asg2.assignment_id = p_assignment_id

Line 2007: FROM PER_ASSIGNMENTS_F asg,

2003:
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

Line 2011: (select asg2.person_id from PER_ASSIGNMENTS_F asg2, PAY_OBJECT_GROUPS pog2

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
2013: and pog2.source_id = asg2.assignment_id
2014: and pog2.source_type = 'PAF'
2015: and pog.parent_object_group_id = pog2.parent_object_group_id)