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.PON_AWARD_APPROVAL_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 994: SELECT person.person_id FROM per_all_people_f person, per_all_assignments_f asg

990: aname => 'FIRST_AUTHORITY_APPROVER_ID');
991: END IF;
992: IF( l_person_id IS NULL OR l_person_id = -1 ) THEN
993: SELECT person_id into l_person_id FROM (
994: SELECT person.person_id FROM per_all_people_f person, per_all_assignments_f asg
995: WHERE asg.position_id = l_next_approver.orig_system_id and trunc(sysdate) between person.effective_start_date
996: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
997: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
998: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )

Line 1506: SELECT person.person_id FROM per_all_people_f person, per_all_assignments_f asg

1502: aname => 'FIRST_AUTHORITY_APPROVER_ID');
1503: END IF;
1504: IF( l_person_id IS NULL OR l_person_id = -1 ) THEN
1505: SELECT person_id into l_person_id FROM (
1506: SELECT person.person_id FROM per_all_people_f person, per_all_assignments_f asg
1507: WHERE asg.position_id = l_approver.orig_system_id and trunc(sysdate) between person.effective_start_date
1508: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
1509: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
1510: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )

Line 1659: SELECT position_id into l_forwardee.orig_system_id FROM PER_ALL_ASSIGNMENTS_F pa

1655:
1656: IF l_forwardee.orig_system = 'POS' THEN
1657: select full_name into l_forwardee.display_name from per_all_people_f where person_id = l_forwardee.orig_system_id and TRUNC(sysdate) between effective_start_date and effective_end_date;
1658: BEGIN
1659: SELECT position_id into l_forwardee.orig_system_id FROM PER_ALL_ASSIGNMENTS_F pa
1660: WHERE pa.person_id = l_forwardee.orig_system_id and pa.primary_flag = 'Y' and pa.assignment_type in ('E','C')
1661: and pa.position_id is not null and pa.assignment_status_type_id not in (
1662: select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')
1663: and TRUNC ( pa.effective_start_date )

Line 2052: SELECT position_id into l_approver.orig_system_id FROM PER_ALL_ASSIGNMENTS_F pa

2048: l_approver.orig_system := 'POS';
2049: IF l_approver.orig_system_id IS NOT NULL THEN
2050: select full_name into l_approver.display_name from per_all_people_f where person_id = l_approver.orig_system_id and TRUNC(sysdate) between effective_start_date and effective_end_date ;
2051: BEGIN
2052: SELECT position_id into l_approver.orig_system_id FROM PER_ALL_ASSIGNMENTS_F pa
2053: WHERE pa.person_id = l_approver.orig_system_id and pa.primary_flag = 'Y' and pa.assignment_type in ('E','C')
2054: and pa.position_id is not null and pa.assignment_status_type_id not in (
2055: select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')
2056: and TRUNC ( pa.effective_start_date )