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 1499: FROM PER_ASSIGNMENTS_F asg

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

Line 1509: FROM per_assignments_f asg1

1505: AND NVL(asg.effective_end_date,p_period_end_date) >= p_period_start_date;
1506:
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

Line 1510: ,per_assignments_f asg2

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

Line 1525: FROM PER_ASSIGNMENTS_F asg,

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

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 1927: FROM PER_ASSIGNMENTS_F asg

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

Line 1937: FROM per_assignments_f asg1

1933: AND NVL(asg.effective_end_date,p_period_end_date) >= p_period_start_date;
1934:
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

Line 1938: ,per_assignments_f asg2

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

Line 1954: FROM PER_ASSIGNMENTS_F asg,

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

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)