APPS.PA_BILLING_PROCESS_PKG dependencies on PA_PROJECTS

Line 27: FROM pa_projects p, pa_project_types t

23: /*Bug13600015 End here */
24:
25: CURSOR cproj IS
26: SELECT p.*
27: FROM pa_projects p, pa_project_types t
28: WHERE ((segment1 BETWEEN pfromproj AND ptoproj)
29: OR project_id =pproject_id)
30: AND p.project_type = t.project_type
31: AND t.project_type_class_code = 'CONTRACT'

Line 69: rproj pa_projects_all%ROWTYPE;

65:
66: --Bug13600015 following lines are added
67: Type Cur_Type IS REF CURSOR;
68: v_inv_cursor cur_type;
69: rproj pa_projects_all%ROWTYPE;
70: --Bug13600015 End here
71: BEGIN
72: PA_MCB_INVOICE_PKG.log_message('... Enter the procedure pa_process_rev_adj');
73:

Line 75: v_inv_query1 := 'SELECT p.*'||' FROM pa_projects p, pa_project_types t '||

71: BEGIN
72: PA_MCB_INVOICE_PKG.log_message('... Enter the procedure pa_process_rev_adj');
73:
74: --Bug 13600015 Below lines added
75: v_inv_query1 := 'SELECT p.*'||' FROM pa_projects p, pa_project_types t '||
76: 'WHERE ((segment1 BETWEEN :pfrmprj AND :ptoprj )'||
77: ' OR project_id = :pprj_id)'||
78: ' AND p.project_type = t.project_type '||
79: ' AND t.project_type_class_code = ''CONTRACT'' '||