APPS.IGC_CC_MC_MAIN_PVT dependencies on GL_ALC_LEDGER_RSHIPS_V

Line 33: l_rsob_id GL_ALC_LEDGER_RSHIPS_V.LEDGER_ID%TYPE;

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

Line 49: FROM GL_ALC_LEDGER_RSHIPS_V

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

Line 310: l_rsob_id GL_ALC_LEDGER_RSHIPS_V.LEDGER_ID%TYPE;

306: l_Conversion_Type VARCHAR2(30);
307: l_CC_Acct_Func_Amt NUMBER;
308: l_CC_Acct_Encmbrnc_Amt NUMBER;
309: l_CC_Func_Withheld_Amt NUMBER;
310: l_rsob_id GL_ALC_LEDGER_RSHIPS_V.LEDGER_ID%TYPE;
311: l_rate_exists VARCHAR2(1);
312: l_api_name CONSTANT VARCHAR2(30) := 'get_rsobs_Acct_Lines';
313: l_api_version CONSTANT NUMBER := 1.0;
314: l_return_status VARCHAR2(1);

Line 326: FROM GL_ALC_LEDGER_RSHIPS_V

322: AND ORG_ID = p_Org_Id
323: AND application_id = l_Application_Id;*/
324: CURSOR c_conversion_type IS
325: SELECT ALC_DEFAULT_CONV_RATE_TYPE
326: FROM GL_ALC_LEDGER_RSHIPS_V
327: WHERE primary_ledger_id = p_Set_Of_Books_Id
328: AND ledger_id = l_rsob_id
329: -- AND ORG_ID = p_Org_Id
330: AND application_id = l_Application_Id;

Line 643: l_rsob_id GL_ALC_LEDGER_RSHIPS_V.LEDGER_ID%TYPE;

639: l_Conversion_Rate Number;
640: l_Conversion_Type VARCHAR2(30);
641: l_CC_DET_PF_Func_Amt NUMBER;
642: l_CC_DET_PF_ENCMBRNC_AMT NUMBER;
643: l_rsob_id GL_ALC_LEDGER_RSHIPS_V.LEDGER_ID%TYPE;
644: l_rate_exists VARCHAR2(1);
645: l_api_name CONSTANT VARCHAR2(30) := 'get_rsobs_DET_PF';
646: l_api_version CONSTANT NUMBER := 1.0;
647: l_return_status VARCHAR2(1);

Line 659: FROM GL_ALC_LEDGER_RSHIPS_V

655: AND ORG_ID = p_Org_Id
656: AND application_id = l_Application_Id; */
657: CURSOR c_conversion_type IS
658: SELECT ALC_DEFAULT_CONV_RATE_TYPE
659: FROM GL_ALC_LEDGER_RSHIPS_V
660: WHERE primary_ledger_id = p_Set_Of_Books_Id
661: AND ledger_id = l_rsob_id
662: -- AND ORG_ID = p_Org_Id
663: AND application_id = l_Application_Id;