APPS.PA_UTILS4 dependencies on PA_LOOKUPS

Line 411: from pa_lookups

407: If p_assignment_id = 0 then
408:
409: select meaning
410: into l_assignment_name
411: from pa_lookups
412: where lookup_type = 'PA_EXP_ASSGN_ENTRY'
413: and lookup_code = 'UNSCHEDULED';
414:
415: Else

Line 1343: from pa_lookups l

1339: -- If unit_of_measure in pa_expenditure_items_all is populated
1340: If p_unit_of_measure IS NOT NULL THEN
1341: select l.meaning
1342: into l_uom_m
1343: from pa_lookups l
1344: where lookup_type = 'UNIT'
1345: and lookup_code = p_unit_of_measure ;
1346: -- If unit_of_measure in pa_expenditure_items_all is NOT populated
1347: else

Line 1350: from pa_lookups l,

1346: -- If unit_of_measure in pa_expenditure_items_all is NOT populated
1347: else
1348: select l.meaning
1349: into l_uom_m
1350: from pa_lookups l,
1351: pa_expenditure_types et
1352: where lookup_type = 'UNIT'
1353: and lookup_code = et.unit_of_measure
1354: and et.expenditure_type = p_expenditure_type ;