APPS.PA_PAXRWPTY_XMLP_PKG dependencies on PA_LOOKUPS

Line 53: pa_lookups

49: meaning
50: into
51: message_name
52: from
53: pa_lookups
54: where
55: lookup_type = 'MESSAGE'
56: and lookup_code = 'NO_DATA_FOUND';
57: c_no_data_found := message_name;

Line 133: from pa_lookups

129: function get_meaning (type in VARCHAR2,code in VARCHAR2) return VARCHAR2 is
130: v_meaning varchar2(80);
131: cursor c is
132: select meaning
133: from pa_lookups
134: where lookup_type = type
135: and lookup_code = code;
136: begin
137: open c;

Line 206: SELECT SUBSTR(meaning,1,40) INTO temp_disp_meth FROM pa_lookups

202: function cf_bur_amt_disp_methformula(burden_amt_display_method in varchar2) return varchar2 is
203: temp_disp_meth VARCHAR2(40):=null;
204: begin
205: IF burden_amt_display_method IS NOT NULL THEN
206: SELECT SUBSTR(meaning,1,40) INTO temp_disp_meth FROM pa_lookups
207: WHERE lookup_type = 'BURDEN_ACCOUNTING'
208: AND lookup_code = burden_amt_display_method ;
209: END IF;
210: RETURN temp_disp_meth ;