[Home] [Help]
269: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,
270: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
271: GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID,
272: NULL, NULL, NULL, NULL
273: FROM GL_LEDGERS gll,
274: GL_LEDGER_RELATIONSHIPS glr
275: WHERE gll.chart_of_accounts_id =
276: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
277: AND gll.object_type_code = 'L'
623: FROM GL_ACCESS_SETS glas,
624: GL_ACCESS_SET_ASSIGN_INT glasai,
625: GL_ACCESS_SET_ASSIGNMENTS glasa1,
626: GL_ACCESS_SET_ASSIGNMENTS glasa2,
627: GL_LEDGERS gll
628: WHERE ( glas.secured_seg_value_set_id =
629: GL_FLATTEN_SETUP_DATA.GLSTFL_MGT_VS_ID
630: OR glas.secured_seg_value_set_id =
631: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID)
813: FROM GL_ACCESS_SET_NORM_ASSIGN glasna
814: WHERE glasna.ledger_id IN
815: (SELECT distinct gllsa.ledger_set_id
816: FROM GL_LEDGER_SET_ASSIGNMENTS gllsa,
817: GL_LEDGERS gll
818: WHERE gllsa.status_code IN ('I', 'D')
819: AND gll.ledger_id = gllsa.ledger_set_id
820: AND gll.chart_of_accounts_id =
821: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
1081: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,
1082: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1083: glasna.start_date, glasna.end_date
1084: FROM GL_ACCESS_SET_NORM_ASSIGN glasna,
1085: GL_LEDGERS gll
1086: WHERE glasna.status_code IN ('I')
1087: AND glasna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
1088: AND gll.implicit_access_set_id = glasna.access_set_id
1089: AND gll.chart_of_accounts_id =
1139: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,
1140: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1141: glasna.start_date, glasna.end_date
1142: FROM GL_LEDGER_SET_ASSIGNMENTS gllsa,
1143: GL_LEDGERS gll,
1144: GL_ACCESS_SET_NORM_ASSIGN glasna,
1145: GL_ACCESS_SETS glas
1146: WHERE gllsa.status_code IN ('I', 'D')
1147: AND gll.ledger_id = gllsa.ledger_set_id
1188: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,
1189: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1190: glasna.start_date, glasna.end_date
1191: FROM GL_LEDGER_SET_ASSIGNMENTS gllsa,
1192: GL_LEDGERS gll,
1193: GL_ACCESS_SET_NORM_ASSIGN glasna,
1194: GL_ACCESS_SETS glas,
1195: GL_SEG_VAL_HIERARCHIES glsvh
1196: WHERE gllsa.status_code IN ('I', 'D')
1240: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,
1241: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1242: glasna.start_date, glasna.end_date
1243: FROM GL_LEDGER_SET_ASSIGNMENTS gllsa,
1244: GL_LEDGERS gll,
1245: GL_ACCESS_SET_NORM_ASSIGN glasna,
1246: GL_ACCESS_SETS glas,
1247: GL_SEG_VAL_HIERARCHIES glsvh
1248: WHERE gllsa.status_code IN ('I', 'D')
1293: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,
1294: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1295: glasna.start_date, glasna.end_date
1296: FROM GL_LEDGER_SET_ASSIGNMENTS gllsa,
1297: GL_LEDGERS gll,
1298: GL_ACCESS_SET_NORM_ASSIGN glasna
1299: WHERE gllsa.status_code IN ('I', 'D')
1300: AND gll.ledger_id = gllsa.ledger_set_id
1301: AND gll.chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
1927: WHERE status_code = 'D'
1928: AND request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
1929: AND access_set_id IN
1930: (SELECT implicit_access_set_id
1931: FROM GL_LEDGERS
1932: WHERE chart_of_accounts_id =
1933: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
1934: AND object_type_code = 'L');
1935:
1961: WHERE status_code IN ('I', 'U')
1962: AND request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
1963: AND access_set_id IN
1964: (SELECT implicit_access_set_id
1965: FROM GL_LEDGERS
1966: WHERE chart_of_accounts_id =
1967: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
1968: AND object_type_code = 'S');
1969:
1987: WHERE status_code IN ('I', 'U')
1988: AND request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
1989: AND access_set_id IN
1990: (SELECT implicit_access_set_id
1991: FROM GL_LEDGERS
1992: WHERE chart_of_accounts_id =
1993: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
1994: AND object_type_code = 'L');
1995: