DBA Data[Home] [Help]

APPS.AR_ARXAPRRM_XMLP_PKG dependencies on AR_LOOKUPS

Line 129: FROM AR_LOOKUPS

125: l_sort_by varchar(30);
126: BEGIN
127: SELECT meaning
128: INTO l_sort_by
129: FROM AR_LOOKUPS
130: WHERE lookup_type = 'SORT_BY_ARXAPRRM'
131: AND lookup_code = P_SORT_BY;
132: RETURN(l_sort_by);
133: EXCEPTION

Line 144: FROM AR_LOOKUPS

140: l_status varchar(30);
141: BEGIN
142: SELECT meaning
143: INTO l_status
144: FROM AR_LOOKUPS
145: WHERE lookup_type = 'ARXAPRRM_BATCH_APPLIED_STATUS'
146: AND lookup_code = P_STATUS;
147: RETURN(l_status);
148: EXCEPTION

Line 159: FROM AR_LOOKUPS

155: l_rmethod varchar(30);
156: BEGIN
157: SELECT meaning
158: INTO l_rmethod
159: FROM AR_LOOKUPS
160: WHERE lookup_type = 'REMITTANCE_METHOD'
161: AND lookup_code = P_REMIT_METHOD;
162: RETURN(l_rmethod);
163: EXCEPTION