DBA Data[Home] [Help]

APPS.PA_PAXARPVD_XMLP_PKG dependencies on PA_LOOKUPS

Line 33: PA_LOOKUPS

29: SELECT
30: MEANING
31: INTO NDF
32: FROM
33: PA_LOOKUPS
34: WHERE LOOKUP_CODE = 'NO_DATA_FOUND'
35: AND LOOKUP_TYPE = 'MESSAGE';
36: C_NO_DATA_FOUND := NDF;
37: SELECT

Line 83: PA_LOOKUPS LK

79: LK.MEANING
80: INTO C_BATCH_NAME,C_BATCH_DESCRIPTION,C_BATCH_STATUS,C_THROUGH_DATE,C_BATCH_ACTIVE_CLOSED,C_BATCH_STATUS_MEANING
81: FROM
82: PA_PURGE_BATCHES BAT,
83: PA_LOOKUPS LK
84: WHERE PURGE_BATCH_ID = P_PURGE_BATCH_ID
85: AND LK.LOOKUP_TYPE = 'PURGE_BATCH_STATUS'
86: AND LK.LOOKUP_CODE = BAT.BATCH_STATUS_CODE;
87: EXCEPTION

Line 93: PA_LOOKUPS

89: SELECT
90: MEANING
91: INTO NDF
92: FROM
93: PA_LOOKUPS
94: WHERE LOOKUP_CODE = 'NO_DATA_FOUND'
95: AND LOOKUP_TYPE = 'MESSAGE';
96: C_NO_DATA_FOUND := NDF;
97: C_DUMMY_DATA := 1;