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: 20-Feb-2012 abellur 115.38 13029997 Added get_3rdparty_cheque to
189: support/archive third party
190: cheque information.
191: 06-Mar-2012 abellur 115.39 13814029 Added fnd_date.date_to_canonical

Line 773: per_people_f ppf

769: addr.region_1,
770: addr.postal_code
771: from
772: per_addresses addr,
773: per_people_f ppf
774: where ppf.person_id = cp_payee_id
775: and ppf.business_group_id = cp_business_group_id
776: and cp_payment_date between ppf.effective_start_date
777: and ppf.effective_end_date

Line 1215: , per_people_f ppf

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
1219: and ppf.person_id = paf.person_id