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

1507: CURSOR csr_any_other_asg IS
1508: SELECT DISTINCT asg1.assignment_id asgid
1509: FROM per_assignments_f asg1
1510: ,per_assignments_f asg2
1511: ,pay_object_groups pog1
1512: ,pay_object_groups pog2
1513: WHERE asg1.person_id = asg2.person_id
1514: AND asg2.assignment_id = p_assignment_id
1515: AND asg1.assignment_id <> p_assignment_id

Line 1512: ,pay_object_groups pog2

1508: SELECT DISTINCT asg1.assignment_id asgid
1509: FROM per_assignments_f asg1
1510: ,per_assignments_f asg2
1511: ,pay_object_groups pog1
1512: ,pay_object_groups pog2
1513: WHERE asg1.person_id = asg2.person_id
1514: AND asg2.assignment_id = p_assignment_id
1515: AND asg1.assignment_id <> p_assignment_id
1516: AND pog1.source_id = asg1.assignment_id

Line 1527: PAY_OBJECT_GROUPS pog

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

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

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
1531: and pog2.source_id = asg2.assignment_id
1532: and pog2.source_type = 'PAF'
1533: and pog.parent_object_group_id = pog2.parent_object_group_id)

Line 1939: ,pay_object_groups pog1

1935: CURSOR csr_any_other_asg IS
1936: SELECT DISTINCT asg1.assignment_id asgid
1937: FROM per_assignments_f asg1
1938: ,per_assignments_f asg2
1939: ,pay_object_groups pog1
1940: ,pay_object_groups pog2
1941: WHERE asg1.person_id = asg2.person_id
1942: AND asg2.assignment_id = p_assignment_id
1943: AND asg1.assignment_id <> p_assignment_id

Line 1940: ,pay_object_groups pog2

1936: SELECT DISTINCT asg1.assignment_id asgid
1937: FROM per_assignments_f asg1
1938: ,per_assignments_f asg2
1939: ,pay_object_groups pog1
1940: ,pay_object_groups pog2
1941: WHERE asg1.person_id = asg2.person_id
1942: AND asg2.assignment_id = p_assignment_id
1943: AND asg1.assignment_id <> p_assignment_id
1944: AND pog1.source_id = asg1.assignment_id

Line 1956: PAY_OBJECT_GROUPS pog

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

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

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
1960: and pog2.source_id = asg2.assignment_id
1961: and pog2.source_type = 'PAF'
1962: and pog.parent_object_group_id = pog2.parent_object_group_id)