APPS.GL_MC_INFO dependencies on GL_ALC_LEDGER_RSHIPS_V

Line 488: SELECT ledger_id FROM GL_ALC_LEDGER_RSHIPS_V

484: -- Delete the rows for the passed ledger and its associated ALC Ledgers
485: /* DELETE FROM GL_LEDGER_LE_BSV_GT
486: WHERE ledger_id = p_ledger_id
487: OR ledger_id IN (
488: SELECT ledger_id FROM GL_ALC_LEDGER_RSHIPS_V
489: WHERE application_id = 101
490: AND source_ledger_id = p_ledger_id); */
491:
492: -- Delete the all the rows from Previous Ledger contexts

Line 628: ' SELECT ledger_id FROM GL_ALC_LEDGER_RSHIPS_V ';

624: l_insertSQL(l_line_no) :=
625: ' OR lg.ledger_id IN ( ';
626: l_line_no := l_line_no + 1;
627: l_insertSQL(l_line_no) :=
628: ' SELECT ledger_id FROM GL_ALC_LEDGER_RSHIPS_V ';
629: l_line_no := l_line_no + 1;
630: l_insertSQL(l_line_no) :=
631: ' WHERE application_id = 101 ';
632: l_line_no := l_line_no + 1;

Line 676: SELECT 'Enabled RS exists' FROM GL_ALC_LEDGER_RSHIPS_V rs

672: WHERE rs.ledger_id = gt.ledger_id
673: AND rs.relationship_enabled_flag = 'Y'))
674: OR (gt.LEDGER_CATEGORY_CODE = 'ALC'
675: AND EXISTS (
676: SELECT 'Enabled RS exists' FROM GL_ALC_LEDGER_RSHIPS_V rs
677: WHERE rs.ledger_id = gt.ledger_id
678: AND rs.application_id = 101
679: AND rs.relationship_enabled_flag = 'Y'));
680: