APPS.PN_CC_SYNC_PKG dependencies on PER_PEOPLE_F

Line 76: l_emp_name per_people_f.full_name%TYPE;

72: l_last_update_login pn_space_assign_emp.last_update_login%TYPE ;
73: l_err_msg1 VARCHAR2(2000);
74: l_source_id VARCHAR2(30) := 'PNCCSYNC';
75: l_batch_size NUMBER := 5000 ;
76: l_emp_name per_people_f.full_name%TYPE;
77: l_location_code pn_locations.location_code%TYPE;
78: l_success_msg VARCHAR2(1000) := NULL;
79: l_failure_msg VARCHAR2(1000) := NULL;
80: i NUMBER := 0;

Line 99: PER_PEOPLE_F

95: CURSOR get_emp_name (p_employee_id IN NUMBER, p_as_of_date DATE) IS
96: SELECT
97: FULL_NAME
98: FROM
99: PER_PEOPLE_F
100: WHERE person_id = p_employee_id
101: AND TRUNC(p_as_of_date) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
102: AND EMPLOYEE_NUMBER IS NOT NULL ;
103:

Line 761: PER_PEOPLE_F P,

757: SELECT
758: A.DEFAULT_CODE_COMB_ID,
759: P.FULL_NAME
760: FROM
761: PER_PEOPLE_F P,
762: PER_ALL_ASSIGNMENTS_F A,
763: PER_PERIODS_OF_SERVICE B
764: WHERE
765: A.PERSON_ID = P.PERSON_ID