DBA Data[Home] [Help]

APPS.JL_ZZ_AR_UPLOAD_TAXES dependencies on JL_AR_TURN_UPL_T

Line 57: SELECT * FROM JL_AR_TURN_UPL_T

53: AND HZSU.ORG_ID = P_ORG_ID
54: ORDER BY HZSU.SITE_USE_ID;
55:
56: CURSOR GET_DATA_FROM_TMP(C_TAX_PAYER_ID NUMBER) IS
57: SELECT * FROM JL_AR_TURN_UPL_T
58: WHERE TAXPAYER_ID = C_TAX_PAYER_ID;
59:
60: l_all_valid_rec GET_DATA_FROM_TMP%ROWTYPE;
61:

Line 109: FROM JL_AR_TURN_UPL_T

105:
106: BEGIN -- Checking whether Taxpayer Exists in Current Month
107: SELECT 'Y'
108: INTO l_exist_in_tmp
109: FROM JL_AR_TURN_UPL_T
110: WHERE TAXPAYER_ID = P_TAXPAYER_ID;
111: EXCEPTION
112: WHEN No_Data_Found THEN
113: l_exist_in_tmp := 'N';