APPS.PQP_ALIEN_EXPAT_WF_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 21: l_assignment_id per_all_assignments_f.assignment_id%type;

17: ,p_process_name in varchar2 ) IS
18: --
19: --
20: l_contact_source varchar2(50);
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;

Line 51: FROM per_all_assignments_f paf

47: AND hrl.lookup_type = 'PQP_US_ALIEN_INCOME_BALANCE';
48: --
49: cursor csr_getperid is
50: SELECT person_id
51: FROM per_all_assignments_f paf
52: WHERE assignment_id = l_assignment_id
53: and trunc(p_tran_date) between
54: paf.effective_start_date and
55: paf.effective_end_date;