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.PA_RESOURCE_UTILS dependencies on PER_ALL_PEOPLE_F

Line 20: FROM per_all_people_f

16: IS
17:
18: CURSOR internal IS
19: SELECT 'Y'
20: FROM per_all_people_f
21: WHERE full_name = p_resource_name
22: and rownum=1;
23:
24: CURSOR external IS

Line 117: FROM per_all_people_f

113: l_future_term_wf_flag pa_resources.future_term_wf_flag%TYPE := NULL ;
114:
115: CURSOR r_ids IS
116: SELECT person_id
117: FROM per_all_people_f
118: WHERE full_name = p_resource_name
119: AND trunc(p_date) between trunc(effective_start_date)
120: and trunc(effective_end_date);
121:

Line 178: FROM per_all_people_f per

174: SELECT per.person_id
175: -- type.system_person_type -- FP M CWK
176: INTO x_resource_id
177: -- l_sys_per_type
178: FROM per_all_people_f per
179: -- per_person_types type
180: WHERE per.person_id = p_resource_id
181: -- AND per.person_type_id = type.person_type_id
182: AND trunc(p_date) between trunc(per.effective_start_date) and trunc(per.effective_end_date)

Line 188: from per_all_people_f per2

184: OR
185: -- Start changes for Bug 6828493
186: --(trunc(p_end_date) between trunc(per.effective_start_date) and trunc(per.effective_end_date))
187: (trunc(p_end_date) < = (Select trunc(max(per2.effective_end_date))
188: from per_all_people_f per2
189: where per2.person_id = p_resource_id
190: AND (per2.current_employee_flag = 'Y' OR per2.current_npw_flag = 'Y')) -- AND Codn added for bug 6851095
191: AND trunc(p_end_date) > = (Select trunc(min(per3.effective_start_date))
192: from per_all_people_f per3

Line 192: from per_all_people_f per3

188: from per_all_people_f per2
189: where per2.person_id = p_resource_id
190: AND (per2.current_employee_flag = 'Y' OR per2.current_npw_flag = 'Y')) -- AND Codn added for bug 6851095
191: AND trunc(p_end_date) > = (Select trunc(min(per3.effective_start_date))
192: from per_all_people_f per3
193: where per3.person_id = p_resource_id
194: AND (per3.current_employee_flag = 'Y' OR per3.current_npw_flag = 'Y')))) -- AND Codn added for bug 6851095
195: -- End changes for Bug 6828493
196: AND (per.current_employee_flag = 'Y'

Line 210: FROM per_all_people_f per,

206: /* FP M CWK - no need to do this at all since l_sys_per_type is not
207: * used for anything */
208: /* SELECT type.system_person_type
209: INTO l_sys_per_type
210: FROM per_all_people_f per,
211: per_person_types type
212: WHERE per.person_id = x_resource_id
213: AND per.person_type_id = type.person_type_id
214: AND trunc(p_date) between trunc(per.effective_start_date)

Line 247: FROM per_all_people_f per,

243: /* FP M CWK - no need to do this at all since l_sys_per_type is not
244: * used for anything */
245: /* SELECT type.system_person_type
246: INTO l_sys_per_type
247: FROM per_all_people_f per,
248: per_person_types type
249: WHERE per.person_id = x_resource_id
250: AND per.person_type_id = type.person_type_id
251: AND trunc(p_date) between trunc(per.effective_start_date) and trunc(per.effective_end_date)

Line 269: FROM per_all_people_f per

265: SELECT per.person_id
266: -- type.system_person_type -- FP M CWK
267: INTO x_resource_id
268: -- l_sys_per_type -- FP M CWK
269: FROM per_all_people_f per
270: -- per_person_types type -- FP M CWK
271: WHERE per.full_name = p_resource_name
272: -- AND per.person_type_id = type.person_type_id -- FP M CWK
273: AND trunc(p_date) between trunc(per.effective_start_date)

Line 1355: FROM fnd_grants fg, wf_roles wfr, per_all_people_f per

1351: cursor analystid(objid fnd_grants.object_id%TYPE,
1352: orgid per_all_assignments_f.organization_id%TYPE,
1353: roleid fnd_grants.menu_id%TYPE ) is
1354: SELECT distinct per.person_id
1355: FROM fnd_grants fg, wf_roles wfr, per_all_people_f per
1356: WHERE fg.object_id = objid
1357: AND fg.instance_pk1_value = TO_CHAR(orgid)
1358: AND fg.menu_id = roleid
1359: AND fg.instance_type = 'INSTANCE'

Line 1378: FROM per_all_people_f -- Bug 4684198 - use base table not view

1374: BEGIN
1375:
1376: SELECT 'Y'
1377: INTO v_validated
1378: FROM per_all_people_f -- Bug 4684198 - use base table not view
1379: WHERE person_id = P_PersonId
1380: AND trunc(sysdate) BETWEEN effective_start_date
1381: AND effective_end_date
1382: -- Bug 4684198 - remove nvl on effective_end_date - col is not null

Line 1428: per_all_people_f pep, -- Bug 4684198 - use table

1424: --distinct to_number(substr(fg.grantee_key,instr(fg.grantee_key,':')+1)),
1425: pep.full_name
1426: INTO P_PrimaryContactId,P_PrimaryContactName
1427: FROM fnd_grants fg,
1428: per_all_people_f pep, -- Bug 4684198 - use table
1429: wf_roles wfr
1430: WHERE fg.object_id = v_objid
1431: AND fg.instance_pk1_value = TO_CHAR(v_orgid)
1432: AND fg.menu_id = v_Primroleid

Line 1473: FROM per_all_people_f -- Bug 4684198

1469: IF (P_ResourceIdTab(j) is NOT NULL) then
1470: BEGIN
1471: SELECT full_name
1472: INTO P_ResourceAnalystTab(j)
1473: FROM per_all_people_f -- Bug 4684198
1474: WHERE person_id = P_ResourceIdTab(j)
1475: AND trunc(sysdate) BETWEEN effective_start_date
1476: AND effective_end_date;
1477: -- Bug 4684198 - remove nvl on effective_end_date - col is not null

Line 1560: per_all_people_f pep, -- Bug 4684198 - use table

1556: -- to_number(substr(fg.grantee_key,instr(fg.grantee_key,':')+1))
1557: ,pep.full_name
1558: INTO x_PrimaryContactId,x_PrimaryContactName
1559: FROM fnd_grants fg,
1560: per_all_people_f pep, -- Bug 4684198 - use table
1561: wf_roles wfr
1562: WHERE fg.object_id = P_objid
1563: AND fg.instance_pk1_value = to_char(P_orgid)
1564: AND fg.menu_id = P_Primroleid

Line 1624: FROM per_all_assignments_f assn,per_all_people_f pep

1620: --Modified code for future dated person
1621: --Manager check is still as of sysdate
1622: SELECT assn.supervisor_id,pep.full_name
1623: INTO x_ManagerId,x_ManagerName
1624: FROM per_all_assignments_f assn,per_all_people_f pep
1625: WHERE assn.person_id = P_personId
1626: AND pep.person_id = assn.supervisor_id
1627: AND trunc(p_start_date) BETWEEN assn.effective_start_date /*Bug 8817301 */
1628: AND assn.effective_end_date

Line 1652: per_all_people_f pep

1648: BEGIN
1649: SELECT assn.supervisor_id,pep.full_name
1650: INTO x_ManagerId,x_ManagerName
1651: FROM per_all_assignments_f assn,
1652: per_all_people_f pep
1653: WHERE assn.person_id = P_personId
1654: AND pep.person_id = assn.supervisor_id
1655: AND trunc(p_start_date) BETWEEN assn.effective_start_date /*Bug 8817301 */
1656: AND assn.effective_end_date

Line 1679: FROM per_all_assignments_f assn,per_all_people_f pep

1675:
1676: BEGIN
1677: SELECT assn.supervisor_id,pep.full_name
1678: INTO x_ManagerId,x_ManagerName
1679: FROM per_all_assignments_f assn,per_all_people_f pep
1680: WHERE assn.person_id = P_personId
1681: AND pep.person_id = assn.supervisor_id
1682: AND trunc(p_start_date) BETWEEN assn.effective_start_date /*Bug 8817301 */
1683: AND assn.effective_end_date

Line 2571: /* changed the select statement to be based on per_all_people_f and added

2567: x_return_status := FND_API.G_RET_STS_SUCCESS;
2568:
2569: IF p_person_id IS NOT NULL then
2570:
2571: /* changed the select statement to be based on per_all_people_f and added
2572: the sysdate condition for bug 2983491 */
2573:
2574: SELECT full_name
2575: INTO x_person_name

Line 2576: FROM per_all_people_f

2572: the sysdate condition for bug 2983491 */
2573:
2574: SELECT full_name
2575: INTO x_person_name
2576: FROM per_all_people_f
2577: WHERE person_id = p_person_id
2578: AND EFFECTIVE_START_DATE = (SELECT MIN(EFFECTIVE_START_DATE) FROM per_all_people_f
2579: WHERE person_id = p_person_id
2580: and trunc(EFFECTIVE_END_DATE) >= trunc(sysdate));

Line 2578: AND EFFECTIVE_START_DATE = (SELECT MIN(EFFECTIVE_START_DATE) FROM per_all_people_f

2574: SELECT full_name
2575: INTO x_person_name
2576: FROM per_all_people_f
2577: WHERE person_id = p_person_id
2578: AND EFFECTIVE_START_DATE = (SELECT MIN(EFFECTIVE_START_DATE) FROM per_all_people_f
2579: WHERE person_id = p_person_id
2580: and trunc(EFFECTIVE_END_DATE) >= trunc(sysdate));
2581:
2582: --AND TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;

Line 2948: per_all_people_f pep, -- Bug 4684198 - use base table not secure view

2944: INTO l_primary_contact_name,
2945: l_primary_contact_id
2946: FROM fnd_grants fg,
2947: fnd_objects fob,
2948: per_all_people_f pep, -- Bug 4684198 - use base table not secure view
2949: wf_roles wfr
2950: /* Bug# 2499051 - Moved the function call to fetch to a local variable at the start of the procedure
2951: (select pa_security_pvt.get_menu_id(p_prim_role_name) menu_id from dual) temp */
2952: WHERE fg.object_id = fob.object_id

Line 3237: -- in per_all_people_f

3233: -- FUNCTION
3234: -- Get_Person_Start_date
3235: -- PURPOSE
3236: -- This procedure returns the start date of the person
3237: -- in per_all_people_f
3238: --
3239: -- HISTORY
3240: -- 21-jan-2003 created sramesh for the bug 2686120
3241: --

Line 3252: FROM PER_ALL_PEOPLE_F P

3248: BEGIN
3249: /* Commented for bug 4510084
3250: SELECT P.EFFECTIVE_START_DATE
3251: INTO l_start_date
3252: FROM PER_ALL_PEOPLE_F P
3253: WHERE P.PERSON_ID = p_person_id
3254: AND p.EFFECTIVE_START_DATE = (SELECT MIN(PP.EFFECTIVE_START_DATE)
3255: FROM PER_ALL_PEOPLE_F PP
3256: WHERE PP.PERSON_ID = p_person_id

Line 3255: FROM PER_ALL_PEOPLE_F PP

3251: INTO l_start_date
3252: FROM PER_ALL_PEOPLE_F P
3253: WHERE P.PERSON_ID = p_person_id
3254: AND p.EFFECTIVE_START_DATE = (SELECT MIN(PP.EFFECTIVE_START_DATE)
3255: FROM PER_ALL_PEOPLE_F PP
3256: WHERE PP.PERSON_ID = p_person_id
3257: AND PP.EFFECTIVE_END_DATE >= SYSDATE)
3258: AND (P.EMPLOYEE_NUMBER IS NOT NULL OR
3259: P.npw_number is not null); -- FP M CWK

Line 3265: FROM PER_ALL_PEOPLE_F PP

3261:
3262: /* Added for bug 4510084 */
3263: SELECT MIN(PP.EFFECTIVE_START_DATE)
3264: INTO l_start_date
3265: FROM PER_ALL_PEOPLE_F PP
3266: WHERE PP.PERSON_ID = p_person_id
3267: AND (PP.CURRENT_EMPLOYEE_FLAG='Y' OR PP.CURRENT_NPW_FLAG = 'Y')
3268: AND (PP.EMPLOYEE_NUMBER IS NOT NULL OR
3269: PP.npw_number is not null);-- FP M CWK

Line 3616: per_all_people_f per,

3612: SELECT 'Y'
3613: FROM pa_resources_denorm res,
3614: fnd_grants fg,
3615: fnd_objects fob,
3616: per_all_people_f per,
3617: wf_roles wfr,
3618: (select pa_security_pvt.get_menu_id('PA_PRM_RES_AUTH') menu_id
3619: from dual) res_auth_menu
3620: WHERE fob.obj_name = 'ORGANIZATION'

Line 3728: FROM per_all_people_f

3724: BEGIN
3725:
3726: SELECT person_id
3727: INTO l_person_id
3728: FROM per_all_people_f
3729: WHERE party_id = p_party_id
3730: AND trunc(sysdate) between trunc(effective_start_date)
3731: and trunc(effective_end_date);
3732:

Line 3745: FROM per_all_people_f

3741: IS
3742:
3743: cursor p_active is
3744: SELECT person_id
3745: FROM per_all_people_f
3746: WHERE party_id = p_party_id
3747: AND CURRENT_EMPLOYEE_FLAG = 'Y'
3748: AND trunc(sysdate) between trunc(effective_start_date)
3749: and trunc(effective_end_date);

Line 3753: FROM per_all_people_f

3749: and trunc(effective_end_date);
3750:
3751: cursor p_teminated is
3752: SELECT person_id
3753: FROM per_all_people_f
3754: WHERE party_id = p_party_id
3755: and trunc(effective_end_date) =
3756: (select max(trunc(effective_end_date))
3757: from per_all_people_f

Line 3757: from per_all_people_f

3753: FROM per_all_people_f
3754: WHERE party_id = p_party_id
3755: and trunc(effective_end_date) =
3756: (select max(trunc(effective_end_date))
3757: from per_all_people_f
3758: WHERE trunc(sysdate) not between trunc(effective_start_date)
3759: and trunc(effective_end_date)
3760: and party_id = p_party_id);
3761:

Line 3801: from per_all_people_f per

3797: RETURN BOOLEAN IS
3798:
3799: cursor chk_no_termination(p_person_id NUMBER) is
3800: select 'Y'
3801: from per_all_people_f per
3802: where per.person_id = p_person_id
3803: and (per.current_employee_flag = 'Y' OR per.current_npw_flag = 'Y')
3804: and p_effective_start_date between per.effective_start_date
3805: and per.effective_end_date;

Line 3862: from per_all_people_f per

3858:
3859: cursor validate_person_type
3860: is
3861: select person_id
3862: from per_all_people_f per
3863: where per.person_id = p_person_id
3864: and (per.current_employee_flag = 'Y' OR per.current_npw_flag = 'Y');
3865:
3866: cursor get_active_assignment

Line 4288: FROM per_all_people_f peo, hz_parties hzp

4284: IF l_resource_type_code = 'EMPLOYEE' THEN
4285:
4286: SELECT hzp.party_name
4287: INTO l_name
4288: FROM per_all_people_f peo, hz_parties hzp
4289: WHERE peo.person_id = p_resource_source_id
4290: AND sysdate BETWEEN peo.effective_start_date AND
4291: peo.effective_end_date
4292: AND peo.party_id = hzp.party_id;

Line 4573: l_person_name PER_all_PEOPLE_F.FULL_NAME%TYPE := null;

4569: -- 28-APR-2003 shyugen
4570:
4571: FUNCTION get_person_name_no_date(p_person_id IN NUMBER) RETURN VARCHAR IS
4572:
4573: l_person_name PER_all_PEOPLE_F.FULL_NAME%TYPE := null;
4574:
4575: BEGIN
4576:
4577: IF p_person_id IS NOT NULL THEN

Line 4581: FROM per_all_people_f

4577: IF p_person_id IS NOT NULL THEN
4578:
4579: SELECT full_name
4580: INTO l_person_name
4581: FROM per_all_people_f
4582: WHERE person_id = p_person_id
4583: AND effective_end_date = (SELECT MAX(effective_end_date)
4584: FROM per_all_people_f
4585: WHERE person_id = p_person_id);

Line 4584: FROM per_all_people_f

4580: INTO l_person_name
4581: FROM per_all_people_f
4582: WHERE person_id = p_person_id
4583: AND effective_end_date = (SELECT MAX(effective_end_date)
4584: FROM per_all_people_f
4585: WHERE person_id = p_person_id);
4586: END IF;
4587:
4588: RETURN l_person_name;

Line 4650: x_ManagerName PER_all_PEOPLE_F.FULL_NAME%TYPE :=null;

4646: v_return_status VARCHAR2(1);
4647: v_personid NUMBER;
4648: v_error_message_code fnd_new_messages.message_name%TYPE;
4649: l_start_date DATE;
4650: x_ManagerName PER_all_PEOPLE_F.FULL_NAME%TYPE :=null;
4651:
4652:
4653: BEGIN
4654: