eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_DEF_SS dependencies on PER_ADDRESSES

Line 1576: per_addresses adrr,

1572: adrr.address_line1 || adrr.address_line2 || adrr.address_line3), 1, 240)) address,
1573: decode(adrr.address_id,null,adrc.town_or_city,adrr.town_or_city) district_code
1574: from per_all_assignments_f asg,
1575: per_all_people_f per,
1576: per_addresses adrr,
1577: per_addresses adrc
1578: where asg.assignment_id = p_assignment_id
1579: and p_effective_date
1580: between asg.effective_start_date and asg.effective_end_date

Line 1577: per_addresses adrc

1573: decode(adrr.address_id,null,adrc.town_or_city,adrr.town_or_city) district_code
1574: from per_all_assignments_f asg,
1575: per_all_people_f per,
1576: per_addresses adrr,
1577: per_addresses adrc
1578: where asg.assignment_id = p_assignment_id
1579: and p_effective_date
1580: between asg.effective_start_date and asg.effective_end_date
1581: and per.person_id = asg.person_id

Line 1641: per_addresses adrr,

1637: cei.cei_information6 DISABILITY_TYPE,
1638: cei.cei_information7 DISABILITY_DETAILS
1639: from per_contact_relationships ctr,
1640: per_contact_extra_info_f cei,
1641: per_addresses adrr,
1642: per_addresses adrc,
1643: per_all_people_f per
1644: where ctr.person_id = p_person_id
1645: and cei.contact_relationship_id = ctr.contact_relationship_id

Line 1642: per_addresses adrc,

1638: cei.cei_information7 DISABILITY_DETAILS
1639: from per_contact_relationships ctr,
1640: per_contact_extra_info_f cei,
1641: per_addresses adrr,
1642: per_addresses adrc,
1643: per_all_people_f per
1644: where ctr.person_id = p_person_id
1645: and cei.contact_relationship_id = ctr.contact_relationship_id
1646: and cei.cei_information_category = 'JP_ITAX_DEPENDENT'

Line 1695: per_addresses adrr,

1691: adrc2.address_line1 || adrc2.address_line2 || adrc2.address_line3,
1692: adrr2.address_line1 || adrr2.address_line2 || adrr2.address_line3), 1, 240)) OE_ADDRESS
1693: from per_contact_relationships ctr,
1694: per_contact_extra_info_f cei,
1695: per_addresses adrr,
1696: per_addresses adrc,
1697: per_all_people_f per,
1698: per_contact_relationships ctr2,
1699: per_addresses adrr2,

Line 1696: per_addresses adrc,

1692: adrr2.address_line1 || adrr2.address_line2 || adrr2.address_line3), 1, 240)) OE_ADDRESS
1693: from per_contact_relationships ctr,
1694: per_contact_extra_info_f cei,
1695: per_addresses adrr,
1696: per_addresses adrc,
1697: per_all_people_f per,
1698: per_contact_relationships ctr2,
1699: per_addresses adrr2,
1700: per_addresses adrc2

Line 1699: per_addresses adrr2,

1695: per_addresses adrr,
1696: per_addresses adrc,
1697: per_all_people_f per,
1698: per_contact_relationships ctr2,
1699: per_addresses adrr2,
1700: per_addresses adrc2
1701: where ctr.person_id = p_person_id
1702: and cei.contact_relationship_id = ctr.contact_relationship_id
1703: and cei.cei_information_category = 'JP_ITAX_DEPENDENT_ON_OTHER_EMP'

Line 1700: per_addresses adrc2

1696: per_addresses adrc,
1697: per_all_people_f per,
1698: per_contact_relationships ctr2,
1699: per_addresses adrr2,
1700: per_addresses adrc2
1701: where ctr.person_id = p_person_id
1702: and cei.contact_relationship_id = ctr.contact_relationship_id
1703: and cei.cei_information_category = 'JP_ITAX_DEPENDENT_ON_OTHER_EMP'
1704: and p_effective_date