APPS.PAY_CA_T4A_AMEND_MAG dependencies on PER_PEOPLE_F

Line 153: FROM per_people_f

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

Line 190: -- lv_full_name per_people_f.full_name%TYPE;

186: lv_report_type pay_payroll_actions.report_type%TYPE ;
187: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;--
188: -- ln_gre_id_null NUMBER;
189: -- ln_iteration NUMBER := 0;
190: -- lv_full_name per_people_f.full_name%TYPE;
191: -- lv_employee_number per_people_f.employee_number%TYPE;
192: -- lv_message VARCHAR2(100):= NULL;
193: -- lv_record_name VARCHAR2(100);
194: lv_fed_amend_flag VARCHAR2(5);

Line 191: -- lv_employee_number per_people_f.employee_number%TYPE;

187: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;--
188: -- ln_gre_id_null NUMBER;
189: -- ln_iteration NUMBER := 0;
190: -- lv_full_name per_people_f.full_name%TYPE;
191: -- lv_employee_number per_people_f.employee_number%TYPE;
192: -- lv_message VARCHAR2(100):= NULL;
193: -- lv_record_name VARCHAR2(100);
194: lv_fed_amend_flag VARCHAR2(5);
195: ln_t4a_amend_flag_ue_id NUMBER;

Line 1232: l_person_id per_people_f.person_id%TYPE;

1228: l_arch_pay_actid NUMBER;
1229: l_asg_id NUMBER;
1230: l_neg_bal_exists BOOLEAN := FALSE;
1231:
1232: l_person_id per_people_f.person_id%TYPE;
1233: l_address_line1 per_addresses.address_line1%TYPE;
1234: l_address_line2 per_addresses.address_line2%TYPE;
1235: l_address_line3 per_addresses.address_line3%TYPE;
1236: l_city per_addresses.town_or_city%TYPE;