DBA Data[Home] [Help]

APPS.PA_TRANSACTIONS_PUB dependencies on PA_LOOKUPS

Line 774: --from pa_lookups.

770: nvl(ei.org_id,'-99') = nvl(x_org_id,nvl(ei.org_id,'-99')) AND
771: x_expenditure_type_class = 'VI';
772:
773: --The following Cursor selects the meaning for the adjustment_status_code
774: --from pa_lookups.
775:
776: CURSOR adjustment_status_meaning IS
777: SELECT meaning
778: FROM pa_lookups

Line 778: FROM pa_lookups

774: --from pa_lookups.
775:
776: CURSOR adjustment_status_meaning IS
777: SELECT meaning
778: FROM pa_lookups
779: WHERE lookup_type = 'PA_ADJUSTMENT_STATUS'
780: AND lookup_code = x_adjustment_status_code;
781:
782: l_net_zero_adjustment_flag pa_expenditure_items_all.net_zero_adjustment_flag%TYPE;