APPS.PAY_SG_DEDUCTIONS dependencies on PER_ALL_PEOPLE_F

Line 157: from per_all_people_f per

153: , to_date(per_information9, 'YYYY/MM/DD HH24:MI:SS')
154: , to_date(per_information10, 'YYYY/MM/DD HH24:MI:SS')
155: , to_date(per_information11, 'YYYY/MM/DD HH24:MI:SS')
156: , effective_start_date
157: from per_all_people_f per
158: where per.person_id = (select max(paf.person_id)
159: from per_all_assignments_f paf
160: where paf.assignment_id = p_assignment_id)
161: and per.per_information6 = 'WP'

Line 171: cursor c_check_permit_type(p_permit_category per_all_people_f.per_information8%type

167:
168: /*Bug#5410589 - Following cursor has been added to check whether permit category is valid
169: for this pay period or not*/
170:
171: cursor c_check_permit_type(p_permit_category per_all_people_f.per_information8%type
172: ,p_date_earned DATE)
173: is
174: select CINST.value
175: from pay_user_tables tab

Line 395: from per_all_people_f per

391: , to_date(per_information9, 'YYYY/MM/DD HH24:MI:SS')
392: , to_date(per_information10, 'YYYY/MM/DD HH24:MI:SS')
393: , to_date(per_information11, 'YYYY/MM/DD HH24:MI:SS')
394: , effective_start_date
395: from per_all_people_f per
396: where per.person_id = (select max(paf.person_id)
397: from per_all_assignments_f paf
398: where paf.assignment_id = p_assignment_id)
399: and per.per_information6 = 'SP'

Line 405: cursor c_check_permit_type(p_permit_category per_all_people_f.per_information8%type

401: and per.effective_start_date <= p_end_date
402: and per.effective_end_date >= p_start_date)
403: order by effective_start_date;
404:
405: cursor c_check_permit_type(p_permit_category per_all_people_f.per_information8%type
406: ,p_date_earned DATE)
407: is
408: select CINST.value
409: from pay_user_tables tab

Line 619: from per_all_people_f pap,

615: c_pay_proc_start_date date,
616: c_pay_proc_end_date date)
617: is
618: select min(pap.effective_start_date),max(pap.effective_end_date) /*bug 2772106 */
619: from per_all_people_f pap,
620: per_all_assignments_f target
621: where target.assignment_id = c_assignment_id
622: and pap.person_id = target.person_id
623: and nvl(pap.current_employee_flag,'N') = 'Y';

Line 630: from per_all_people_f target

626: c_date DATE )
627: is
628: select target.PER_INFORMATION6,
629: target.EFFECTIVE_START_DATE
630: from per_all_people_f target
631: where target.person_id = (select paf.person_id
632: from per_all_assignments_f paf
633: where paf.assignment_id = c_assignment_id
634: and c_date between paf.effective_start_date and paf.effective_end_date )