APPS.PA_PAXPRCON_XMLP_PKG dependencies on PA_PROJECTS

Line 40: FROM pa_projects

36: NAME="PA_RULE_BASED_OPTIMIZER"
37: FIELD=":p_rule_optimizer"
38: PRINT_ERROR="N"');*/null;
39: SELECT name, segment1, project_type INTO p_name, p_number, p_ptype
40: FROM pa_projects
41: WHERE project_id = p_project_id;
42: c_project_name := p_name;
43: c_project_number := p_number;
44: SELECT billing_cycle_id INTO p_bill_id FROM pa_project_types

Line 71: FROM pa_projects_all

67: FROM gl_sets_of_books
68: WHERE set_of_books_id = (SELECT set_of_books_id
69: FROM pa_implementations_all
70: WHERE org_id = (SELECT org_id
71: FROM pa_projects_all
72: WHERE project_id = p_project_id ));
73: c_company_name_header := l_name;
74: RETURN (TRUE);
75: EXCEPTION

Line 272: FROM pa_projects_all

268: from gl_sets_of_books
269: where set_of_books_id = (SELECT set_of_books_id
270: FROM pa_implementations_all
271: WHERE org_id = (SELECT org_id
272: FROM pa_projects_all
273: WHERE project_id = p_project_id )
274: );
275: EXCEPTION
276: WHEN OTHERS THEN

Line 366: FROM pa_lookups lkp, pa_projects prj

362: tmp_flag VARCHAR2(80);
363: begin
364: IF enable_top_task_customer_flag IS NOT NULL THEN
365: SELECT meaning INTO tmp_flag
366: FROM pa_lookups lkp, pa_projects prj
367: WHERE lkp.lookup_type = 'YES_NO'
368: AND lkp.lookup_code = prj.enable_top_task_customer_flag
369: -- AND prj.project_id = project_id;
370: AND prj.project_id = project_id_1;

Line 384: FROM pa_lookups lkp, pa_projects prj

380: tmp_flag VARCHAR2(80);
381: begin
382: IF enable_top_task_inv_mth_flag IS NOT NULL THEN
383: SELECT meaning INTO tmp_flag
384: FROM pa_lookups lkp, pa_projects prj
385: WHERE lkp.lookup_type = 'YES_NO'
386: AND lkp.lookup_code = prj.enable_top_task_inv_mth_flag
387: -- AND prj.project_id = project_id;
388: AND prj.project_id = project_id_1;

Line 402: FROM pa_lookups lkp, pa_projects prj

398: tmp_flag VARCHAR2(80);
399: begin
400: IF revenue_accrual_method IS NOT NULL THEN
401: SELECT meaning INTO tmp_flag
402: FROM pa_lookups lkp, pa_projects prj
403: WHERE lkp.lookup_type = 'REVENUE ACCRUAL METHOD'
404: AND lkp.lookup_code = prj.revenue_accrual_method
405: -- AND prj.project_id = project_id;
406: AND prj.project_id = project_id_1;

Line 420: FROM pa_lookups lkp, pa_projects prj

416: tmp_flag VARCHAR2(80);
417: begin
418: IF invoice_method IS NOT NULL THEN
419: SELECT meaning INTO tmp_flag
420: FROM pa_lookups lkp, pa_projects prj
421: WHERE lkp.lookup_type = 'INVOICE METHOD'
422: AND lkp.lookup_code = prj.invoice_method
423: -- AND prj.project_id = project_id;
424: AND prj.project_id = project_id_1;