[Home] [Help]
337: l_currency_record_type := 4;
338: BEGIN
339: SELECT projfunc_currency_code
340: INTO l_Currency_Code
341: FROM pa_projects_all
342: WHERE project_id = l_project_ids_tbl(i);
343: EXCEPTION
344: WHEN OTHERS THEN
345: l_Currency_Code := NULL;
349: l_currency_record_type := 8;
350: BEGIN
351: SELECT project_currency_code
352: INTO l_Currency_Code
353: FROM pa_projects_all
354: WHERE project_id = l_project_ids_tbl(i);
355: EXCEPTION
356: WHEN OTHERS THEN
357: l_Currency_Code := NULL;
1894: END IF;
1895:
1896: SELECT pia.fte_day
1897: INTO l_hours_per_day
1898: FROM pa_implementations_all pia, pa_projects_all ppa WHERE pia.org_id = ppa.org_id and ppa.project_id = pProjectId;
1899:
1900: /* To handle the program reporting when current version and orginal version are same
1901: * we have to generate a local table with current version orginal version in different
1902: * rows even the version id is same. So we will fix the index of those plan versions
1949: ELSE
1950: BEGIN
1951: SELECT DISTINCT UPPER(t.project_type_class_code)
1952: INTO l_project_type_class
1953: FROM pa_projects_all p
1954: , pa_project_types_all t
1955: WHERE 1=1
1956: AND p.project_id = pProjectId
1957: AND p.project_type = t.project_type
1993: /* Added by Ning to get the next invoice date */
1994: SELECT start_date, billing_cycle_id,
1995: billing_offset
1996: INTO l_start_date, l_billing_cycle_id, l_billing_offset
1997: FROM pa_projects_all
1998: WHERE project_id = pProjectId;
1999:
2000: l_next_invoice_date :=
2001: Pa_Billing_Cycles_Pkg.get_next_billing_date(
3204: , org_id
3205: INTO
3206: xDaysSinceITD
3207: , l_org_id
3208: FROM pa_projects_all,
3209: ( SELECT end_date
3210: FROM pji_time_ent_period_v
3211: WHERE 1=1
3212: AND TO_DATE(pPeriodDateJulian,'j') BETWEEN start_date AND end_date