APPS.PA_BILLING_SETUP_UTILS dependencies on PA_EMPLOYEES

Line 275: FROM pa_employees

271:
272: CURSOR c_ids
273: IS
274: SELECT person_id
275: FROM pa_employees
276: WHERE full_name = p_person_name;
277:
278:
279: BEGIN

Line 286: FROM pa_employees

282: IF p_check_id_flag = 'Y'
283: THEN
284: SELECT person_id
285: INTO x_person_id
286: FROM pa_employees
287: WHERE person_id = p_person_id;
288: ELSIF p_check_id_flag = 'N'
289: THEN
290: x_person_id := p_person_id;

Line 327: FROM pa_employees

323: IF p_person_name IS NOT NULL
324: THEN
325: SELECT person_id
326: INTO x_person_id
327: FROM pa_employees
328: WHERE full_name = p_person_name;
329: ELSE
330: x_person_id := null;
331: END IF;

Line 559: FROM pa_employees

555:
556: CURSOR c_ids
557: IS
558: SELECT person_id
559: FROM pa_employees
560: WHERE employee_number = p_emp_number;
561:
562: BEGIN
563: IF p_person_id IS NOT NULL

Line 569: FROM pa_employees

565: IF p_check_id_flag = 'Y'
566: THEN
567: SELECT person_id
568: INTO x_person_id
569: FROM pa_employees
570: WHERE person_id = p_person_id;
571: ELSIF p_check_id_flag = 'N'
572: THEN
573: x_person_id := p_person_id;

Line 610: FROM pa_employees

606: IF p_emp_number IS NOT NULL
607: THEN
608: SELECT person_id
609: INTO x_person_id
610: FROM pa_employees
611: WHERE employee_number = p_emp_number;
612: ELSE
613: x_person_id := null;
614: END IF;