APPS.IGC_CC_MC_MAIN_HST_PVT dependencies on GL_ALC_LEDGER_RSHIPS_V

Line 34: l_rsob_id GL_ALC_LEDGER_RSHIPS_V.LEDGER_ID%TYPE;

30: l_FROM_CURR varchar2(10);
31: l_TO_CURR varchar2(10);
32: l_Conversion_Rate Number;
33: l_Conversion_Type VARCHAR2(30);
34: l_rsob_id GL_ALC_LEDGER_RSHIPS_V.LEDGER_ID%TYPE;
35: l_rate_exists VARCHAR2(1);
36: l_api_version NUMBER := 1.0;
37: l_api_name VARCHAR2(30) := 'GET_RSOBS_HEADERS';
38: l_return_status VARCHAR2(1);

Line 51: FROM GL_ALC_LEDGER_RSHIPS_V

47: AND ORG_ID = p_Org_Id
48: AND application_id = l_Application_Id; */
49: CURSOR c_conversion_type IS
50: SELECT ALC_DEFAULT_CONV_RATE_TYPE
51: FROM GL_ALC_LEDGER_RSHIPS_V
52: WHERE primary_ledger_id = p_Set_Of_Books_Id
53: AND ledger_id = l_rsob_id
54: -- AND ORG_ID = p_Org_Id
55: AND application_id = l_Application_Id;

Line 267: l_rsob_id GL_ALC_LEDGER_RSHIPS_V.LEDGER_ID%TYPE;

263: l_Conversion_Type VARCHAR2(30);
264: l_CC_Acct_Func_Amt NUMBER;
265: l_CC_Acct_Encmbrnc_Amt NUMBER;
266: l_CC_Func_Withheld_Amt NUMBER;
267: l_rsob_id GL_ALC_LEDGER_RSHIPS_V.LEDGER_ID%TYPE;
268: l_rate_exists VARCHAR2(1);
269: l_api_version CONSTANT NUMBER := 1.0;
270: l_api_name VARCHAR2(30) := 'GET_RSOBS_ACCT_LINES';
271: l_return_status VARCHAR2(1);

Line 285: FROM GL_ALC_LEDGER_RSHIPS_V

281: AND ORG_ID = p_Org_Id
282: AND application_id = l_Application_Id; */
283: CURSOR c_conversion_type IS
284: SELECT ALC_DEFAULT_CONV_RATE_TYPE
285: FROM GL_ALC_LEDGER_RSHIPS_V
286: WHERE primary_ledger_id = p_Set_Of_Books_Id
287: AND ledger_id = l_rsob_id
288: --AND ORG_ID = p_Org_Id
289: AND application_id = l_Application_Id;

Line 525: l_rsob_id GL_ALC_LEDGER_RSHIPS_V.LEDGER_ID%TYPE;

521: l_Conversion_Rate Number;
522: l_Conversion_Type VARCHAR2(30);
523: l_CC_DET_PF_Func_Amt NUMBER;
524: l_CC_DET_PF_ENCMBRNC_AMT NUMBER;
525: l_rsob_id GL_ALC_LEDGER_RSHIPS_V.LEDGER_ID%TYPE;
526: l_rate_exists VARCHAR2(1);
527: l_api_name VARCHAR2(30) := 'GET_RSOBS_DET_PF';
528: l_api_version CONSTANT NUMBER := 1.0;
529: l_return_status VARCHAR2(1);

Line 541: FROM GL_ALC_LEDGER_RSHIPS_V

537: AND ORG_ID = p_Org_Id
538: AND application_id = l_Application_Id; */
539: CURSOR c_conversion_type IS
540: SELECT ALC_DEFAULT_CONV_RATE_TYPE
541: FROM GL_ALC_LEDGER_RSHIPS_V
542: WHERE primary_ledger_id = p_Set_Of_Books_Id
543: AND ledger_id = l_rsob_id
544: -- AND ORG_ID = p_Org_Id
545: AND application_id = l_Application_Id;