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 1284: from per_addresses adrc,

1280: trim(substrb(decode(adrr.address_id, null,
1281: adrc.address_line1 || adrc.address_line2 || adrc.address_line3,
1282: adrr.address_line1 || adrr.address_line2 || adrr.address_line3), 1, 240))
1283: address
1284: from per_addresses adrc,
1285: per_addresses adrr,
1286: per_all_people_f per,
1287: per_all_assignments_f asg
1288: where asg.assignment_id = p_assignment_id

Line 1285: per_addresses adrr,

1281: adrc.address_line1 || adrc.address_line2 || adrc.address_line3,
1282: adrr.address_line1 || adrr.address_line2 || adrr.address_line3), 1, 240))
1283: address
1284: from per_addresses adrc,
1285: per_addresses adrr,
1286: per_all_people_f per,
1287: per_all_assignments_f asg
1288: where asg.assignment_id = p_assignment_id
1289: and p_effective_date

Line 1377: per_addresses adrc,

1373: fnd_number.canonical_to_number(cei.cei_information3) ESTIMATED_ANNUAL_INCOME,
1374: cei.cei_information6 DISABILITY_TYPE,
1375: cei.cei_information7 DISABILITY_DETAILS
1376: from per_all_people_f per,
1377: per_addresses adrc,
1378: per_addresses adrr,
1379: per_contact_extra_info_f cei,
1380: per_contact_relationships ctr
1381: where ctr.person_id = p_person_id

Line 1378: per_addresses adrr,

1374: cei.cei_information6 DISABILITY_TYPE,
1375: cei.cei_information7 DISABILITY_DETAILS
1376: from per_all_people_f per,
1377: per_addresses adrc,
1378: per_addresses adrr,
1379: per_contact_extra_info_f cei,
1380: per_contact_relationships ctr
1381: where ctr.person_id = p_person_id
1382: and cei.contact_relationship_id = ctr.contact_relationship_id

Line 1431: from per_addresses adrc2,

1427: trim(substrb(decode(adrr2.address_id, null,
1428: adrc2.address_line1 || adrc2.address_line2 || adrc2.address_line3,
1429: adrr2.address_line1 || adrr2.address_line2 || adrr2.address_line3), 1, 240))
1430: OE_ADDRESS
1431: from per_addresses adrc2,
1432: per_addresses adrr2,
1433: per_contact_relationships ctr2,
1434: per_all_people_f per,
1435: per_addresses adrc,

Line 1432: per_addresses adrr2,

1428: adrc2.address_line1 || adrc2.address_line2 || adrc2.address_line3,
1429: adrr2.address_line1 || adrr2.address_line2 || adrr2.address_line3), 1, 240))
1430: OE_ADDRESS
1431: from per_addresses adrc2,
1432: per_addresses adrr2,
1433: per_contact_relationships ctr2,
1434: per_all_people_f per,
1435: per_addresses adrc,
1436: per_addresses adrr,

Line 1435: per_addresses adrc,

1431: from per_addresses adrc2,
1432: per_addresses adrr2,
1433: per_contact_relationships ctr2,
1434: per_all_people_f per,
1435: per_addresses adrc,
1436: per_addresses adrr,
1437: per_contact_extra_info_f cei,
1438: per_contact_relationships ctr
1439: where ctr.person_id = p_person_id

Line 1436: per_addresses adrr,

1432: per_addresses adrr2,
1433: per_contact_relationships ctr2,
1434: per_all_people_f per,
1435: per_addresses adrc,
1436: per_addresses adrr,
1437: per_contact_extra_info_f cei,
1438: per_contact_relationships ctr
1439: where ctr.person_id = p_person_id
1440: and cei.contact_relationship_id = ctr.contact_relationship_id