APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on PER_WORKFORCE_X

Line 1056: -- to use per_workforce_x view.

1052: -- This is true only for customer contact.
1053: -- (Bug#5052683)
1054: --
1055: -- 15 Mar 06 spusegao Changed the references to per_people_f in the set_notification_details proc.
1056: -- to use per_workforce_x view.
1057: ***********************************************************************/
1058:
1059: PROCEDURE Set_Notification_Details( itemtype IN VARCHAR2,
1060: itemkey IN VARCHAR2,

Line 1217: FROM per_workforce_x ppf

1213: CURSOR get_primary_email_info_HR(p_person_id IN NUMBER) IS
1214: SELECT ppf.email_address
1215: --ppf.party_id,
1216: --ppf.person_id
1217: FROM per_workforce_x ppf
1218: WHERE ppf.person_id = p_person_id;
1219: --AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(ppf.effective_start_date, SYSDATE))
1220: --AND TRUNC(NVL(ppf.effective_end_date, SYSDATE));
1221:

Line 1242: FROM per_workforce_x ppf

1238:
1239: CURSOR get_prim_cont_party_info_empl (p_party_id IN NUMBER) IS
1240: SELECT ppf.first_name first_name,
1241: ppf.last_name last_name
1242: FROM per_workforce_x ppf
1243: WHERE ppf.person_id = p_party_id;
1244:
1245: --Added and condition for party role in R12 ... aneemuch
1246: