DBA Data[Home] [Help]

APPS.PAY_CA_PAYROLL_ARCH dependencies on PER_ASSIGNMENTS_F

Line 1214: from per_assignments_f paf

1210: and ppa.date_earned between ptp.start_date and ptp.end_date;
1211:
1212: cursor cur_language is
1213: select ppf.correspondence_language person_language
1214: from per_assignments_f paf
1215: , per_people_f ppf
1216: where paf.assignment_id = p_assignment_id
1217: and p_curr_pymt_eff_date between paf.effective_start_date
1218: and paf.effective_end_date

Line 1232: from per_assignments_f paf

1228:
1229: -- added for 13029997
1230: cursor cur_busgrp is
1231: select paf.business_group_id, paf.payroll_id
1232: from per_assignments_f paf
1233: where paf.assignment_id = p_assignment_id
1234: and p_curr_pymt_eff_date between paf.effective_start_date
1235: and paf.effective_end_date;
1236: