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 PAY_OBJECT_GROUPS

Line 1528: ,pay_object_groups pog1

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
1532: AND asg1.assignment_id <> p_assignment_id

Line 1529: ,pay_object_groups pog2

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
1532: AND asg1.assignment_id <> p_assignment_id
1533: AND pog1.source_id = asg1.assignment_id

Line 1544: PAY_OBJECT_GROUPS pog

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
1548: and pog2.source_id = asg2.assignment_id

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 1992: ,pay_object_groups pog1

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
1996: AND asg1.assignment_id <> p_assignment_id

Line 1993: ,pay_object_groups pog2

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
1996: AND asg1.assignment_id <> p_assignment_id
1997: AND pog1.source_id = asg1.assignment_id

Line 2009: PAY_OBJECT_GROUPS pog

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
2013: and pog2.source_id = asg2.assignment_id

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)