APPS.JE_JEPLPSSR_XMLP_PKG dependencies on DUAL

Line 571: LP_SUPPLIER := ' AND nvl(papf.national_identifier,nvl(po1.individual_1099,po1.num_1099)) = ''' || P_SUPPLIER_TAX_ID || '''';

567: END IF;
568: IF P_SUPPLIER_NAME_FROM IS NOT NULL THEN
569: LP_SUPPLIER := ' AND po1.vendor_name BETWEEN ''' || P_SUPPLIER_NAME_FROM || ''' AND ''' || P_SUPPLIER_NAME_TO || '''';
570: ELSIF P_SUPPLIER_TAX_ID IS NOT NULL THEN
571: LP_SUPPLIER := ' AND nvl(papf.national_identifier,nvl(po1.individual_1099,po1.num_1099)) = ''' || P_SUPPLIER_TAX_ID || '''';
572: ELSE
573: LP_SUPPLIER := ' ';
574: END IF;
575: CP_SUPPLIER_TAX_ID := P_SUPPLIER_TAX_ID;

Line 721: DUAL;

717: ,'N'
718: ,C_NLS_NO)
719: INTO A_FLAG
720: FROM
721: DUAL;
722: RETURN (A_FLAG);
723: END CF_POSTED_ONLYFORMULA;
724:
725: FUNCTION CF_APPROVED_ONLYFORMULA RETURN CHAR IS

Line 736: DUAL;

732: ,'N'
733: ,C_NLS_NO)
734: INTO A_FLAG
735: FROM
736: DUAL;
737: RETURN (A_FLAG);
738: END CF_APPROVED_ONLYFORMULA;
739:
740: FUNCTION CF_GROUP_CURRFORMULA(GROUP_CURRENCY IN VARCHAR2) RETURN CHAR IS