APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on PER_ALL_PEOPLE_F

Line 1155: from per_all_people_f ppf,

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

Line 1269: from per_all_people_f ppf,

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

Line 1305: from per_all_people_f ppf,

1301: ppf.party_id,
1302: ppf.person_id,
1303: cshcp.contact_type,
1304: cshcp.sr_contact_point_id
1305: from per_all_people_f ppf,
1306: cs_hz_sr_contact_points cshcp
1307: where cshcp.INCIDENT_ID = l_request_id
1308: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1309: AND ppf.person_id = cshcp.party_id

Line 1338: FROM per_all_people_f ppf,

1334: ppf.party_id,
1335: ppf.person_id,
1336: cshcp.contact_type,
1337: cshcp.sr_contact_point_id
1338: FROM per_all_people_f ppf,
1339: cs_hz_sr_contact_points cshcp
1340: WHERE
1341: cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1342: AND ppf.PERSON_ID = l_contact_point_id

Line 1376: FROM per_all_people_f ppf,

1372: cshcp.contact_type,
1373: cshcp.sr_contact_point_id,
1374: cpr.name,
1375: cpr.party_role_code
1376: FROM per_all_people_f ppf,
1377: cs_hz_sr_contact_points cshcp,
1378: cs_party_roles_tl cpr
1379: WHERE
1380: cshcp.CONTACT_POINT_TYPE = 'EMAIL'

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

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

Line 1564: FROM per_all_people_f ppf,

1560: SELECT ppf.first_name first_name,
1561: ppf.last_name last_name,
1562: cshcp.contact_type,
1563: cshcp.contact_point_id
1564: FROM per_all_people_f ppf,
1565: cs_hz_sr_contact_points cshcp
1566: WHERE cshcp.INCIDENT_ID = l_request_id
1567: AND cshcp.sr_contact_point_id = l_tmp_contact_point_id
1568: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'

Line 1598: From per_all_people_f ppf,

1594: AND cshcp.PARTY_ID = hzp.PARTY_ID
1595: UNION -- start Bug 12610714
1596: SELECT ppf.first_name first_name,
1597: ppf.last_name last_name
1598: From per_all_people_f ppf,
1599: cs_hz_sr_contact_points cshcp
1600: WHERE cshcp.INCIDENT_ID = l_request_id
1601: AND cshcp.sr_contact_point_id = l_tmp_contact_point_id
1602: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'

Line 1606: from per_all_people_f ppf1,

1602: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1603: AND cshcp.contact_type = 'EMPLOYEE'
1604: AND cshcp.PARTY_ID = ppf.PERSON_ID
1605: AND ppf.effective_end_date = (select max(ppf1.effective_end_date)
1606: from per_all_people_f ppf1,
1607: cs_hz_sr_contact_points cshcp1
1608: WHERE cshcp1.INCIDENT_ID = l_request_id
1609: AND cshcp1.sr_contact_point_id = l_tmp_contact_point_id
1610: AND cshcp1.CONTACT_POINT_TYPE = 'EMAIL'

Line 1620: FROM per_all_people_f ppf,

1616: last_name last_name
1617: FROM (
1618: SELECT ppf.first_name first_name,
1619: ppf.last_name last_name
1620: FROM per_all_people_f ppf,
1621: cs_hz_sr_contact_points cshcp
1622: WHERE cshcp.INCIDENT_ID = l_request_id
1623: AND cshcp.sr_contact_point_id = l_tmp_contact_point_id
1624: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'