APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PER_PEOPLE_X

Line 571: * from the per_people_x view as it filters those where

567: * Description : This Subprog checks if the resource is a contingent
568: * worker or not, If it is a contingent worker Then
569: * then it returns 'Y' Else returns 'N'. To Check
570: * for Contingent worker we are directly looking it up
571: * from the per_people_x view as it filters those where
572: * sysdate between effective start and end date.
573: * Also checks to see if the current_npw_flag = 'Y'
574: ************************************************************************/
575: Function Is_Contingent_Worker(p_person_id IN VARCHAR2) Return VARCHAR2

Line 581: --FROM per_people_x

577: l_cwk_flag VARCHAR2(30) := null;
578: BEGIN
579: SELECT 'Y'
580: INTO l_cwk_flag
581: --FROM per_people_x
582: FROM per_all_people_f
583: WHERE person_id = p_person_id
584: AND current_npw_flag = 'Y'
585: AND trunc(sysdate) between trunc(effective_start_date) AND

Line 681: * And selecting from per_people_x to keep it

677: /****************************************************
678: * Bug - 3523947
679: * Desc - Modified the cursor c_ids. Removed the check
680: * where sysdate between eff start and end date.
681: * And selecting from per_people_x to keep it
682: * consistent with the other selects.
683: ***************************************************/
684: Cursor c_ids IS
685: SELECT person_id

Line 687: FROM per_people_x

683: ***************************************************/
684: Cursor c_ids IS
685: SELECT person_id
686: --FROM per_all_people_f
687: FROM per_people_x
688: WHERE full_name = p_person_name;
689: --AND trunc(sysdate) between trunc(effective_start_date) AND
690: --trunc(effective_end_date);
691: BEGIN

Line 699: FROM per_people_x

695: IF (p_check_id_flag = 'Y') THEN
696: BEGIN
697: SELECT person_id
698: INTO l_person_id
699: FROM per_people_x
700: WHERE person_id = p_person_id;
701: x_person_id := l_person_id;
702: EXCEPTION
703: WHEN OTHERS THEN

Line 757: FROM per_people_x

753: IF (p_person_name IS NOT NULL) THEN
754: BEGIN
755: SELECT person_id
756: INTO l_person_id
757: FROM per_people_x
758: WHERE full_name = p_person_name;
759: x_person_id := l_person_id;
760: EXCEPTION
761: WHEN OTHERS THEN

Line 2961: * Per_people_x table to derive the

2957: UNEXPEC_ERROR Exception;
2958: /*************************************************
2959: * Bug - 3485392
2960: * Description - Using the Known_as field from the
2961: * Per_people_x table to derive the
2962: * resource_name. If the known_as field is
2963: * Null then select the full_name.
2964: *************************************************/
2965: Cursor c_People (P_Person_Id IN Number) is

Line 2971: Per_People_X

2967: --nvl(known_as,Full_Name)
2968: --Bug 3485392
2969: Full_Name
2970: From
2971: Per_People_X
2972: Where
2973: Person_Id = P_Person_Id
2974: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
2975: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Business_Group_Id)

Line 4269: Per_People_X

4265: Cursor c_People (P_Person_Id IN Number) is
4266: Select
4267: Full_Name
4268: From
4269: Per_People_X
4270: Where
4271: Person_Id = P_Person_Id
4272: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
4273: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Business_Group_Id)

Line 4739: From Per_People_X

4735: --Select decode(known_as,null,full_name,known_as||' ('||last_name||')')
4736: --Bug 10327524
4737: Select Full_Name
4738: INTO l_Res_Type_Displayed
4739: From Per_People_X
4740: Where Person_Id = Res_List_Member_Rec.Person_Id;
4741: END;
4742: END IF;
4743: X_Resource_Alias := substr(l_Res_Type_Displayed,1,Res_Format_Rec.Resource_Type_Disp_Chars);

Line 4915: FROM Per_People_X

4911: IF Res_List_Member_Rec.Person_Id IS NOT NULL THEN
4912: BEGIN
4913: SELECT nvl(known_as,Full_Name)
4914: INTO l_Res_Incur_By_alias
4915: FROM Per_People_X
4916: WHERE Person_Id = Res_List_Member_Rec.Person_Id;
4917: END;
4918: END IF;
4919: End If;