DBA Data[Home] [Help]

APPS.PAY_FR_DADS_EMP_PKG dependencies on PER_ADDRESSES

Line 78: , per_addresses pa

74: , ppf.employee_number employee_number -- this will be the id2 column
75: From per_all_people_f ppf
76: , per_all_assignments_f paf
77: , pay_assignment_actions paa
78: , per_addresses pa
79: , fnd_territories ft
80: , fnd_territories_tl ft_tl
81: , fnd_territories ft1
82: , fnd_territories_tl ft1_tl

Line 108: l_address_id per_addresses.address_id%type;

104: --
105: l_emp_rec cur_emp_data%rowtype;
106: l_name VARCHAR2(250);
107: l_person_id per_all_people_f.person_id%type;
108: l_address_id per_addresses.address_id%type;
109: l_location_id per_all_assignments_f.location_id%type;
110:
111: p_id Number;
112: l_id2 per_all_people_f.employee_number%type;