APPS.PA_PAXPRCON_XMLP_PKG dependencies on PA_PROJECT_TYPES
Line 44: SELECT billing_cycle_id INTO p_bill_id FROM pa_project_types
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 45: WHERE project_type = p_ptype ;
46: IF p_bill_id IS NOT NULL THEN
47: SELECT billing_cycle_name INTO p_bill_name
48: FROM pa_billing_cycles