APPS.OKS_ENTITLEMENTS_WEB dependencies on HZ_PARTIES

Line 952: SELECT party_name FROM hz_parties WHERE party_id=p_party_id;

948: )
949: IS
950: CURSOR party_name_cur(p_party_id VARCHAR2)
951: IS
952: SELECT party_name FROM hz_parties WHERE party_id=p_party_id;
953: CURSOR contract_cat_cur
954: IS
955: SELECT CODE, MEANING FROM OKC_SUBCLASSES_V WHERE CLS_CODE = 'SERVICE' ORDER BY MEANING;
956: CURSOR contract_status_cur

Line 1864: HZ_PARTIES PARTY

1860: PARTY.PARTY_NAME name
1861: FROM
1862: JTF_RS_RESOURCE_EXTNS RSC ,
1863: FND_USER U ,
1864: HZ_PARTIES PARTY
1865: WHERE
1866: RSC.CATEGORY IN ( 'PARTY', 'PARTNER')
1867: AND PARTY.PARTY_ID = RSC.SOURCE_ID
1868: AND U.USER_ID = RSC.USER_ID

Line 2702: HZ_PARTIES HZP,

2698: FROM OKC_K_LINES_B LINE,
2699: OKC_K_PARTY_ROLES_B PR,
2700: FND_LOOKUPS FNDCONT,
2701: OKC_CONTACTS CONT,
2702: HZ_PARTIES HZP,
2703: HZ_RELATIONSHIPS HZR,
2704: HZ_CUST_ACCOUNT_ROLES ACCROLE
2705:
2706: WHERE LINE.ID = to_number(p_line_id_arg)

Line 3279: HZ_PARTIES PARTY

3275: okc_contacts_v con,
3276: okc_k_party_roles_b pty ,
3277: JTF_RS_RESOURCE_EXTNS RSC ,
3278: FND_USER U ,
3279: HZ_PARTIES PARTY
3280: where
3281: pty.cle_id = to_number(p_bus_proc_ID_arg)
3282: and pty.dnz_chr_id = to_number(p_contract_ID_arg)
3283: and con.cpl_id = pty.id

Line 3335: HZ_PARTIES vendor_contact,

3331: OKC_CONTACTS Contacts,
3332: FND_LOOKUPS RoleLookup,
3333: OKC_K_PARTY_ROLES_B PartyRoles,
3334: AP_SUPPLIER_CONTACTS ap_supp_contact,
3335: HZ_PARTIES vendor_contact,
3336: PER_ALL_PEOPLE_F employee,
3337: HZ_PARTIES hz_party
3338: WHERE
3339: okcline.ID = to_number(p_bus_proc_ID_arg)

Line 3337: HZ_PARTIES hz_party

3333: OKC_K_PARTY_ROLES_B PartyRoles,
3334: AP_SUPPLIER_CONTACTS ap_supp_contact,
3335: HZ_PARTIES vendor_contact,
3336: PER_ALL_PEOPLE_F employee,
3337: HZ_PARTIES hz_party
3338: WHERE
3339: okcline.ID = to_number(p_bus_proc_ID_arg)
3340: AND PartyRoles.cle_id = okcline.ID
3341: AND PartyRoles.dnz_chr_id = okcline.dnz_chr_id