eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_DIRECT_DEPOSIT_XML dependencies on PER_ALL_PEOPLE_F

Line 161: per_all_people_f ppf,

157: SELECT ppf.first_name, ppf.last_name, ppf.middle_names, ppf.order_name,
158: ppf.full_name, ppf.national_identifier,
159: ppf.employee_number
160: FROM per_assignments_f paf,
161: per_all_people_f ppf,
162: per_periods_of_service pps
163: WHERE paf.person_id = ppf.person_id
164: and paf.assignment_id = p_assignment_id
165: and p_effective_date between paf.effective_start_date

Line 190: lv_first_name per_all_people_f.first_name%TYPE;

186: and pp.effective_end_date;
187:
188:
189: l_org_payment_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;
190: lv_first_name per_all_people_f.first_name%TYPE;
191: lv_last_name per_all_people_f.last_name%TYPE;
192: lv_middle_names per_all_people_f.middle_names%TYPE;
193: lv_order_name per_all_people_f.order_name%TYPE;
194: lv_full_name per_all_people_f.full_name%TYPE;

Line 191: lv_last_name per_all_people_f.last_name%TYPE;

187:
188:
189: l_org_payment_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;
190: lv_first_name per_all_people_f.first_name%TYPE;
191: lv_last_name per_all_people_f.last_name%TYPE;
192: lv_middle_names per_all_people_f.middle_names%TYPE;
193: lv_order_name per_all_people_f.order_name%TYPE;
194: lv_full_name per_all_people_f.full_name%TYPE;
195: lv_national_identifier per_all_people_f.national_identifier%TYPE;

Line 192: lv_middle_names per_all_people_f.middle_names%TYPE;

188:
189: l_org_payment_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;
190: lv_first_name per_all_people_f.first_name%TYPE;
191: lv_last_name per_all_people_f.last_name%TYPE;
192: lv_middle_names per_all_people_f.middle_names%TYPE;
193: lv_order_name per_all_people_f.order_name%TYPE;
194: lv_full_name per_all_people_f.full_name%TYPE;
195: lv_national_identifier per_all_people_f.national_identifier%TYPE;
196: lv_employee_number per_all_people_f.employee_number%TYPE;

Line 193: lv_order_name per_all_people_f.order_name%TYPE;

189: l_org_payment_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;
190: lv_first_name per_all_people_f.first_name%TYPE;
191: lv_last_name per_all_people_f.last_name%TYPE;
192: lv_middle_names per_all_people_f.middle_names%TYPE;
193: lv_order_name per_all_people_f.order_name%TYPE;
194: lv_full_name per_all_people_f.full_name%TYPE;
195: lv_national_identifier per_all_people_f.national_identifier%TYPE;
196: lv_employee_number per_all_people_f.employee_number%TYPE;
197: ln_business_group_id number;

Line 194: lv_full_name per_all_people_f.full_name%TYPE;

190: lv_first_name per_all_people_f.first_name%TYPE;
191: lv_last_name per_all_people_f.last_name%TYPE;
192: lv_middle_names per_all_people_f.middle_names%TYPE;
193: lv_order_name per_all_people_f.order_name%TYPE;
194: lv_full_name per_all_people_f.full_name%TYPE;
195: lv_national_identifier per_all_people_f.national_identifier%TYPE;
196: lv_employee_number per_all_people_f.employee_number%TYPE;
197: ln_business_group_id number;
198: ln_per_pay_method number;

Line 195: lv_national_identifier per_all_people_f.national_identifier%TYPE;

191: lv_last_name per_all_people_f.last_name%TYPE;
192: lv_middle_names per_all_people_f.middle_names%TYPE;
193: lv_order_name per_all_people_f.order_name%TYPE;
194: lv_full_name per_all_people_f.full_name%TYPE;
195: lv_national_identifier per_all_people_f.national_identifier%TYPE;
196: lv_employee_number per_all_people_f.employee_number%TYPE;
197: ln_business_group_id number;
198: ln_per_pay_method number;
199: ln_pre_pay_id number;

Line 196: lv_employee_number per_all_people_f.employee_number%TYPE;

192: lv_middle_names per_all_people_f.middle_names%TYPE;
193: lv_order_name per_all_people_f.order_name%TYPE;
194: lv_full_name per_all_people_f.full_name%TYPE;
195: lv_national_identifier per_all_people_f.national_identifier%TYPE;
196: lv_employee_number per_all_people_f.employee_number%TYPE;
197: ln_business_group_id number;
198: ln_per_pay_method number;
199: ln_pre_pay_id number;
200: ln_prepay_asg_act number;