DBA Data[Home] [Help]

APPS.AR_ARXAPRMB_XMLP_PKG dependencies on AR_LOOKUPS

Line 80: FROM AR_LOOKUPS

76: l_sort_by varchar(40);
77: BEGIN
78: SELECT meaning
79: INTO l_sort_by
80: FROM AR_LOOKUPS
81: WHERE lookup_type = 'SORT_BY_ARXAPRMB'
82: AND lookup_code = P_SORT_BY;
83:
84: RETURN(l_sort_by);

Line 99: FROM AR_LOOKUPS

95: l_status varchar(50);
96: BEGIN
97: SELECT meaning
98: INTO l_status
99: FROM AR_LOOKUPS
100: WHERE lookup_type = 'BATCH_APPLIED_STATUS'
101: AND lookup_code = P_STATUS;
102:
103: RETURN(l_status);

Line 153: FROM AR_LOOKUPS

149: l_rem_met varchar(40);
150: BEGIN
151: SELECT meaning
152: INTO l_rem_met
153: FROM AR_LOOKUPS
154: WHERE LOOKUP_TYPE = 'REMITTANCE_METHOD'
155: AND ENABLED_FLAG = 'Y'
156: AND LOOKUP_CODE = P_REMITTANCE_METHOD;
157:

Line 216: FROM AR_LOOKUPS

212: l_sum_or_det varchar(80);
213: BEGIN
214: SELECT meaning
215: INTO l_sum_or_det
216: FROM AR_LOOKUPS
217: WHERE LOOKUP_TYPE = 'ARXAPRMB_SD'
218: AND ENABLED_FLAG = 'Y'
219: AND LOOKUP_CODE = P_SUMMARY_OR_DETAILED;
220: