APPS.PQP_ALIEN_EXPAT_WF_PKG dependencies on HR_LOOKUPS

Line 33: l_income_desc hr_lookups.meaning%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: --
35: --
36: --
37: cursor csr_getpayprcdet is

Line 44: FROM pqp_alien_transaction_data ptd, hr_lookups hrl

40: WHERE process_event_id = p_process_event_id;
41: --
42: cursor csr_getaliendet is
43: SELECT ptd.error_indicator, ptd.error_text, ptd.income_code, hrl.meaning
44: FROM pqp_alien_transaction_data ptd, hr_lookups hrl
45: WHERE alien_transaction_id = p_alien_transaction_id
46: AND ptd.income_code = hrl.lookup_code
47: AND hrl.lookup_type = 'PQP_US_ALIEN_INCOME_BALANCE';
48: --