DBA Data[Home] [Help]

APPS.PAY_GB_MOVDED_EDI dependencies on PER_PEOPLE_F

Line 908: per_people_f pap,

904: fnd_date.date_to_canonical(pap.date_of_birth) date_of_birth,
905: fnd_date.date_to_canonical(decode(pap.current_employee_flag, 'Y', serv.date_start, null)) hire_date
906: from pay_assignment_actions act,
907: per_assignments_f paa,
908: per_people_f pap,
909: per_periods_of_service serv
910: where act.assignment_action_id = p_assactid
911: and act.assignment_id = paa.assignment_id
912: and paa.person_id = pap.person_id

Line 1607: 'from per_people_f ppf, '||

1603: END IF;
1604: /* Changes for P45PT3 end*/
1605:
1606: sqlstr := 'select distinct person_id '||
1607: 'from per_people_f ppf, '||
1608: 'pay_payroll_actions ppa '||
1609: 'where ppa.payroll_action_id = :payroll_action_id '||
1610: 'and ppa.business_group_id = ppf.business_group_id '||
1611: 'order by ppf.person_id';