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.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on PER_ALL_PEOPLE_F

Line 1154: from per_all_people_f ppf,

1150: ppf.party_id,
1151: ppf.person_id,
1152: cshcp.contact_type,
1153: cshcp.sr_contact_point_id
1154: from per_all_people_f ppf,
1155: cs_hz_sr_contact_points cshcp
1156: where cshcp.INCIDENT_ID = l_request_id
1157: AND cshcp.PRIMARY_FLAG = 'Y'
1158: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'

Line 1266: from per_all_people_f ppf,

1262: ppf.party_id,
1263: ppf.person_id,
1264: cshcp.contact_type,
1265: cshcp.sr_contact_point_id
1266: from per_all_people_f ppf,
1267: cs_hz_sr_contact_points cshcp
1268: where cshcp.INCIDENT_ID = l_request_id
1269: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1270: AND ppf.person_id = cshcp.party_id

Line 1301: from per_all_people_f ppf,

1297: ppf.party_id,
1298: ppf.person_id,
1299: cshcp.contact_type,
1300: cshcp.sr_contact_point_id
1301: from per_all_people_f ppf,
1302: cs_hz_sr_contact_points cshcp
1303: where cshcp.INCIDENT_ID = l_request_id
1304: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1305: AND ppf.person_id = cshcp.party_id

Line 1334: FROM per_all_people_f ppf,

1330: ppf.party_id,
1331: ppf.person_id,
1332: cshcp.contact_type,
1333: cshcp.sr_contact_point_id
1334: FROM per_all_people_f ppf,
1335: cs_hz_sr_contact_points cshcp
1336: WHERE
1337: cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1338: AND ppf.PERSON_ID = l_contact_point_id

Line 1372: FROM per_all_people_f ppf,

1368: cshcp.contact_type,
1369: cshcp.sr_contact_point_id,
1370: cpr.name,
1371: cpr.party_role_code
1372: FROM per_all_people_f ppf,
1373: cs_hz_sr_contact_points cshcp,
1374: cs_party_roles_tl cpr
1375: WHERE
1376: cshcp.CONTACT_POINT_TYPE = 'EMAIL'

Line 1522: -- 1) PER_ALL_PEOPLE_F - for contact type = EMPLOYEE

1518: -- The following cursor is needed to derive the contact's name.
1519: -- At the point of opening this cursor, we already have the contact point id.
1520: -- We use this contact point id to go against the following 2 tables to derive the
1521: -- contact's full name :
1522: -- 1) PER_ALL_PEOPLE_F - for contact type = EMPLOYEE
1523: -- 2) HZ_RELATIONSHIPS - for contact type = PARTY_RELATIONSHIP
1524: -- 3) HZ_PARTIES - for contact type = PERSON
1525:
1526: l_tmp_contact_point_id NUMBER;

Line 1560: FROM per_all_people_f ppf,

1556: SELECT ppf.first_name first_name,
1557: ppf.last_name last_name,
1558: cshcp.contact_type,
1559: cshcp.contact_point_id
1560: FROM per_all_people_f ppf,
1561: cs_hz_sr_contact_points cshcp
1562: WHERE cshcp.INCIDENT_ID = l_request_id
1563: AND cshcp.sr_contact_point_id = l_tmp_contact_point_id
1564: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'