APPS.JTF_AUTH_BULKLOAD_PKG dependencies on JTF_AUTH_DOMAINS_B

Line 54: jtf_auth_domains_b d,

50:
51: select count(*) into count1
52: from jtf_auth_principal_maps c,
53: jtf_auth_principals_b a,
54: jtf_auth_domains_b d,
55: jtf_auth_principals_b b
56: where a.principal_name=U_USER_NAME and a.is_user_flag=1
57: and a.jtf_auth_principal_id=c.jtf_auth_principal_id
58: and b.principal_name=U_ROLE_NAME and b.is_user_flag=0

Line 72: from jtf_auth_domains_b where

68: from jtf_auth_principals_b
69: where principal_name=U_ROLE_NAME and is_user_flag=0;
70:
71: select jtf_auth_domain_id into d_id
72: from jtf_auth_domains_b where
73: domain_name='CRM_DOMAIN';
74:
75: if count1=0 then
76: insert into jtf_auth_principal_maps (jtf_auth_principal_id,

Line 183: jtf_auth_domains_b d,

179:
180: select count(*) into count1
181: from jtf_auth_principal_maps c,
182: jtf_auth_principals_b a,
183: jtf_auth_domains_b d,
184: jtf_auth_principals_b b
185: where a.principal_name=U_USER_NAME and a.is_user_flag=1
186: and a.jtf_auth_principal_id=c.jtf_auth_principal_id
187: and b.principal_name=U_ROLE_NAME and b.is_user_flag=0

Line 201: from jtf_auth_domains_b where

197: from jtf_auth_principals_b
198: where principal_name=U_ROLE_NAME and is_user_flag=0;
199:
200: select jtf_auth_domain_id into d_id
201: from jtf_auth_domains_b where
202: domain_name='CRM_DOMAIN';
203:
204: if count1 = 0 then
205:

Line 300: jtf_auth_domains_b d,

296:
297: select count(*) into count1
298: from jtf_auth_principal_maps c,
299: jtf_auth_principals_b a,
300: jtf_auth_domains_b d,
301: jtf_auth_principals_b b
302: where a.principal_name=U_USER_NAME and a.is_user_flag=1
303: and a.jtf_auth_principal_id=c.jtf_auth_principal_id
304: and b.principal_name=U_ROLE_NAME and b.is_user_flag=0

Line 318: from jtf_auth_domains_b where

314: from jtf_auth_principals_b
315: where principal_name=U_ROLE_NAME and is_user_flag=0;
316:
317: select jtf_auth_domain_id into d_id
318: from jtf_auth_domains_b where
319: domain_name='CRM_DOMAIN';
320:
321: if count1=0 then
322: insert into jtf_auth_principal_maps (jtf_auth_principal_id,

Line 430: jtf_auth_domains_b d,

426:
427: select count(*) into count1
428: from jtf_auth_principal_maps c,
429: jtf_auth_principals_b a,
430: jtf_auth_domains_b d,
431: jtf_auth_principals_b b
432: where a.principal_name=U_USER_NAME and a.is_user_flag=1
433: and a.jtf_auth_principal_id=c.jtf_auth_principal_id
434: and b.principal_name=U_ROLE_NAME and b.is_user_flag=0

Line 448: from jtf_auth_domains_b where

444: from jtf_auth_principals_b
445: where principal_name=U_ROLE_NAME and is_user_flag=0;
446:
447: select jtf_auth_domain_id into d_id
448: from jtf_auth_domains_b where
449: domain_name='CRM_DOMAIN';
450:
451: if count1 = 0 then
452: