DBA Data[Home] [Help]

APPS.PQP_GB_PSI_FUNCTIONS dependencies on PER_ALL_PEOPLE_F

Line 4427: ,p_person_dtl OUT NOCOPY per_all_people_f%rowtype

4423: FUNCTION chk_penserver_basic_criteria
4424: (p_business_group_id IN NUMBER
4425: ,p_effective_date IN DATE
4426: ,p_assignment_id IN NUMBER
4427: ,p_person_dtl OUT NOCOPY per_all_people_f%rowtype
4428: ,p_assignment_dtl OUT NOCOPY per_all_assignments_f%rowtype
4429: ) RETURN VARCHAR2 -- Y or N
4430: IS
4431:

Line 4442: l_person_dtl per_all_people_f%rowtype;

4438: l_assignment_category VARCHAR2(30):= NULL;
4439: l_last_hire_date_indicator VARCHAR2(1) := NULL;
4440: l_person_id NUMBER;
4441:
4442: l_person_dtl per_all_people_f%rowtype;
4443: l_assignment_dtl per_all_assignments_f%rowtype;
4444: i NUMBER;
4445: l_index NUMBER;
4446: l_value NUMBER;

Line 5535: l_curr_person_dtls per_all_people_f%ROWTYPE;

5531: l_include VARCHAR2(10) := 'Y';
5532: l_assignment_status_type_id NUMBER;
5533: l_pay_assg_status VARCHAR2(20);
5534: l_per_assg_status per_assignment_status_types.per_system_status%TYPE;
5535: l_curr_person_dtls per_all_people_f%ROWTYPE;
5536: -- this contains the person details on effective date
5537:
5538: l_curr_assg_dtls per_all_assignments_f%ROWTYPE;
5539: -- this contains the person details on effective date