DBA Data[Home] [Help]

APPS.GL_SECURITY_PKG dependencies on GL_ACCESS_SETS

Line 9: ACCESS_ID GL_ACCESS_SETS.ACCESS_SET_ID%TYPE;

5: -- Global variables
6: --
7: RESPONSIBILITY_ID FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;
8: LDGR_ID GL_LEDGERS.LEDGER_ID%TYPE;
9: ACCESS_ID GL_ACCESS_SETS.ACCESS_SET_ID%TYPE;
10: COA_ID GL_ACCESS_SETS.CHART_OF_ACCOUNTS_ID%TYPE;
11: SECURITY_SEGMENT_CODE GL_ACCESS_SETS.SECURITY_SEGMENT_CODE%TYPE;
12: BAL_MGMT_SEG_COL_NAME VARCHAR2(2000);
13:

Line 10: COA_ID GL_ACCESS_SETS.CHART_OF_ACCOUNTS_ID%TYPE;

6: --
7: RESPONSIBILITY_ID FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;
8: LDGR_ID GL_LEDGERS.LEDGER_ID%TYPE;
9: ACCESS_ID GL_ACCESS_SETS.ACCESS_SET_ID%TYPE;
10: COA_ID GL_ACCESS_SETS.CHART_OF_ACCOUNTS_ID%TYPE;
11: SECURITY_SEGMENT_CODE GL_ACCESS_SETS.SECURITY_SEGMENT_CODE%TYPE;
12: BAL_MGMT_SEG_COL_NAME VARCHAR2(2000);
13:
14: -- Added under the bug 4730993

Line 11: SECURITY_SEGMENT_CODE GL_ACCESS_SETS.SECURITY_SEGMENT_CODE%TYPE;

7: RESPONSIBILITY_ID FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;
8: LDGR_ID GL_LEDGERS.LEDGER_ID%TYPE;
9: ACCESS_ID GL_ACCESS_SETS.ACCESS_SET_ID%TYPE;
10: COA_ID GL_ACCESS_SETS.CHART_OF_ACCOUNTS_ID%TYPE;
11: SECURITY_SEGMENT_CODE GL_ACCESS_SETS.SECURITY_SEGMENT_CODE%TYPE;
12: BAL_MGMT_SEG_COL_NAME VARCHAR2(2000);
13:
14: -- Added under the bug 4730993
15: RESP_APPLICATION_ID FND_RESPONSIBILITY.APPLICATION_ID%TYPE;

Line 111: FROM GL_ACCESS_SETS

107: BEGIN
108: -- Get chart of accounts id based upon Access Set
109: SELECT chart_of_accounts_id, security_segment_code
110: INTO COA_ID, SECURITY_SEGMENT_CODE
111: FROM GL_ACCESS_SETS
112: WHERE access_set_id = ACCESS_ID;
113: EXCEPTION
114: WHEN NO_DATA_FOUND THEN
115: RETURN;