DBA Data[Home] [Help]

APPS.PA_TRANSACTIONS_PUB dependencies on PA_LOOKUPS

Line 832: --from pa_lookups.

828: nvl(ei.org_id,'-99') = nvl(x_org_id,nvl(ei.org_id,'-99')) AND
829: x_expenditure_type_class = 'VI';
830:
831: --The following Cursor selects the meaning for the adjustment_status_code
832: --from pa_lookups.
833:
834: CURSOR adjustment_status_meaning IS
835: SELECT meaning
836: FROM pa_lookups

Line 836: FROM pa_lookups

832: --from pa_lookups.
833:
834: CURSOR adjustment_status_meaning IS
835: SELECT meaning
836: FROM pa_lookups
837: WHERE lookup_type = 'PA_ADJUSTMENT_STATUS'
838: AND lookup_code = x_adjustment_status_code;
839:
840: l_net_zero_adjustment_flag pa_expenditure_items_all.net_zero_adjustment_flag%TYPE;