DBA Data[Home] [Help]

APPS.AP_APXCRRCR_XMLP_PKG dependencies on AP_PAYMENT_TEMPLATES

Line 42: AP_PAYMENT_TEMPLATES

38: C_VENDOR_ID,C_PAY_FROM_DATE,C_INV_EXCHANGE_RATE_TYPE,C_PAYMENT_METHOD_CODE,
39: C_VENDOR_TYPE_LOOKUP_CODE,C_OU_GROUP_OPTION,C_LE_GROUP_OPTION,C_CURRENCY_GROUP_OPTION,
40: C_PAY_GROUP_OPTION,C_PARTY_ID,C_DISC_PAY_THRU_DATE,C_TEMPLATE_NAME
41: FROM
42: AP_PAYMENT_TEMPLATES
43: WHERE TEMPLATE_ID = P_TEMPLATE_ID;
44: IF P_INCLUDE_UNVALIDATED = 'N' THEN
45: C_UNVALIDATED_PREDICATE := 'AND inv1.wfapproval_status in ' || '(''NOT REQUIRED'',''WFAPPROVED'',''MANUALLY APPROVED'') ';
46: END IF;