[Home] [Help]
21: l_assignment_id per_all_assignments_f.assignment_id%type;
22: l_description pay_process_events.description%type;
23: l_error_indicator pqp_alien_transaction_data.error_indicator%type;
24: l_error_text pqp_alien_transaction_data.error_text%type;
25: l_person_id per_all_people_f.person_id%type;
26: l_next_contact_person_id per_all_people_f.person_id%type;
27: l_contact_user_name wf_users.name%type;
28: l_emp_username wf_users.name%type;
29: l_emp_disp_name wf_users.display_name%type;
22: l_description pay_process_events.description%type;
23: l_error_indicator pqp_alien_transaction_data.error_indicator%type;
24: l_error_text pqp_alien_transaction_data.error_text%type;
25: l_person_id per_all_people_f.person_id%type;
26: l_next_contact_person_id per_all_people_f.person_id%type;
27: l_contact_user_name wf_users.name%type;
28: l_emp_username wf_users.name%type;
29: l_emp_disp_name wf_users.display_name%type;
30: l_emp_full_name per_all_people_f.full_name%type;
26: l_next_contact_person_id per_all_people_f.person_id%type;
27: l_contact_user_name wf_users.name%type;
28: l_emp_username wf_users.name%type;
29: l_emp_disp_name wf_users.display_name%type;
30: l_emp_full_name per_all_people_f.full_name%type;
31: l_item_key wf_items.item_key%type;
32: l_income_code pqp_alien_transaction_data.income_code%type;
33: l_income_desc hr_lookups.meaning%type;
34: --
55: paf.effective_end_date;
56: --
57: cursor csr_getperdet is
58: SELECT full_name
59: FROM per_all_people_f pap
60: WHERE person_id = l_person_id
61: and trunc(p_tran_date) between
62: pap.effective_start_date and
63: pap.effective_end_date;
262: aname => 'PERSON_ID',
263: avalue => l_person_id );
264: --
265:
266: -- If Emp Name is not in WF Dir services then get from PER_ALL_PEOPLE_F
267: if l_emp_disp_name Is Null then
268: open csr_getperdet;
269: fetch csr_getperdet into l_emp_full_name;
270: close csr_getperdet;