DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_WEB dependencies on OKS_CONTACT_POINTS_V

Line 1986: From OKS_CONTACT_POINTS_V

1982: IS
1983: CURSOR party_contact_email_cur( p_owner_table_id VARCHAR)
1984: IS
1985: Select EMAIL_ADDRESS Email
1986: From OKS_CONTACT_POINTS_V
1987: Where
1988: OWNER_TABLE_ID = to_number(p_owner_table_id)
1989: and (CONTACT_POINT_TYPE = 'EMAIL' or CONTACT_POINT_TYPE = 'Email');
1990:

Line 2164: OKS_CONTACT_POINTS_V

2160: PHONE_AREA_CODE AreaCode,
2161: PHONE_NUMBER pNumber,
2162: PHONE_EXTENSION Extension
2163: From
2164: OKS_CONTACT_POINTS_V
2165: Where OWNER_TABLE_ID = to_number(p_contact_id_arg);
2166:
2167: l_pty_cntct_dtls_tbl_type OKS_ENTITLEMENTS_WEB.pty_cntct_dtls_tbl_type;
2168: