DBA Data[Home] [Help]

APPS.PV_AS_ACCESS_VHUK dependencies on AS_ACCESSES_ALL

Line 79: FROM as_accesses_all

75:
76:
77: CURSOR lc_get_prm_flag(pc_access_id number) is
78: SELECT prm_keep_flag
79: FROM as_accesses_all
80: WHERE access_id = pc_access_id;
81:
82: l_get_upd_del_check_perm VARCHAR2(1) := 'N';
83:

Line 87: 1 from as_accesses_all acc , hz_relationships hzpp , hz_parties ptorg,

83:
84: CURSOR lc_get_upd_del_check_perm(pc_lead_id number, pc_access_id number) is
85:
86: SELECT
87: 1 from as_accesses_all acc , hz_relationships hzpp , hz_parties ptorg,
88: fnd_user fndu, jtf_rs_resource_extns jtfre,
89: hz_parties ptorg1 ,hz_relationships hzpp1
90: WHERE
91: acc.partner_cont_party_id = hzpp.party_id and