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 980: SELECT person.person_id FROM per_all_people_f person, per_all_assignments_f asg

976: aname => 'FIRST_AUTHORITY_APPROVER_ID');
977: END IF;
978: IF( l_person_id IS NULL OR l_person_id = -1 ) THEN
979: SELECT person_id into l_person_id FROM (
980: SELECT person.person_id FROM per_all_people_f person, per_all_assignments_f asg
981: WHERE asg.position_id = l_next_approver.orig_system_id and trunc(sysdate) between person.effective_start_date
982: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
983: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
984: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )

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

1467: aname => 'FIRST_AUTHORITY_APPROVER_ID');
1468: END IF;
1469: IF( l_person_id IS NULL OR l_person_id = -1 ) THEN
1470: SELECT person_id into l_person_id FROM (
1471: SELECT person.person_id FROM per_all_people_f person, per_all_assignments_f asg
1472: WHERE asg.position_id = l_approver.orig_system_id and trunc(sysdate) between person.effective_start_date
1473: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
1474: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
1475: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )

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

1620:
1621: IF l_forwardee.orig_system = 'POS' THEN
1622: 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;
1623: BEGIN
1624: SELECT position_id into l_forwardee.orig_system_id FROM PER_ALL_ASSIGNMENTS_F pa
1625: WHERE pa.person_id = l_forwardee.orig_system_id and pa.primary_flag = 'Y' and pa.assignment_type in ('E','C')
1626: and pa.position_id is not null and pa.assignment_status_type_id not in (
1627: select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')
1628: and TRUNC ( pa.effective_start_date )

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

2013: l_approver.orig_system := 'POS';
2014: IF l_approver.orig_system_id IS NOT NULL THEN
2015: 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 ;
2016: BEGIN
2017: SELECT position_id into l_approver.orig_system_id FROM PER_ALL_ASSIGNMENTS_F pa
2018: WHERE pa.person_id = l_approver.orig_system_id and pa.primary_flag = 'Y' and pa.assignment_type in ('E','C')
2019: and pa.position_id is not null and pa.assignment_status_type_id not in (
2020: select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')
2021: and TRUNC ( pa.effective_start_date )