DBA Data[Home] [Help]

APPS.XTR_EXP_TRANSFERS_PKG dependencies on XTR_PARTIES_V

Line 183: SELECT COUNT(*) FROM xtr_parties_v

179: This procedure is checks whether the company_code is valid.
180: ------------------------------------------------------------------------*/
181: function VALID_COMPANY_CODE(p_comp IN VARCHAR2) return boolean IS
182: CURSOR company_code IS
183: SELECT COUNT(*) FROM xtr_parties_v
184: WHERE party_type='C' AND party_code=p_comp;
185:
186: v_count NUMBER;
187:

Line 686: from XTR_parties_V

682: RETURN NUMBER IS
683:
684: cursor get_home_currency is
685: select home_currency
686: from XTR_parties_V
687: where party_code = p_company_code;
688:
689: cursor get_rate_hce is
690: select round(hce_rate,5)