APPS.PA_BUDGET_ACCOUNT_PKG dependencies on PA_IMPLEMENTATIONS

Line 896: from pa_implementations imp, gl_sets_of_books sob

892:
893: PA_FCK_UTIL.debug_msg(l_return_status||' gen after calling derive_res_para ..........');
894: select sob.chart_of_accounts_id
895: into l_chart_of_accounts_id
896: from pa_implementations imp, gl_sets_of_books sob
897: where imp.set_of_books_id = sob.set_of_books_id;
898:
899: PA_FCK_UTIL.debug_msg(l_return_status||' gen after getting chart of account id ..........');
900: -------------------------------------+

Line 1411: l_Set_Of_Books_Id pa_implementations_all.set_of_books_id%type;

1407: l_msg_Index_out NUMBER;
1408:
1409: l_BL_Max_Date DATE;
1410: l_Boundary_Code VARCHAR2(1);
1411: l_Set_Of_Books_Id pa_implementations_all.set_of_books_id%type;
1412:
1413: ------------------------------------------------------------------------------+
1414: -- Cursor to fetch all missed GL Periods for a given Res. Assign ID and Start Date
1415: ------------------------------------------------------------------------------+

Line 1426: PA_Implementations IMP,

1422: GLPRD.Start_Date START_DATE,
1423: GLPRD.End_Date END_DATE
1424: FROM
1425: GL_Period_Statuses GLPRD,
1426: PA_Implementations IMP,
1427: PA_Resource_Assignments RA1
1428: WHERE
1429: GLPRD.Application_ID = PA_Period_Process_Pkg.Application_ID -- 101
1430: AND GLPRD.Set_Of_Books_ID = IMP.Set_Of_Books_ID

Line 1450: PA_Implementations IMP2

1446: FROM
1447: PA_Budget_Lines BL2,
1448: PA_Resource_Assignments RA2,
1449: GL_Period_Statuses GLPRD2,
1450: PA_Implementations IMP2
1451: WHERE
1452: RA2.Resource_Assignment_ID = BL2.Resource_Assignment_ID
1453: AND RA2.Project_ID = P_Project_ID
1454: AND RA2.Budget_Version_ID = p_Budget_Version_ID

Line 1495: Select set_of_books_id into l_set_of_books_id from pa_implementations;

1491: WHERE BL.Budget_Version_ID = p_Budget_Version_ID;
1492:
1493: PA_FCK_UTIL.debug_msg(' Max. end date is:'||l_BL_Max_Date);
1494:
1495: Select set_of_books_id into l_set_of_books_id from pa_implementations;
1496:
1497: PA_FCK_UTIL.debug_msg(' SOB ID:' ||l_set_of_books_id);
1498:
1499: SELECT gps.year_start_date,