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 3002: FROM PON_AUC_DOCTYPES

2998: --
2999: -- get the transaction type
3000: SELECT TRANSACTION_TYPE
3001: INTO l_transaction_type
3002: FROM PON_AUC_DOCTYPES
3003: WHERE DOCTYPE_ID = p_doctype_Id;
3004: --
3005: -- DBMS_OUTPUT.PUT_LINE('l_transaction_type = ' || l_transaction_type);
3006: IF(l_transaction_type = 'REVERSE') THEN