DBA Data[Home] [Help]

APPS.PAY_CA_PAYREG_EXTRACT_PKG dependencies on PER_ALL_PEOPLE_F

Line 690: from per_all_people_f ppf

686: ,paa_key.assignment_action_id
687: ,paa_key.date_earned
688: ,paa_key.effective_date /* BUG: 5383895 paa_key.date_earned changed to paa_key.effective_date */
689: ,popm.defined_balance_id /* BUG: 5383895 added to avoid the cursor c_tp_pmt_check */
690: from per_all_people_f ppf
691: ,per_all_assignments_f paf
692: ,hr_all_organization_units_tl hou
693: ,pay_all_payrolls_f pap
694: ,pay_payment_types_tl ppt_tl

Line 894: from per_all_people_f ppf

890: /* Query to get the payee_name for payee_type 'P'
891: Added this curosr to fix bug#2745577 */
892: cursor c_payee_full_name (cp_payee_id number,cp_effective_date date) IS /* BUG: 5383895 cp_date_earned changed to cp_effective_date */
893: select initcap(rtrim(ppf.title))||' '||rtrim(ppf.first_name)||' '||rtrim(ppf.last_name)
894: from per_all_people_f ppf
895: where ppf.person_id = cp_payee_id
896: and cp_effective_date between ppf.effective_start_date and
897: ppf.effective_end_date; /* BUG: 5383895 cp_date_earned changed to cp_effective_date */
898: