APPS.CSD_LOGISTICS_UTIL dependencies on FND_LOOKUPS

Line 490: /* of values in fnd lookups */

486:
487: /*---------------------------------------------------------------------------*/
488: /* procedure name: Validate_ReasonCode */
489: /* description : Helper routing to validate Reason Code against the List */
490: /* of values in fnd lookups */
491: /* Parameters Required: */
492: /* p_ReasonCode -> Lookup value to validate */
493: /*---------------------------------------------------------------------------*/
494: PROCEDURE Validate_ReasonCode(p_ReasonCode IN VARCHAR2) IS

Line 514: FROM fnd_lookups

510: --SU 02/25: Following sql statement is not correct
511: /*********
512: SELECT lookup_code
513: INTO l_ReasonCode
514: FROM fnd_lookups
515: WHERE lookup_type = 'CSD_REASON'
516: AND Lookup_Code = p_ReasonCode
517: AND enabled_flag = 'Y'
518: AND sysdate BETWEEN nvl(start_date_active,sysdate-1)

Line 1969: /* in fnd lookups */

1965:
1966: /*---------------------------------------------------------------------------*/
1967: /* procedure name: Get_ProdTrxnStatus_Meaning */
1968: /* description : gets prod txn status meaning for a prod txn status code */
1969: /* in fnd lookups */
1970: /* Parameters Required: */
1971: /* p_ProdTxnStatus_Code IN Lookup code for product transaction status */
1972: /*---------------------------------------------------------------------------*/
1973: FUNCTION Get_ProdTrxnStatus_Meaning(p_ProdTxnStatus_Code IN VARCHAR2)

Line 1981: FROM Fnd_Lookups

1977: l_ProdTxn_Status_Meaning VARCHAR2(80);
1978:
1979: CURSOR ProdTxnStatus_Meaning_Cur_Type(p_ProdTxnStatus_Code IN VARCHAR2) IS
1980: SELECT Meaning
1981: FROM Fnd_Lookups
1982: WHERE Lookup_Type = 'CSD_PRODUCT_TXN_STATUS'
1983: AND Lookup_Code = p_ProdTxnStatus_Code;
1984:
1985: BEGIN

Line 2225: FROM fnd_lookups

2221: THEN
2222: BEGIN
2223: SELECT 'X'
2224: INTO l_check
2225: FROM fnd_lookups
2226: WHERE lookup_type = 'CSD_PRODUCT_TXN_STATUS'
2227: AND lookup_code = p_product_txn_rec.PROD_TXN_STATUS;
2228: EXCEPTION
2229: WHEN NO_DATA_FOUND THEN