APPS.OE_VERIFY_PAYMENT_PUB dependencies on OE_CREDIT_CHECK_RULES

Line 1957: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

1953: 7194250*/
1954: --7194250
1955: SELECT NVL(ENTRY_CREDIT_CHECK_RULE_ID, -1)
1956: INTO l_credit_check_rule_id
1957: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
1958: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
1959: AND ENTRY_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
1960: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
1961: --7194250

Line 1991: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

1987: 7194250*/
1988: --7194250
1989: SELECT NVL(SHIPPING_CREDIT_CHECK_RULE_ID, -1)
1990: INTO l_credit_check_rule_id
1991: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
1992: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
1993: AND SHIPPING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
1994: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
1995: --7194250

Line 2022: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

2018: 7194250*/
2019: --7194250
2020: SELECT NVL(PACKING_CREDIT_CHECK_RULE_ID, -1)
2021: INTO l_credit_check_rule_id
2022: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
2023: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
2024: AND PACKING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
2025: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
2026: --7194250

Line 2053: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR

2049: 7194250*/
2050: --7194250
2051: SELECT NVL(PICKING_CREDIT_CHECK_RULE_ID, -1)
2052: INTO l_credit_check_rule_id
2053: FROM OE_ORDER_TYPES_V OT,OE_CREDIT_CHECK_RULES CCR
2054: WHERE OT.ORDER_TYPE_ID = p_header_rec.order_type_id
2055: AND PICKING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID
2056: AND Trunc(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, Trunc(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, Trunc(SYSDATE));
2057: --7194250