APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on PER_WORKFORCE_X

Line 1057: -- to use per_workforce_x view.

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

Line 1220: FROM per_workforce_x ppf

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

Line 1245: FROM per_workforce_x ppf

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