DBA Data[Home] [Help]

APPS.OM_SETUP_VALID_PKG dependencies on OE_WORKFLOW_ASSIGNMENTS

Line 1977: FROM OE_WORKFLOW_ASSIGNMENTS

1973: CURSOR csr2 IS
1974: SELECT T.TRANSACTION_TYPE_ID, T.ORG_ID
1975: FROM OE_TRANSACTION_TYPES_ALL T
1976: WHERE NOT T.TRANSACTION_TYPE_ID IN ( SELECT UNIQUE ORDER_TYPE_ID
1977: FROM OE_WORKFLOW_ASSIGNMENTS
1978: WHERE LINE_TYPE_ID IS NULL );
1979: csrvar2 csr2%ROWTYPE;
1980: CURSOR csr3 IS
1981: SELECT T.TRANSACTION_TYPE_ID, T.ORG_ID

Line 1984: FROM OE_WORKFLOW_ASSIGNMENTS

1980: CURSOR csr3 IS
1981: SELECT T.TRANSACTION_TYPE_ID, T.ORG_ID
1982: FROM OE_TRANSACTION_TYPES_ALL T
1983: WHERE NOT T.TRANSACTION_TYPE_ID IN ( SELECT UNIQUE ORDER_TYPE_ID
1984: FROM OE_WORKFLOW_ASSIGNMENTS
1985: WHERE LINE_TYPE_ID IS NOT NULL );
1986: csrvar3 csr3%ROWTYPE;
1987: CURSOR csr4 IS
1988: SELECT TRANSACTION_TYPE_ID, ORG_ID