DBA Data[Home] [Help]

APPS.PQP_GB_PSI_FUNCTIONS dependencies on PER_ALL_PEOPLE_F

Line 4355: ,p_person_dtl OUT NOCOPY per_all_people_f%rowtype

4351: FUNCTION chk_penserver_basic_criteria
4352: (p_business_group_id IN NUMBER
4353: ,p_effective_date IN DATE
4354: ,p_assignment_id IN NUMBER
4355: ,p_person_dtl OUT NOCOPY per_all_people_f%rowtype
4356: ,p_assignment_dtl OUT NOCOPY per_all_assignments_f%rowtype
4357: ) RETURN VARCHAR2 -- Y or N
4358: IS
4359:

Line 4370: l_person_dtl per_all_people_f%rowtype;

4366: l_assignment_category VARCHAR2(30):= NULL;
4367: l_last_hire_date_indicator VARCHAR2(1) := NULL;
4368: l_person_id NUMBER;
4369:
4370: l_person_dtl per_all_people_f%rowtype;
4371: l_assignment_dtl per_all_assignments_f%rowtype;
4372: i NUMBER;
4373: l_index NUMBER;
4374: l_value NUMBER;

Line 5425: l_curr_person_dtls per_all_people_f%ROWTYPE;

5421: l_include VARCHAR2(10) := 'Y';
5422: l_assignment_status_type_id NUMBER;
5423: l_pay_assg_status VARCHAR2(20);
5424: l_per_assg_status per_assignment_status_types.per_system_status%TYPE;
5425: l_curr_person_dtls per_all_people_f%ROWTYPE;
5426: -- this contains the person details on effective date
5427:
5428: l_curr_assg_dtls per_all_assignments_f%ROWTYPE;
5429: -- this contains the person details on effective date