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.

[Home] [Help]

APPS.PAY_IP_RULES dependencies on PER_PEOPLE_F

Line 231: per_people_f ppf

227: paf.payroll_id
228: FROM pay_assignment_actions paa,
229: pay_payroll_actions ppa,
230: per_assignments_f paf,
231: per_people_f ppf
232: WHERE paa.assignment_action_id = p_asg_action_id
233: AND paa.payroll_action_id = ppa.payroll_action_id
234: AND paf.assignment_id = paa.assignment_id
235: AND ppa.effective_date BETWEEN paf.effective_start_date

Line 281: lv_maternal_last_name per_people_f.per_information1%TYPE;

277: lv_town_or_city hr_locations.town_or_city%TYPE;
278: lv_postal_code hr_locations.postal_code%TYPE;
279: lv_country hr_locations.country%TYPE;
280: lv_state hr_locations.region_2%TYPE;
281: lv_maternal_last_name per_people_f.per_information1%TYPE;
282: lv_first_name per_people_f.first_name%TYPE;
283: lv_last_name per_people_f.last_name%TYPE;
284: lv_middle_names per_people_f.middle_names%TYPE;
285: lv_order_name per_people_f.order_name%TYPE;

Line 282: lv_first_name per_people_f.first_name%TYPE;

278: lv_postal_code hr_locations.postal_code%TYPE;
279: lv_country hr_locations.country%TYPE;
280: lv_state hr_locations.region_2%TYPE;
281: lv_maternal_last_name per_people_f.per_information1%TYPE;
282: lv_first_name per_people_f.first_name%TYPE;
283: lv_last_name per_people_f.last_name%TYPE;
284: lv_middle_names per_people_f.middle_names%TYPE;
285: lv_order_name per_people_f.order_name%TYPE;
286: lv_full_name per_people_f.full_name%TYPE;

Line 283: lv_last_name per_people_f.last_name%TYPE;

279: lv_country hr_locations.country%TYPE;
280: lv_state hr_locations.region_2%TYPE;
281: lv_maternal_last_name per_people_f.per_information1%TYPE;
282: lv_first_name per_people_f.first_name%TYPE;
283: lv_last_name per_people_f.last_name%TYPE;
284: lv_middle_names per_people_f.middle_names%TYPE;
285: lv_order_name per_people_f.order_name%TYPE;
286: lv_full_name per_people_f.full_name%TYPE;
287: lv_payroll_id pay_payrolls_f.payroll_id%TYPE;

Line 284: lv_middle_names per_people_f.middle_names%TYPE;

280: lv_state hr_locations.region_2%TYPE;
281: lv_maternal_last_name per_people_f.per_information1%TYPE;
282: lv_first_name per_people_f.first_name%TYPE;
283: lv_last_name per_people_f.last_name%TYPE;
284: lv_middle_names per_people_f.middle_names%TYPE;
285: lv_order_name per_people_f.order_name%TYPE;
286: lv_full_name per_people_f.full_name%TYPE;
287: lv_payroll_id pay_payrolls_f.payroll_id%TYPE;
288: lv_payroll_name pay_payrolls_f.payroll_name%TYPE;

Line 285: lv_order_name per_people_f.order_name%TYPE;

281: lv_maternal_last_name per_people_f.per_information1%TYPE;
282: lv_first_name per_people_f.first_name%TYPE;
283: lv_last_name per_people_f.last_name%TYPE;
284: lv_middle_names per_people_f.middle_names%TYPE;
285: lv_order_name per_people_f.order_name%TYPE;
286: lv_full_name per_people_f.full_name%TYPE;
287: lv_payroll_id pay_payrolls_f.payroll_id%TYPE;
288: lv_payroll_name pay_payrolls_f.payroll_name%TYPE;
289: ln_per_pay_method number;

Line 286: lv_full_name per_people_f.full_name%TYPE;

282: lv_first_name per_people_f.first_name%TYPE;
283: lv_last_name per_people_f.last_name%TYPE;
284: lv_middle_names per_people_f.middle_names%TYPE;
285: lv_order_name per_people_f.order_name%TYPE;
286: lv_full_name per_people_f.full_name%TYPE;
287: lv_payroll_id pay_payrolls_f.payroll_id%TYPE;
288: lv_payroll_name pay_payrolls_f.payroll_name%TYPE;
289: ln_per_pay_method number;
290: lv_account_type varchar2(2);