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 562: FROM gl_access_set_assignments asa

558: PROCEDURE validate_ledger_security
559: IS
560: CURSOR c_full_none IS
561: SELECT asa.ledger_id
562: FROM gl_access_set_assignments asa
563: WHERE asa.ledger_id = g_ledger_id
564: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
565: AND asa.access_set_id = g_pri_access_set_id;
566:

Line 569: FROM gl_access_set_assignments asa

565: AND asa.access_set_id = g_pri_access_set_id;
566:
567: CURSOR c_full_full IS
568: SELECT asa.ledger_id
569: FROM gl_access_set_assignments asa
570: WHERE asa.ledger_id = g_ledger_id
571: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
572: AND asa.access_set_id in (g_pri_access_set_id, g_sec_access_set_id);
573:

Line 693: LEFT OUTER JOIN gl_access_set_assignments asa

689: CURSOR c_full_bal IS
690: SELECT t.entity_id, t.event_id, t.ae_header_id, t.ae_line_num
691: ,NULL segment_value
692: FROM xla_validation_lines_gt t
693: LEFT OUTER JOIN gl_access_set_assignments asa
694: on asa.ledger_id = g_ledger_id
695: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
696: AND asa.access_set_id = g_pri_access_set_id
697: LEFT OUTER JOIN gl_access_set_assignments asa2

Line 697: LEFT OUTER JOIN gl_access_set_assignments asa2

693: LEFT OUTER JOIN gl_access_set_assignments asa
694: on asa.ledger_id = g_ledger_id
695: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
696: AND asa.access_set_id = g_pri_access_set_id
697: LEFT OUTER JOIN gl_access_set_assignments asa2
698: on asa2.segment_value = t.bal_seg_value
699: AND asa2.ledger_id = g_ledger_id
700: AND asa2.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
701: AND asa2.access_set_id = g_sec_access_set_id

Line 709: LEFT OUTER JOIN gl_access_set_assignments asa

705: CURSOR c_full_mgt IS
706: SELECT t.entity_id, t.event_id, t.ae_header_id, t.ae_line_num
707: ,NULL segment_value
708: FROM xla_validation_lines_gt t
709: LEFT OUTER JOIN gl_access_set_assignments asa
710: on asa.ledger_id = g_ledger_id
711: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
712: AND asa.access_set_id = g_pri_access_set_id
713: LEFT OUTER JOIN gl_access_set_assignments asa2

Line 713: LEFT OUTER JOIN gl_access_set_assignments asa2

709: LEFT OUTER JOIN gl_access_set_assignments asa
710: on asa.ledger_id = g_ledger_id
711: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
712: AND asa.access_set_id = g_pri_access_set_id
713: LEFT OUTER JOIN gl_access_set_assignments asa2
714: on asa2.segment_value = t.mgt_seg_value
715: AND asa2.ledger_id = g_ledger_id
716: AND asa2.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
717: AND asa2.access_set_id = g_sec_access_set_id

Line 725: LEFT OUTER JOIN gl_access_set_assignments asa

721: CURSOR c_bal_none IS
722: SELECT t.entity_id, t.event_id, t.ae_header_id, t.ae_line_num
723: ,t.bal_seg_value segment_value
724: FROM xla_validation_lines_gt t
725: LEFT OUTER JOIN gl_access_set_assignments asa
726: ON asa.segment_value = t.bal_seg_value
727: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
728: AND asa.ledger_id = g_ledger_id
729: AND asa.access_set_id = g_pri_access_set_id

Line 736: LEFT OUTER JOIN gl_access_set_assignments asa

732: CURSOR c_bal_bal IS
733: SELECT t.entity_id, t.event_id, t.ae_header_id, t.ae_line_num
734: ,t.bal_seg_value segment_value
735: FROM xla_validation_lines_gt t
736: LEFT OUTER JOIN gl_access_set_assignments asa
737: ON asa.segment_value = t.bal_seg_value
738: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
739: AND asa.ledger_id = g_ledger_id
740: AND asa.access_set_id in (g_pri_access_set_id, g_sec_access_set_id)

Line 747: LEFT OUTER JOIN gl_access_set_assignments asa

743: CURSOR c_bal_mgt IS
744: SELECT t.entity_id, t.event_id, t.ae_header_id, t.ae_line_num
745: ,t.bal_seg_value segment_value
746: FROM xla_validation_lines_gt t
747: LEFT OUTER JOIN gl_access_set_assignments asa
748: on asa.segment_value = t.bal_seg_value
749: AND asa.ledger_id = g_ledger_id
750: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
751: AND asa.access_set_id = g_pri_access_set_id

Line 752: LEFT OUTER JOIN gl_access_set_assignments asa2

748: on asa.segment_value = t.bal_seg_value
749: AND asa.ledger_id = g_ledger_id
750: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
751: AND asa.access_set_id = g_pri_access_set_id
752: LEFT OUTER JOIN gl_access_set_assignments asa2
753: on asa2.segment_value = t.mgt_seg_value
754: AND asa2.ledger_id = g_ledger_id
755: AND asa2.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
756: AND asa2.access_set_id = g_sec_access_set_id

Line 764: LEFT OUTER JOIN gl_access_set_assignments asa

760: CURSOR c_mgt_none IS
761: SELECT t.entity_id, t.event_id, t.ae_header_id, t.ae_line_num
762: ,t.mgt_seg_value segment_value
763: FROM xla_validation_lines_gt t
764: LEFT OUTER JOIN gl_access_set_assignments asa
765: ON asa.segment_value = t.mgt_seg_value
766: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
767: AND asa.ledger_id = g_ledger_id
768: AND asa.access_set_id = g_pri_access_set_id

Line 775: LEFT OUTER JOIN gl_access_set_assignments asa

771: CURSOR c_mgt_mgt IS
772: SELECT t.entity_id, t.event_id, t.ae_header_id, t.ae_line_num
773: ,t.mgt_seg_value segment_value
774: FROM xla_validation_lines_gt t
775: LEFT OUTER JOIN gl_access_set_assignments asa
776: ON asa.segment_value = t.mgt_seg_value
777: AND asa.access_privilege_code = C_ACCESS_SET_FULL_PRIVILEGE
778: AND asa.ledger_id = g_ledger_id
779: AND asa.access_set_id in (g_pri_access_set_id, g_sec_access_set_id)