APPS.PA_PJI_UTIL_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 40

	     SELECT calendar_id
		 INTO   l_calendar_id
		 FROM pa_time_cal_name /* Modified for bug 12979524 */
		 WHERE period_set_name = p_period_set_name AND
		       period_type = p_period_type;

Line: 56

	     SELECT cal_period_id
		 INTO   l_period_id
		 FROM pji_time_cal_period
		 WHERE calendar_id = l_calendar_id AND
		       name = p_period_name;

Line: 75

	     SELECT NVL(conf_wtd_org_hrs_s,0),
		        NVL(capacity_hrs,0),
				NVL(reduce_capacity_hrs_s,0)
		 INTO   x_utl_hours,
		        l_capacity_hrs,
				l_reduce_capacity_hrs
		 FROM pji_rm_org_f_mv
		 WHERE expenditure_organization_id = p_organization_id AND
		       expenditure_org_id          = p_org_id          AND
			   time_id                     = l_period_id       AND
               period_type_id              = 32                AND
               ROWNUM = 1;