DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL2_CANCEL_PKG dependencies on PER_PEOPLE_F

Line 396: lv_employee_number per_people_f.employee_number%type;

392: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
393:
394:
395: lv_serial_number VARCHAR2(30);
396: lv_employee_number per_people_f.employee_number%type;
397: lv_message varchar2(240):= null;
398: lv_full_name per_people_f.full_name%type;
399: lv_record_name varchar2(100);
400: lv_prev_report_type pay_payroll_actions.report_type%TYPE;

Line 398: lv_full_name per_people_f.full_name%type;

394:
395: lv_serial_number VARCHAR2(30);
396: lv_employee_number per_people_f.employee_number%type;
397: lv_message varchar2(240):= null;
398: lv_full_name per_people_f.full_name%type;
399: lv_record_name varchar2(100);
400: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
401: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
402: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 761: from per_people_f

757: --Changes for bug 15886428 ends
758:
759: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is
760: select substr(full_name,1,48), employee_number
761: from per_people_f
762: where person_id = cp_person_id
763: order by effective_end_date desc;
764:
765: CURSOR check_arch_action_exists (p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) is