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.PER_ZA_USER_HOOK_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 651: from PER_ASSIGNMENT_EXTRA_INFO pei, per_all_assignments_f paf, per_all_people_f papf

647:
648: CURSOR c_asg_nop
649: IS
650: select pei.AEI_INFORMATION4,papf.person_id
651: from PER_ASSIGNMENT_EXTRA_INFO pei, per_all_assignments_f paf, per_all_people_f papf
652: where pei.assignment_id = paf.assignment_id
653: and paf.person_id = papf.person_id
654: and papf.employee_number = p_employee_number
655: and paf.primary_flag = 'Y'

Line 785: update PER_ASSIGNMENT_EXTRA_INFO

781: CLOSE c_asg_nop;
782:
783:
784: if l_asg_nop <> p_per_information12 then
785: update PER_ASSIGNMENT_EXTRA_INFO
786: set AEI_INFORMATION4 = p_per_information12
787: where assignment_id in (select paaf.assignment_id
788: from per_all_assignments_f paaf
789: where paaf.person_id = l_person_id

Line 1053: from PER_ASSIGNMENT_EXTRA_INFO

1049:
1050: CURSOR c_asg_nop
1051: IS
1052: select AEI_INFORMATION4
1053: from PER_ASSIGNMENT_EXTRA_INFO
1054: where assignment_id in (select paaf.assignment_id
1055: from per_all_assignments_f paaf
1056: where paaf.person_id = p_person_id
1057: and paaf.primary_flag ='Y'

Line 1250: update PER_ASSIGNMENT_EXTRA_INFO

1246: FETCH c_asg_nop INTO l_asg_nop;
1247: CLOSE c_asg_nop;
1248:
1249: if l_asg_nop <> l_person_nop then
1250: update PER_ASSIGNMENT_EXTRA_INFO
1251: set AEI_INFORMATION4 = l_person_nop
1252: where assignment_id in (select paaf.assignment_id
1253: from per_all_assignments_f paaf
1254: where paaf.person_id = p_person_id

Line 1501: ,per_assignment_extra_info pai

1497: BEGIN
1498: SELECT paaf.primary_flag
1499: INTO l_asg_primary_flag
1500: FROM per_all_assignments_f paaf
1501: ,per_assignment_extra_info pai
1502: WHERE pai.assignment_extra_info_id = P_ASSIGNMENT_EXTRA_INFO_ID
1503: AND pai.assignment_id = paaf.assignment_id
1504: AND
1505: (

Line 1516: ,per_assignment_extra_info pai

1512: SELECT paf.per_information12
1513: INTO l_person_nop
1514: FROM per_all_people_f paf
1515: ,per_all_assignments_f paaf
1516: ,per_assignment_extra_info pai
1517: WHERE pai.assignment_extra_info_id = P_ASSIGNMENT_EXTRA_INFO_ID
1518: AND pai.assignment_id = paaf.assignment_id
1519: AND paf.person_id = paaf.person_id
1520: AND