APPS.PAY_SG_DEDUCTIONS dependencies on PER_ALL_PEOPLE_F

Line 142: from per_all_people_f per

138: , to_date(per_information9, 'YYYY/MM/DD HH24:MI:SS')
139: , to_date(per_information10, 'YYYY/MM/DD HH24:MI:SS')
140: , to_date(per_information11, 'YYYY/MM/DD HH24:MI:SS')
141: , effective_start_date
142: from per_all_people_f per
143: where per.person_id = (select max(paf.person_id)
144: from per_all_assignments_f paf
145: where paf.assignment_id = p_assignment_id)
146: and per.per_information6 = 'WP'

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

151:
152: /*Bug#5410589 - Following cursor has been added to check whether permit category is valid
153: for this pay period or not*/
154:
155: cursor c_check_permit_type(p_permit_category per_all_people_f.per_information8%type
156: ,p_date_earned DATE)
157: is
158: select CINST.value
159: from pay_user_tables tab

Line 371: from per_all_people_f per

367: select per_information6
368: , to_date(per_information9, 'YYYY/MM/DD HH24:MI:SS')
369: , to_date(per_information10, 'YYYY/MM/DD HH24:MI:SS')
370: , to_date(per_information11, 'YYYY/MM/DD HH24:MI:SS')
371: from per_all_people_f per
372: where per.person_id = (select max(paf.person_id)
373: from per_all_assignments_f paf
374: where paf.assignment_id = p_assignment_id)
375: and per.per_information6 = 'SP'

Line 508: from per_all_people_f pap,

504: c_pay_proc_start_date date,
505: c_pay_proc_end_date date)
506: is
507: select min(pap.effective_start_date),max(pap.effective_end_date) /*bug 2772106 */
508: from per_all_people_f pap,
509: per_all_assignments_f target
510: where target.assignment_id = c_assignment_id
511: and pap.person_id = target.person_id
512: and nvl(pap.current_employee_flag,'N') = 'Y';

Line 519: from per_all_people_f target

515: c_date DATE )
516: is
517: select target.PER_INFORMATION6,
518: target.EFFECTIVE_START_DATE
519: from per_all_people_f target
520: where target.person_id = (select paf.person_id
521: from per_all_assignments_f paf
522: where paf.assignment_id = c_assignment_id
523: and c_date between paf.effective_start_date and paf.effective_end_date )