DBA Data[Home] [Help]

APPS.PA_MAINT_PROJECT_COMMITMENTS dependencies on PA_RESOURCE_LIST_ASSIGNMENTS

Line 4: TABLE OF PA_RESOURCE_LIST_ASSIGNMENTS.RESOURCE_LIST_ID%TYPE

1: PACKAGE body PA_MAINT_PROJECT_COMMITMENTS AS
2: /* $Header: PAACCMTB.pls 120.1 2005/08/19 16:13:47 mwasowic noship $ */
3: TYPE resource_list_id_tabtype IS
4: TABLE OF PA_RESOURCE_LIST_ASSIGNMENTS.RESOURCE_LIST_ID%TYPE
5: INDEX BY BINARY_INTEGER;
6:
7: Procedure Process_Txn_Accum_Cmt (X_project_id in Number,
8: X_impl_opt In Varchar2,

Line 25: PA_RESOURCE_LIST_ASSIGNMENTS

21: CURSOR Reslist_assgmt_Cur IS
22: SELECT Distinct
23: Resource_list_id
24: FROM
25: PA_RESOURCE_LIST_ASSIGNMENTS
26: Where Project_id = X_project_id;
27:
28: x_resource_list_id resource_list_id_tabtype;
29: x_Res_accum_Res_list_id Number := 0;