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 116: FROM per_all_people_f

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

Line 177: FROM per_all_people_f per

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

Line 187: from per_all_people_f per2

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

Line 191: from per_all_people_f per3

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

Line 209: FROM per_all_people_f per,

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

Line 246: FROM per_all_people_f per,

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

Line 268: FROM per_all_people_f per

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

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

1272: cursor analystid(objid fnd_grants.object_id%TYPE,
1273: orgid per_all_assignments_f.organization_id%TYPE,
1274: roleid fnd_grants.menu_id%TYPE ) is
1275: SELECT distinct per.person_id
1276: FROM fnd_grants fg, wf_roles wfr, per_all_people_f per
1277: WHERE fg.object_id = objid
1278: AND fg.instance_pk1_value = TO_CHAR(orgid)
1279: AND fg.menu_id = roleid
1280: AND fg.instance_type = 'INSTANCE'

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

1295: BEGIN
1296:
1297: SELECT 'Y'
1298: INTO v_validated
1299: FROM per_all_people_f -- Bug 4684198 - use base table not view
1300: WHERE person_id = P_PersonId
1301: AND trunc(sysdate) BETWEEN effective_start_date
1302: AND effective_end_date
1303: -- Bug 4684198 - remove nvl on effective_end_date - col is not null

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

1345: --distinct to_number(substr(fg.grantee_key,instr(fg.grantee_key,':')+1)),
1346: pep.full_name
1347: INTO P_PrimaryContactId,P_PrimaryContactName
1348: FROM fnd_grants fg,
1349: per_all_people_f pep, -- Bug 4684198 - use table
1350: wf_roles wfr
1351: WHERE fg.object_id = v_objid
1352: AND fg.instance_pk1_value = TO_CHAR(v_orgid)
1353: AND fg.menu_id = v_Primroleid

Line 1394: FROM per_all_people_f -- Bug 4684198

1390: IF (P_ResourceIdTab(j) is NOT NULL) then
1391: BEGIN
1392: SELECT full_name
1393: INTO P_ResourceAnalystTab(j)
1394: FROM per_all_people_f -- Bug 4684198
1395: WHERE person_id = P_ResourceIdTab(j)
1396: AND trunc(sysdate) BETWEEN effective_start_date
1397: AND effective_end_date;
1398: -- Bug 4684198 - remove nvl on effective_end_date - col is not null

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

1477: -- to_number(substr(fg.grantee_key,instr(fg.grantee_key,':')+1))
1478: ,pep.full_name
1479: INTO x_PrimaryContactId,x_PrimaryContactName
1480: FROM fnd_grants fg,
1481: per_all_people_f pep, -- Bug 4684198 - use table
1482: wf_roles wfr
1483: WHERE fg.object_id = P_objid
1484: AND fg.instance_pk1_value = to_char(P_orgid)
1485: AND fg.menu_id = P_Primroleid

Line 1545: FROM per_all_assignments_f assn,per_all_people_f pep

1541: --Modified code for future dated person
1542: --Manager check is still as of sysdate
1543: SELECT assn.supervisor_id,pep.full_name
1544: INTO x_ManagerId,x_ManagerName
1545: FROM per_all_assignments_f assn,per_all_people_f pep
1546: WHERE assn.person_id = P_personId
1547: AND pep.person_id = assn.supervisor_id
1548: AND p_start_date BETWEEN assn.effective_start_date
1549: AND assn.effective_end_date

Line 1572: per_all_people_f pep

1568: BEGIN
1569: SELECT assn.supervisor_id,pep.full_name
1570: INTO x_ManagerId,x_ManagerName
1571: FROM per_all_assignments_f assn,
1572: per_all_people_f pep
1573: WHERE assn.person_id = P_personId
1574: AND pep.person_id = assn.supervisor_id
1575: AND p_start_date BETWEEN assn.effective_start_date
1576: AND assn.effective_end_date

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

2450: x_return_status := FND_API.G_RET_STS_SUCCESS;
2451:
2452: IF p_person_id IS NOT NULL then
2453:
2454: /* changed the select statement to be based on per_all_people_f and added
2455: the sysdate condition for bug 2983491 */
2456:
2457: SELECT full_name
2458: INTO x_person_name

Line 2459: FROM per_all_people_f

2455: the sysdate condition for bug 2983491 */
2456:
2457: SELECT full_name
2458: INTO x_person_name
2459: FROM per_all_people_f
2460: WHERE person_id = p_person_id
2461: AND EFFECTIVE_START_DATE = (SELECT MIN(EFFECTIVE_START_DATE) FROM per_all_people_f
2462: WHERE person_id = p_person_id
2463: and trunc(EFFECTIVE_END_DATE) >= trunc(sysdate));

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

2457: SELECT full_name
2458: INTO x_person_name
2459: FROM per_all_people_f
2460: WHERE person_id = p_person_id
2461: AND EFFECTIVE_START_DATE = (SELECT MIN(EFFECTIVE_START_DATE) FROM per_all_people_f
2462: WHERE person_id = p_person_id
2463: and trunc(EFFECTIVE_END_DATE) >= trunc(sysdate));
2464:
2465: --AND TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;

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

2827: INTO l_primary_contact_name,
2828: l_primary_contact_id
2829: FROM fnd_grants fg,
2830: fnd_objects fob,
2831: per_all_people_f pep, -- Bug 4684198 - use base table not secure view
2832: wf_roles wfr
2833: /* Bug# 2499051 - Moved the function call to fetch to a local variable at the start of the procedure
2834: (select pa_security_pvt.get_menu_id(p_prim_role_name) menu_id from dual) temp */
2835: WHERE fg.object_id = fob.object_id

Line 2976: -- in per_all_people_f

2972: -- FUNCTION
2973: -- Get_Person_Start_date
2974: -- PURPOSE
2975: -- This procedure returns the start date of the person
2976: -- in per_all_people_f
2977: --
2978: -- HISTORY
2979: -- 21-jan-2003 created sramesh for the bug 2686120
2980: --

Line 2991: FROM PER_ALL_PEOPLE_F P

2987: BEGIN
2988: /* Commented for bug 4510084
2989: SELECT P.EFFECTIVE_START_DATE
2990: INTO l_start_date
2991: FROM PER_ALL_PEOPLE_F P
2992: WHERE P.PERSON_ID = p_person_id
2993: AND p.EFFECTIVE_START_DATE = (SELECT MIN(PP.EFFECTIVE_START_DATE)
2994: FROM PER_ALL_PEOPLE_F PP
2995: WHERE PP.PERSON_ID = p_person_id

Line 2994: FROM PER_ALL_PEOPLE_F PP

2990: INTO l_start_date
2991: FROM PER_ALL_PEOPLE_F P
2992: WHERE P.PERSON_ID = p_person_id
2993: AND p.EFFECTIVE_START_DATE = (SELECT MIN(PP.EFFECTIVE_START_DATE)
2994: FROM PER_ALL_PEOPLE_F PP
2995: WHERE PP.PERSON_ID = p_person_id
2996: AND PP.EFFECTIVE_END_DATE >= SYSDATE)
2997: AND (P.EMPLOYEE_NUMBER IS NOT NULL OR
2998: P.npw_number is not null); -- FP M CWK

Line 3004: FROM PER_ALL_PEOPLE_F PP

3000:
3001: /* Added for bug 4510084 */
3002: SELECT MIN(PP.EFFECTIVE_START_DATE)
3003: INTO l_start_date
3004: FROM PER_ALL_PEOPLE_F PP
3005: WHERE PP.PERSON_ID = p_person_id
3006: AND (PP.CURRENT_EMPLOYEE_FLAG='Y' OR PP.CURRENT_NPW_FLAG = 'Y')
3007: AND (PP.EMPLOYEE_NUMBER IS NOT NULL OR
3008: PP.npw_number is not null);-- FP M CWK

Line 3354: per_all_people_f per,

3350: SELECT 'Y'
3351: FROM pa_resources_denorm res,
3352: fnd_grants fg,
3353: fnd_objects fob,
3354: per_all_people_f per,
3355: wf_roles wfr,
3356: (select pa_security_pvt.get_menu_id('PA_PRM_RES_AUTH') menu_id
3357: from dual) res_auth_menu
3358: WHERE fob.obj_name = 'ORGANIZATION'

Line 3440: FROM per_all_people_f

3436: BEGIN
3437:
3438: SELECT person_id
3439: INTO l_person_id
3440: FROM per_all_people_f
3441: WHERE party_id = p_party_id
3442: AND trunc(sysdate) between trunc(effective_start_date)
3443: and trunc(effective_end_date);
3444:

Line 3465: from per_all_people_f per

3461: RETURN BOOLEAN IS
3462:
3463: cursor chk_no_termination(p_person_id NUMBER) is
3464: select 'Y'
3465: from per_all_people_f per
3466: where per.person_id = p_person_id
3467: and (per.current_employee_flag = 'Y' OR per.current_npw_flag = 'Y')
3468: and p_effective_start_date between per.effective_start_date
3469: and per.effective_end_date;

Line 3526: from per_all_people_f per

3522:
3523: cursor validate_person_type
3524: is
3525: select person_id
3526: from per_all_people_f per
3527: where per.person_id = p_person_id
3528: and (per.current_employee_flag = 'Y' OR per.current_npw_flag = 'Y');
3529:
3530: cursor get_active_assignment

Line 3952: FROM per_all_people_f peo, hz_parties hzp

3948: IF l_resource_type_code = 'EMPLOYEE' THEN
3949:
3950: SELECT hzp.party_name
3951: INTO l_name
3952: FROM per_all_people_f peo, hz_parties hzp
3953: WHERE peo.person_id = p_resource_source_id
3954: AND sysdate BETWEEN peo.effective_start_date AND
3955: peo.effective_end_date
3956: AND peo.party_id = hzp.party_id;

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

4233: -- 28-APR-2003 shyugen
4234:
4235: FUNCTION get_person_name_no_date(p_person_id IN NUMBER) RETURN VARCHAR IS
4236:
4237: l_person_name PER_all_PEOPLE_F.FULL_NAME%TYPE := null;
4238:
4239: BEGIN
4240:
4241: IF p_person_id IS NOT NULL THEN

Line 4245: FROM per_all_people_f

4241: IF p_person_id IS NOT NULL THEN
4242:
4243: SELECT full_name
4244: INTO l_person_name
4245: FROM per_all_people_f
4246: WHERE person_id = p_person_id
4247: AND effective_end_date = (SELECT MAX(effective_end_date)
4248: FROM per_all_people_f
4249: WHERE person_id = p_person_id);

Line 4248: FROM per_all_people_f

4244: INTO l_person_name
4245: FROM per_all_people_f
4246: WHERE person_id = p_person_id
4247: AND effective_end_date = (SELECT MAX(effective_end_date)
4248: FROM per_all_people_f
4249: WHERE person_id = p_person_id);
4250: END IF;
4251:
4252: RETURN l_person_name;

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

4310: v_return_status VARCHAR2(1);
4311: v_personid NUMBER;
4312: v_error_message_code fnd_new_messages.message_name%TYPE;
4313: l_start_date DATE;
4314: x_ManagerName PER_all_PEOPLE_F.FULL_NAME%TYPE :=null;
4315:
4316:
4317: BEGIN
4318: