APPS.PAY_IN_TRX_IDENTIFIERS dependencies on PER_PEOPLE_F

Line 109: l_emp_num per_people_f.employee_number%TYPE ;

105: )
106: RETURN VARCHAR2
107: IS
108:
109: l_emp_num per_people_f.employee_number%TYPE ;
110: l_emp_name1 per_people_f.full_name%TYPE ;
111: l_emp_name2 per_people_f.full_name%TYPE ;
112: l_emp_name3 per_people_f.full_name%TYPE ;
113: l_emp_bank hr_lookups.meaning%TYPE ;

Line 110: l_emp_name1 per_people_f.full_name%TYPE ;

106: RETURN VARCHAR2
107: IS
108:
109: l_emp_num per_people_f.employee_number%TYPE ;
110: l_emp_name1 per_people_f.full_name%TYPE ;
111: l_emp_name2 per_people_f.full_name%TYPE ;
112: l_emp_name3 per_people_f.full_name%TYPE ;
113: l_emp_bank hr_lookups.meaning%TYPE ;
114: l_emp_branch hr_lookups.meaning%TYPE ;

Line 111: l_emp_name2 per_people_f.full_name%TYPE ;

107: IS
108:
109: l_emp_num per_people_f.employee_number%TYPE ;
110: l_emp_name1 per_people_f.full_name%TYPE ;
111: l_emp_name2 per_people_f.full_name%TYPE ;
112: l_emp_name3 per_people_f.full_name%TYPE ;
113: l_emp_bank hr_lookups.meaning%TYPE ;
114: l_emp_branch hr_lookups.meaning%TYPE ;
115: l_emp_acc_name hr_lookups.meaning%TYPE ;

Line 112: l_emp_name3 per_people_f.full_name%TYPE ;

108:
109: l_emp_num per_people_f.employee_number%TYPE ;
110: l_emp_name1 per_people_f.full_name%TYPE ;
111: l_emp_name2 per_people_f.full_name%TYPE ;
112: l_emp_name3 per_people_f.full_name%TYPE ;
113: l_emp_bank hr_lookups.meaning%TYPE ;
114: l_emp_branch hr_lookups.meaning%TYPE ;
115: l_emp_acc_name hr_lookups.meaning%TYPE ;
116: l_emp_acc_num pay_external_accounts.segment1%TYPE ;

Line 153: , per_people_f per

149: , pay_pre_payments ppp
150: , pay_assignment_actions paa
151: , pay_payroll_actions ppa
152: , per_assignments_f asg
153: , per_people_f per
154: , hr_organization_units org
155: , pay_payment_types ppto
156: WHERE ppa.payroll_action_id = l_payroll_action_id
157: AND paa.assignment_action_id = l_assignment_action_id