APPS.PA_FP_GEN_COMMITMENT_AMOUNTS dependencies on PA_PROJECTS_ALL

Line 22: ,c_org_id PA_PROJECTS_ALL.ORG_ID%TYPE

18: CURSOR SUM_COMM_CRSR( c_tphase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE
19: ,c_multi_curr_flag PA_PROJ_FP_OPTIONS.PLAN_IN_MULTI_CURR_FLAG%TYPE
20: ,c_appl_id GL_PERIOD_STATUSES.APPLICATION_ID%TYPE
21: ,c_set_of_books_id PA_IMPLEMENTATIONS_ALL.SET_OF_BOOKS_ID%TYPE
22: ,c_org_id PA_PROJECTS_ALL.ORG_ID%TYPE
23: )
24: IS
25: SELECT /*+ INDEX(TMP,PA_RES_LIST_MAP_TMP4_N2)*/
26: P.RESOURCE_ASSIGNMENT_ID

Line 79: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;

75:
76: l_appl_id NUMBER;
77: l_cnt NUMBER;
78:
79: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
80: l_budget_lines_exist VARCHAR2(1) ;
81: l_call_calculate VARCHAR2(1);
82:
83: l_last_updated_by NUMBER := FND_GLOBAL.user_id;

Line 280: l_project_name PA_PROJECTS_ALL.NAME%TYPE;

276: l_burden_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
277: l_pc_cur_conv_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
278: l_pfc_cur_conv_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
279:
280: l_project_name PA_PROJECTS_ALL.NAME%TYPE;
281: l_task_number PA_TASKS.TASK_NUMBER%TYPE;
282: l_resource_name PA_RESOURCE_LIST_MEMBERS.ALIAS%TYPE;
283:
284: -- Variables added for Bug Fix 4582616

Line 895: pa_projects_all p,

891: -- Get other message token details
892: SELECT p.name, ta.task_number, rlm.alias
893: INTO l_project_name, l_task_number, l_resource_name
894: FROM pa_resource_assignments ra,
895: pa_projects_all p,
896: pa_tasks ta,
897: pa_resource_list_members rlm
898: WHERE ra.resource_assignment_id = l_res_asg_id(i)
899: AND p.project_id = ra.project_id