APPS.AP_WEB_PCARD_WORKFLOW_PKG dependencies on HR_EMPLOYEES_CURRENT_V

Line 349: l_log_employee_name HR_EMPLOYEES_CURRENT_V.full_name%TYPE;

345: l_debug_info VARCHAR2(200);
346: l_records_undistributed_flag BOOLEAN := FALSE;
347: l_num_records_updated NUMBER;
348:
349: l_log_employee_name HR_EMPLOYEES_CURRENT_V.full_name%TYPE;
350: l_log_employee_num HR_EMPLOYEES_CURRENT_V.employee_num%TYPE;
351: --bug5058949
352: --Performance fix
353:

Line 350: l_log_employee_num HR_EMPLOYEES_CURRENT_V.employee_num%TYPE;

346: l_records_undistributed_flag BOOLEAN := FALSE;
347: l_num_records_updated NUMBER;
348:
349: l_log_employee_name HR_EMPLOYEES_CURRENT_V.full_name%TYPE;
350: l_log_employee_num HR_EMPLOYEES_CURRENT_V.employee_num%TYPE;
351: --bug5058949
352: --Performance fix
353:
354: CURSOR Manager_Approval_Workflows IS

Line 421: from hr_employees_current_v

417: select full_name,
418: employee_num
419: into l_log_employee_name,
420: l_log_employee_num
421: from hr_employees_current_v
422: where employee_id = l_employee_id;
423:
424: -----------------------------
425: l_debug_info := 'Write employee info to log.';

Line 456: hr_employees_current_v hr,

452: AND EXISTS (SELECT 'feed distribution falls in this workflow'
453: FROM ap_expense_feed_lines fl,
454: ap_cards c,
455: ap_card_profiles cp,
456: hr_employees_current_v hr,
457: IBY_CREDITCARD IBY
458: WHERE fl.feed_line_id = fd.feed_line_id
459: AND c.card_reference_id=IBY.instrid
460: AND fl.card_id = c.card_id