DBA Data[Home] [Help]

APPS.ZX_TDS_CALC_SERVICES_PUB_PKG dependencies on ZX_PROCESS_RESULTS

Line 4487: p_result_id IN ZX_PROCESS_RESULTS.RESULT_ID%TYPE,

4483: -- CALLED BY
4484: -- calculate_tax
4485: -----------------------------------------------------------------------
4486: FUNCTION get_rep_code_id (
4487: p_result_id IN ZX_PROCESS_RESULTS.RESULT_ID%TYPE,
4488: p_date IN ZX_LINES.TRX_DATE%TYPE) RETURN ZX_REPORTING_CODES_B.REPORTING_CODE_ID%TYPE IS
4489: l_api_name CONSTANT VARCHAR2(30):= 'GET_REP_CODE_ID';
4490: l_reporting_code_id ZX_REPORTING_CODES_B.REPORTING_CODE_ID%type;
4491: l_date ZX_LINES.TRX_DATE%TYPE;

Line 4509: AND assoc.entity_code = 'ZX_PROCESS_RESULTS'

4505: INTO l_reporting_code_id
4506: FROM zx_reporting_types_b types,
4507: zx_report_codes_assoc assoc
4508: WHERE types.legal_message_flag = 'Y'
4509: AND assoc.entity_code = 'ZX_PROCESS_RESULTS'
4510: AND assoc.entity_id = p_result_id
4511: AND assoc.reporting_type_id = types.reporting_type_id
4512: AND l_date BETWEEN assoc.effective_from AND NVL(assoc.effective_to, l_date);
4513: