DBA Data[Home] [Help]

APPS.PA_FUNDING_CORE dependencies on PA_PROJ_FUND_VALID_V

Line 140: -- Added new param p_project_id and used pa_proj_fund_valid_v

136: --
137: --History:
138: -- 16-APR-2000 Created Adwait Marathe.
139: -- 07-sep-2001 Modified for MCB2
140: -- Added new param p_project_id and used pa_proj_fund_valid_v
141:
142: FUNCTION check_valid_project
143: (p_customer_id IN NUMBER,
144: p_project_id IN NUMBER,

Line 159: Cursor c1 is select 1 from pa_proj_fund_valid_v

155: and pa_project_stus_utils.is_project_status_closed(p.project_status_code) = 'N'
156: and c.customer_id = p_customer_id and lk.lookup_type(+) = 'ALLOWABLE FUNDING LEVEL'
157: and lk.lookup_code(+) = pt.allowable_funding_level_code;
158: commented for mcb2 change */
159: Cursor c1 is select 1 from pa_proj_fund_valid_v
160: where project_id = p_project_id
161: and customer_id = p_customer_id
162: AND project_type_class_code = 'CONTRACT'; /* Added for bug 3017733 */
163: