DBA Data[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PON_AUC_DOCTYPES

Line 68: FROM pon_auc_doctypes dt,

64: begin
65:
66: SELECT '_' || dt.message_suffix
67: INTO l_suffix
68: FROM pon_auc_doctypes dt,
69: pon_auction_headers_all ah
70: WHERE dt.doctype_id = ah.doctype_id
71: AND ah.auction_header_id = p_auction_id
72: AND rownum =1;

Line 3401: FROM PON_AUC_DOCTYPES

3397: --
3398: -- get the transaction type
3399: SELECT TRANSACTION_TYPE
3400: INTO l_transaction_type
3401: FROM PON_AUC_DOCTYPES
3402: WHERE DOCTYPE_ID = p_doctype_Id;
3403: --
3404: -- DBMS_OUTPUT.PUT_LINE('l_transaction_type = ' || l_transaction_type);
3405: IF(l_transaction_type = 'REVERSE') THEN