APPS.PQH_FR_UTILITY dependencies on PER_ALL_PEOPLE_F

Line 497: from per_all_people_f

493: procedure employment_terms_validations (p_person_id in number, p_effective_date in varchar2)
494: IS
495: Cursor csr_chk_person IS
496: Select PER_INFORMATION15
497: from per_all_people_f
498: where person_id = p_person_id
499: and to_date(p_effective_date,'RRRR-MM-DD') between effective_start_date and effective_end_date;
500: --
501: Cursor csr_chk_career IS

Line 555: from per_all_people_f

551: IS
552:
553: Cursor csr_chk_person IS
554: Select null
555: from per_all_people_f
556: where person_id = p_person_id
557: and to_date(p_effective_date,'RRRR-MM-DD') between effective_start_date and effective_end_date;
558:
559: l_temp varchar2(10);

Line 823: from per_all_people_f per,

819: and trunc(sysdate) between date_from and nvl(date_to,hr_general.end_of_time);
820: --
821: Cursor csr_person_details IS
822: Select per.per_information15, pps.orig_hire_dt
823: from per_all_people_f per,
824: (SELECT min(PPS1.DATE_START) orig_hire_dt
825: FROM PER_PERIODS_OF_SERVICE PPS1
826: WHERE pps1.person_id = p_person_id) pps
827: where per.person_id =p_person_id

Line 833: from per_all_people_f

829:
830: /* --commented by deenath and replaced by above cursor
831: Cursor csr_person_details IS
832: Select per_information15,original_date_of_hire
833: from per_all_people_f
834: where person_id =p_person_id
835: and trunc(sysdate) between effective_start_date and effective_end_date;
836: */
837:

Line 1052: FROM per_all_people_F

1048:
1049: l_asg_dtls csr_asg_dtls%ROWTYPE;
1050: Cursor csr_agent_type(p_person_id IN Number, p_effective_date IN DATE) IS
1051: SELECT per_information15
1052: FROM per_all_people_F
1053: WHERE person_id = p_person_id
1054: AND p_effective_date BETWEEN effective_start_date and effective_end_date;
1055:
1056: l_agent_type VARCHAR2(30);

Line 2004: FROM per_all_people_f

2000: AND shared_type_id =(SELECT org_information1
2001: FROM hr_organization_information
2002: WHERE org_information_context = 'FR_PQH_GROUPING_UNIT_INFO'
2003: AND organization_id =(SELECT business_group_id
2004: FROM per_all_people_f
2005: WHERE person_id = p_person_id
2006: AND p_effective_date BETWEEN effective_start_date
2007: AND effective_end_date));
2008: --