DBA Data[Home] [Help]

APPS.PAY_CA_PAYROLL_ARCH dependencies on PER_PEOPLE_F

Line 187: per_people_f.

183: and removed nvl for
184: consolidation_set.
185: 18-JUL-2007 pganguly 115.37 6169715 Change the cursor cur_language,
186: added the missing date join with
187: per_people_f.
188:
189: *******************************************************************/
190:
191: /******************************************************************

Line 747: , per_people_f ppf

743:
744: cursor cur_language is
745: select ppf.correspondence_language person_language
746: from per_assignments_f paf
747: , per_people_f ppf
748: where paf.assignment_id = p_assignment_id
749: and p_curr_pymt_eff_date between paf.effective_start_date
750: and paf.effective_end_date
751: and ppf.person_id = paf.person_id