DBA Data[Home] [Help]

APPS.XLA_JE_VALIDATION_PKG dependencies on GL_ACCESS_SETS

Line 473: FROM gl_access_sets

469:
470: IF (g_pri_access_set_id IS NOT NULL) THEN
471: SELECT security_segment_code, chart_of_accounts_id
472: INTO g_pri_security_seg_code, g_pri_coa_id
473: FROM gl_access_sets
474: WHERE access_set_id = g_pri_access_set_id;
475: END IF;
476:
477: IF (g_sec_access_set_id IS NOT NULL) THEN

Line 480: FROM gl_access_sets

476:
477: IF (g_sec_access_set_id IS NOT NULL) THEN
478: SELECT security_segment_code, chart_of_accounts_id
479: INTO g_sec_security_seg_code, g_sec_coa_id
480: FROM gl_access_sets
481: WHERE access_set_id = g_sec_access_set_id;
482: END IF;
483:
484: IF (g_sec_security_seg_code = 'F' AND g_pri_security_seg_code <> 'F') OR

Line 606: FROM fnd_user u, gl_access_sets a

602: IF (l_ledger_id IS NULL) THEN
603: IF (g_access_set_name IS NULL) THEN
604: SELECT u.user_name, a.name
605: INTO g_user_name, g_access_set_name
606: FROM fnd_user u, gl_access_sets a
607: WHERE u.user_id = xla_environment_pkg.g_usr_id
608: AND a.access_set_id = g_pri_access_set_id;
609: END IF;
610:

Line 886: FROM fnd_user u, gl_access_sets a

882: IF (l_pri_security_seg_code = 'F') THEN
883: IF (g_access_set_name IS NULL) THEN
884: SELECT u.user_name, a.name
885: INTO g_user_name, g_access_set_name
886: FROM fnd_user u, gl_access_sets a
887: WHERE u.user_id = xla_environment_pkg.g_usr_id
888: AND a.access_set_id = g_pri_access_set_id;
889: END IF;
890: