APPS.PAY_CA_T4AEOY_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 479: l_prev_person_id per_all_people_f.person_id%type;

475: /* Variables used to hold the current values returned within the loop for
476: checking against the new values returned from within the loop on the
477: next iteration. */
478:
479: l_prev_person_id per_all_people_f.person_id%type;
480: l_prev_tax_unit_id hr_all_organization_units.organization_id%type;
481:
482: /* Variable to hold the jurisdiction code used as a context for state
483: reporting. */

Line 542: per_all_people_f ppf

538: ASG.effective_end_date effective_end_date
539: FROM per_all_assignments_f ASG,
540: pay_assignment_actions paa,
541: pay_payroll_actions ppa,
542: per_all_people_f ppf
543: WHERE ppa.effective_date between l_period_start
544: and l_period_end
545: AND ppa.action_type in ('R','Q','V','B','I')
546: AND ppa.business_group_id +0 = l_bus_group_id

Line 3461: , per_all_people_f PEOPLE

3457: l_organization_id,
3458: l_location_id
3459: from
3460: per_all_assignments_f ASSIGN
3461: , per_all_people_f PEOPLE
3462: , per_person_types PTYPE
3463: , fnd_sessions SES
3464: where l_date_earned BETWEEN ASSIGN.effective_start_date
3465: AND ASSIGN.effective_end_date

Line 3490: and PHONE.parent_table (+)= 'PER_ALL_PEOPLE_F'

3486: into l_employee_phone_no
3487: from per_phones PHONE ,
3488: fnd_sessions SES
3489: where PHONE.parent_id (+) = l_person_id
3490: and PHONE.parent_table (+)= 'PER_ALL_PEOPLE_F'
3491: and PHONE.phone_type (+)= 'W1'
3492: and l_date_earned BETWEEN NVL(PHONE.date_from,SES.effective_date)
3493: AND NVL(PHONE.date_to,SES.effective_date)
3494: and SES.session_id = USERENV('SESSIONID') ;