DBA Data[Home] [Help]

APPS.PA_PAXRWIMP_XMLP_PKG dependencies on PA_LOOKUPS

Line 64: from pa_lookups

60: function get_meaning (type in VARCHAR2,code in VARCHAR2) return VARCHAR2 is
61: v_meaning varchar2(80);
62: cursor c is
63: select meaning
64: from pa_lookups
65: where lookup_type = type
66: and lookup_code = code;
67: begin
68: open c;

Line 273: FROM pa_lookups

269:
270: begin
271: IF cust_acc_rel_code IS NOT NULL THEN
272: SELECT meaning INTO tmp_over_flag
273: FROM pa_lookups
274: WHERE lookup_type = 'PA_CUST_ACC_REL_CODE'
275: AND lookup_code = cust_acc_rel_code;
276:
277: RETURN tmp_over_flag;