DBA Data[Home] [Help]

APPS.PA_FP_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 101: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;

97:
98: l_appl_id NUMBER;
99: l_cnt NUMBER;
100:
101: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
102: l_budget_lines_exist VARCHAR2(1) ;
103: l_call_calculate VARCHAR2(1);
104:
105: l_last_updated_by NUMBER := FND_GLOBAL.user_id;