APPS.PAY_IE_WNU_EDI dependencies on PER_ADDRESSES

Line 71: per_addresses pad,

67: pay_assignment_actions act,
68: pay_payroll_actions ppa,
69: per_all_assignments_f assign,
70: per_all_people_f people,
71: per_addresses pad,
72: pay_all_payrolls_f ppayf
73: where act.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
74: and ppa.payroll_action_id = act.payroll_action_id
75: and act.assignment_id = assign.assignment_id

Line 80: -- For bug 5114019, added a join with per_addresses date as a person can have

76: and ppayf.payroll_id = assign.payroll_id
77: and assign.person_id = people.person_id
78: and pad.person_id(+) = people.person_id
79: and NVL(pad.PRIMARY_FLAG,'Y') = 'Y'
80: -- For bug 5114019, added a join with per_addresses date as a person can have
81: -- datetrack primary addresses.
82: and ppa.effective_date between
83: nvl(pad.date_from,ppa.effective_date) and nvl(pad.date_to,to_date('31/12/4712','dd/mm/yyyy'))
84: -- End bug 5114019