APPS.PA_UTILS4 dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 516: pa_expenditure_items_all based on project assignment)

512: */
513:
514: /* Bug 4092732 : Regardless of PJR license, matching assignment should be stamped against
515: an expenditure item. (assignment_id should be populated on
516: pa_expenditure_items_all based on project assignment)
517: If PA_UTILS4.G_PRM_INSTALLED_FLAG is NULL then
518:
519: PA_UTILS4.G_PRM_INSTALLED_FLAG := nvl(PA_INSTALL.is_prm_licensed,'N');
520:

Line 808: FROM pa_expenditure_items_all ei

804: ELSE
805:
806: SELECT billable_flag
807: INTO l_billable_flag
808: FROM pa_expenditure_items_all ei
809: WHERE ei.expenditure_item_id=orig_eid;
810:
811: END IF ;
812:

Line 836: FROM pa_expenditure_items_all ei

832: l_bill_hold_flag := bill_hold_flag;
833: ELSE
834: SELECT bill_hold_flag
835: INTO l_bill_hold_flag
836: FROM pa_expenditure_items_all ei
837: WHERE ei.expenditure_item_id=orig_eid;
838: END IF ;
839: RETURN l_bill_hold_flag;
840:

Line 1339: -- If unit_of_measure in pa_expenditure_items_all is populated

1335: p_expenditure_type IN VARCHAR2) return VARCHAR2 IS
1336:
1337: l_uom_m VARCHAR2(80) := NULL ;
1338: begin
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

Line 1346: -- If unit_of_measure in pa_expenditure_items_all is NOT populated

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
1348: select l.meaning
1349: into l_uom_m
1350: from pa_lookups l,