APPS.PA_PAXPRCON_XMLP_PKG dependencies on PA_LOOKUPS

Line 87: pa_lookups

83: meaning
84: into
85: message_name
86: from
87: pa_lookups
88: where
89: lookup_type = 'MESSAGE'
90: and lookup_code = 'NO_DATA_FOUND';
91: c_no_data_found := replace(message_name,'*','');

Line 222: l_reason pa_lookups.meaning%TYPE;

218: WHEN OTHERS THEN
219: RAISE;
220: end;
221: function cf_emp_reasonformula(emp_disc_reason in varchar2) return char is
222: l_reason pa_lookups.meaning%TYPE;
223: Begin
224: select meaning
225: into l_reason
226: from pa_lookups

Line 226: from pa_lookups

222: l_reason pa_lookups.meaning%TYPE;
223: Begin
224: select meaning
225: into l_reason
226: from pa_lookups
227: where lookup_type ='RATE AND DISCOUNT REASON'
228: and lookup_code= emp_disc_reason;
229: return(l_reason);
230: EXCEPTION

Line 236: l_reason pa_lookups.meaning%TYPE;

232: l_reason:=NULL;
233: return(l_reason);
234: end;
235: function cf_nl_reasonformula(nl_disc_reason in varchar2) return char is
236: l_reason pa_lookups.meaning%TYPE;
237: Begin
238: select meaning
239: into l_reason
240: from pa_lookups

Line 240: from pa_lookups

236: l_reason pa_lookups.meaning%TYPE;
237: Begin
238: select meaning
239: into l_reason
240: from pa_lookups
241: where lookup_type ='RATE AND DISCOUNT REASON'
242: and lookup_code= nl_disc_reason;
243: return(l_reason);
244: EXCEPTION

Line 250: l_reason pa_lookups.meaning%TYPE;

246: l_reason:=NULL;
247: return(l_reason);
248: end;
249: function cf_job_reasonformula(job_disc_reason in varchar2) return char is
250: l_reason pa_lookups.meaning%TYPE;
251: Begin
252: select meaning
253: into l_reason
254: from pa_lookups

Line 254: from pa_lookups

250: l_reason pa_lookups.meaning%TYPE;
251: Begin
252: select meaning
253: into l_reason
254: from pa_lookups
255: where lookup_type ='RATE AND DISCOUNT REASON'
256: and lookup_code= job_disc_reason;
257: return(l_reason);
258: EXCEPTION

Line 366: FROM pa_lookups lkp, pa_projects prj

362: tmp_flag VARCHAR2(80);
363: begin
364: IF enable_top_task_customer_flag IS NOT NULL THEN
365: SELECT meaning INTO tmp_flag
366: FROM pa_lookups lkp, pa_projects prj
367: WHERE lkp.lookup_type = 'YES_NO'
368: AND lkp.lookup_code = prj.enable_top_task_customer_flag
369: -- AND prj.project_id = project_id;
370: AND prj.project_id = project_id_1;

Line 384: FROM pa_lookups lkp, pa_projects prj

380: tmp_flag VARCHAR2(80);
381: begin
382: IF enable_top_task_inv_mth_flag IS NOT NULL THEN
383: SELECT meaning INTO tmp_flag
384: FROM pa_lookups lkp, pa_projects prj
385: WHERE lkp.lookup_type = 'YES_NO'
386: AND lkp.lookup_code = prj.enable_top_task_inv_mth_flag
387: -- AND prj.project_id = project_id;
388: AND prj.project_id = project_id_1;

Line 402: FROM pa_lookups lkp, pa_projects prj

398: tmp_flag VARCHAR2(80);
399: begin
400: IF revenue_accrual_method IS NOT NULL THEN
401: SELECT meaning INTO tmp_flag
402: FROM pa_lookups lkp, pa_projects prj
403: WHERE lkp.lookup_type = 'REVENUE ACCRUAL METHOD'
404: AND lkp.lookup_code = prj.revenue_accrual_method
405: -- AND prj.project_id = project_id;
406: AND prj.project_id = project_id_1;

Line 420: FROM pa_lookups lkp, pa_projects prj

416: tmp_flag VARCHAR2(80);
417: begin
418: IF invoice_method IS NOT NULL THEN
419: SELECT meaning INTO tmp_flag
420: FROM pa_lookups lkp, pa_projects prj
421: WHERE lkp.lookup_type = 'INVOICE METHOD'
422: AND lkp.lookup_code = prj.invoice_method
423: -- AND prj.project_id = project_id;
424: AND prj.project_id = project_id_1;