APPS.PAY_CA_T4_AMEND_MAG dependencies on PER_PEOPLE_F

Line 151: FROM per_people_f

147: -----
148: /* CURSOR get_warning_dtls_for_ee(cp_person_id IN NUMBER) IS
149: SELECT substr(full_name,1,48),
150: employee_number
151: FROM per_people_f
152: WHERE person_id = cp_person_id
153: ORDER BY effective_end_date DESC;
154: */
155: -----

Line 1211: l_person_id per_people_f.person_id%TYPE;

1207: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1208: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;
1209: -- l_asg_id NUMBER;
1210: l_neg_bal_exists BOOLEAN := FALSE;
1211: l_person_id per_people_f.person_id%TYPE;
1212: l_address_line1 per_addresses.address_line1%TYPE;
1213: l_address_line2 per_addresses.address_line2%TYPE;
1214: l_address_line3 per_addresses.address_line3%TYPE;
1215: l_city per_addresses.town_or_city%TYPE;