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_ALL_ASSIGNMENTS_F

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 659: FROM per_all_assignments_f paaf1

655: and paf.primary_flag = 'Y'
656: and
657: (
658: SELECT max (paaf1.effective_start_date)
659: FROM per_all_assignments_f paaf1
660: WHERE paaf1.assignment_id = paf.assignment_id
661: ) BETWEEN paf.effective_start_date AND paf.effective_end_date
662: and paf.effective_start_date BETWEEN papf.effective_start_date
663: AND papf.effective_end_date

Line 788: from per_all_assignments_f paaf

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
790: and paaf.primary_flag ='Y'
791: and
792: (

Line 794: FROM per_all_assignments_f paaf1

790: and paaf.primary_flag ='Y'
791: and
792: (
793: SELECT max (paaf1.effective_start_date)
794: FROM per_all_assignments_f paaf1
795: WHERE paaf1.assignment_id = paaf.assignment_id
796: ) BETWEEN paaf.effective_start_date AND paaf.effective_end_date)
797: and information_type = 'ZA_SPECIFIC_INFO';
798: end if;

Line 1055: from per_all_assignments_f paaf

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'
1058: and
1059: (

Line 1061: FROM per_all_assignments_f paaf1

1057: and paaf.primary_flag ='Y'
1058: and
1059: (
1060: SELECT max (paaf1.effective_start_date)
1061: FROM per_all_assignments_f paaf1
1062: WHERE paaf1.assignment_id = paaf.assignment_id
1063: ) BETWEEN paaf.effective_start_date AND paaf.effective_end_date)
1064: and information_type = 'ZA_SPECIFIC_INFO';
1065:

Line 1253: from per_all_assignments_f paaf

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
1255: and paaf.primary_flag ='Y'
1256: and
1257: (

Line 1259: FROM per_all_assignments_f paaf1

1255: and paaf.primary_flag ='Y'
1256: and
1257: (
1258: SELECT max (paaf1.effective_start_date)
1259: FROM per_all_assignments_f paaf1
1260: WHERE paaf1.assignment_id = paaf.assignment_id
1261: ) BETWEEN paaf.effective_start_date AND paaf.effective_end_date)
1262: and information_type = 'ZA_SPECIFIC_INFO';
1263: end if;

Line 1423: FROM per_all_assignments_f paaf

1419:
1420: BEGIN
1421: SELECT paaf.primary_flag
1422: INTO l_asg_primary_flag
1423: FROM per_all_assignments_f paaf
1424: WHERE paaf.assignment_id = P_ASSIGNMENT_ID
1425: AND
1426: (
1427: SELECT max (paaf1.effective_start_date)

Line 1428: FROM per_all_assignments_f paaf1

1424: WHERE paaf.assignment_id = P_ASSIGNMENT_ID
1425: AND
1426: (
1427: SELECT max (paaf1.effective_start_date)
1428: FROM per_all_assignments_f paaf1
1429: WHERE paaf1.assignment_id = paaf.assignment_id
1430: ) BETWEEN paaf.effective_start_date AND paaf.effective_end_date;
1431:
1432: if l_asg_primary_flag = 'Y' then

Line 1437: ,per_all_assignments_f paaf

1433:
1434: SELECT per_information12
1435: INTO l_person_nop
1436: FROM per_all_people_f paf
1437: ,per_all_assignments_f paaf
1438: WHERE paaf.assignment_id = P_ASSIGNMENT_ID
1439: AND paaf.person_id = paf.person_id
1440: AND paaf.primary_flag = 'Y'
1441: AND

Line 1444: FROM per_all_assignments_f paaf1

1440: AND paaf.primary_flag = 'Y'
1441: AND
1442: (
1443: SELECT max (paaf1.effective_start_date)
1444: FROM per_all_assignments_f paaf1
1445: WHERE paaf1.assignment_id = paaf.assignment_id
1446: ) BETWEEN paaf.effective_start_date AND paaf.effective_end_date
1447: AND paaf.effective_start_date BETWEEN paf.effective_start_date
1448: AND paf.effective_end_date;

Line 1500: FROM per_all_assignments_f paaf

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

Line 1507: FROM per_all_assignments_f paaf1

1503: AND pai.assignment_id = paaf.assignment_id
1504: AND
1505: (
1506: SELECT max (paaf1.effective_start_date)
1507: FROM per_all_assignments_f paaf1
1508: WHERE paaf1.assignment_id = paaf.assignment_id
1509: ) BETWEEN paaf.effective_start_date AND paaf.effective_end_date;
1510:
1511: if l_asg_primary_flag = 'Y' then

Line 1515: ,per_all_assignments_f paaf

1511: if l_asg_primary_flag = 'Y' then
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

Line 1523: FROM per_all_assignments_f paaf1

1519: AND paf.person_id = paaf.person_id
1520: AND
1521: (
1522: SELECT max (paaf1.effective_start_date)
1523: FROM per_all_assignments_f paaf1
1524: WHERE paaf1.assignment_id = paaf.assignment_id
1525: ) BETWEEN paaf.effective_start_date AND paaf.effective_end_date
1526: AND paaf.effective_start_date BETWEEN paf.effective_start_date AND paf.effective_end_date;
1527:

Line 2063: l_assignment_id per_all_assignments_f.assignment_id%type;

2059: ,P_PERSONAL_PAYMENT_METHOD_ID IN NUMBER
2060: ,P_PPM_INFORMATION1 IN VARCHAR2)
2061: is
2062: l_count NUMBER;
2063: l_assignment_id per_all_assignments_f.assignment_id%type;
2064: begin
2065: l_count := 0;
2066: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
2067: select assignment_id