eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_JE_VALIDATION_PKG dependencies on GL_ACCESS_SET_ASSIGNMENTS

Line 827: FROM gl_access_set_assignments asa

823: PROCEDURE validate_ledger_security
824: IS
825: CURSOR c_full_none IS
826: SELECT asa.ledger_id
827: FROM gl_access_set_assignments asa
828: WHERE asa.ledger_id = g_ledger_id
829: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
830: AND asa.access_set_id = g_pri_access_set_id;
831:

Line 834: FROM gl_access_set_assignments asa

830: AND asa.access_set_id = g_pri_access_set_id;
831:
832: CURSOR c_full_full IS
833: SELECT asa.ledger_id
834: FROM gl_access_set_assignments asa
835: WHERE asa.ledger_id = g_ledger_id
836: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
837: AND asa.access_set_id in (g_pri_access_set_id, g_sec_access_set_id);
838:

Line 958: LEFT OUTER JOIN gl_access_set_assignments asa

954: CURSOR c_full_bal IS
955: SELECT t.entity_id, t.event_id, t.ae_header_id, t.ae_line_num
956: ,NULL segment_value
957: FROM xla_validation_lines_gt t
958: LEFT OUTER JOIN gl_access_set_assignments asa
959: on asa.ledger_id = g_ledger_id
960: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
961: AND asa.access_set_id = g_pri_access_set_id
962: LEFT OUTER JOIN gl_access_set_assignments asa2

Line 962: LEFT OUTER JOIN gl_access_set_assignments asa2

958: LEFT OUTER JOIN gl_access_set_assignments asa
959: on asa.ledger_id = g_ledger_id
960: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
961: AND asa.access_set_id = g_pri_access_set_id
962: LEFT OUTER JOIN gl_access_set_assignments asa2
963: on asa2.segment_value = t.bal_seg_value
964: AND asa2.ledger_id = g_ledger_id
965: AND asa2.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
966: AND asa2.access_set_id = g_sec_access_set_id

Line 974: LEFT OUTER JOIN gl_access_set_assignments asa

970: CURSOR c_full_mgt IS
971: SELECT t.entity_id, t.event_id, t.ae_header_id, t.ae_line_num
972: ,NULL segment_value
973: FROM xla_validation_lines_gt t
974: LEFT OUTER JOIN gl_access_set_assignments asa
975: on asa.ledger_id = g_ledger_id
976: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
977: AND asa.access_set_id = g_pri_access_set_id
978: LEFT OUTER JOIN gl_access_set_assignments asa2

Line 978: LEFT OUTER JOIN gl_access_set_assignments asa2

974: LEFT OUTER JOIN gl_access_set_assignments asa
975: on asa.ledger_id = g_ledger_id
976: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
977: AND asa.access_set_id = g_pri_access_set_id
978: LEFT OUTER JOIN gl_access_set_assignments asa2
979: on asa2.segment_value = t.mgt_seg_value
980: AND asa2.ledger_id = g_ledger_id
981: AND asa2.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
982: AND asa2.access_set_id = g_sec_access_set_id

Line 990: LEFT OUTER JOIN gl_access_set_assignments asa

986: CURSOR c_bal_none IS
987: SELECT t.entity_id, t.event_id, t.ae_header_id, t.ae_line_num
988: ,t.bal_seg_value segment_value
989: FROM xla_validation_lines_gt t
990: LEFT OUTER JOIN gl_access_set_assignments asa
991: ON asa.segment_value = t.bal_seg_value
992: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
993: AND asa.ledger_id = g_ledger_id
994: AND asa.access_set_id = g_pri_access_set_id

Line 1001: LEFT OUTER JOIN gl_access_set_assignments asa

997: CURSOR c_bal_bal IS
998: SELECT t.entity_id, t.event_id, t.ae_header_id, t.ae_line_num
999: ,t.bal_seg_value segment_value
1000: FROM xla_validation_lines_gt t
1001: LEFT OUTER JOIN gl_access_set_assignments asa
1002: ON asa.segment_value = t.bal_seg_value
1003: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
1004: AND asa.ledger_id = g_ledger_id
1005: AND asa.access_set_id in (g_pri_access_set_id, g_sec_access_set_id)

Line 1012: LEFT OUTER JOIN gl_access_set_assignments asa

1008: CURSOR c_bal_mgt IS
1009: SELECT t.entity_id, t.event_id, t.ae_header_id, t.ae_line_num
1010: ,t.bal_seg_value segment_value
1011: FROM xla_validation_lines_gt t
1012: LEFT OUTER JOIN gl_access_set_assignments asa
1013: on asa.segment_value = t.bal_seg_value
1014: AND asa.ledger_id = g_ledger_id
1015: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
1016: AND asa.access_set_id = g_pri_access_set_id

Line 1017: LEFT OUTER JOIN gl_access_set_assignments asa2

1013: on asa.segment_value = t.bal_seg_value
1014: AND asa.ledger_id = g_ledger_id
1015: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
1016: AND asa.access_set_id = g_pri_access_set_id
1017: LEFT OUTER JOIN gl_access_set_assignments asa2
1018: on asa2.segment_value = t.mgt_seg_value
1019: AND asa2.ledger_id = g_ledger_id
1020: AND asa2.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
1021: AND asa2.access_set_id = g_sec_access_set_id

Line 1029: LEFT OUTER JOIN gl_access_set_assignments asa

1025: CURSOR c_mgt_none IS
1026: SELECT t.entity_id, t.event_id, t.ae_header_id, t.ae_line_num
1027: ,t.mgt_seg_value segment_value
1028: FROM xla_validation_lines_gt t
1029: LEFT OUTER JOIN gl_access_set_assignments asa
1030: ON asa.segment_value = t.mgt_seg_value
1031: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
1032: AND asa.ledger_id = g_ledger_id
1033: AND asa.access_set_id = g_pri_access_set_id

Line 1040: LEFT OUTER JOIN gl_access_set_assignments asa

1036: CURSOR c_mgt_mgt IS
1037: SELECT t.entity_id, t.event_id, t.ae_header_id, t.ae_line_num
1038: ,t.mgt_seg_value segment_value
1039: FROM xla_validation_lines_gt t
1040: LEFT OUTER JOIN gl_access_set_assignments asa
1041: ON asa.segment_value = t.mgt_seg_value
1042: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
1043: AND asa.ledger_id = g_ledger_id
1044: AND asa.access_set_id in (g_pri_access_set_id, g_sec_access_set_id)