APPS.PA_FAXFACE dependencies on PA_LOOKUPS

Line 876: FROM pa_lookups

872:
873: BEGIN
874: SELECT meaning
875: INTO x_translated_reversal
876: FROM pa_lookups
877: WHERE lookup_type = 'TRANSLATION' and
878: lookup_code = 'REVERSAL';
879: EXCEPTION
880: WHEN NO_DATA_FOUND THEN

Line 2218: --Get Meaning from pa_lookups for Retirement Cost Type, populate Retirement Cost Type

2214: FROM sys.dual;
2215: curr_grouping_method:=cdlrec.grouping_method;
2216: description:= curr_grouping_method ;
2217:
2218: --Get Meaning from pa_lookups for Retirement Cost Type, populate Retirement Cost Type
2219: IF (x_line_type = 'R') THEN
2220:
2221: IF cdlrec.grouping_method = 'POS' THEN
2222: v_retirement_cost_type := 'POS';

Line 2229: FROM pa_lookups

2225: END IF;
2226:
2227: SELECT meaning
2228: INTO description
2229: FROM pa_lookups
2230: WHERE lookup_type = 'RETIREMENT_COST_TYPE'
2231: AND lookup_code = cdlrec.grouping_method;
2232:
2233: END IF;

Line 2309: --Get Meaning from pa_lookups for Retirement Cost Type

2305: curr_grouping_method:=cdlrec.grouping_method;
2306: description:= curr_grouping_method ;
2307:
2308:
2309: --Get Meaning from pa_lookups for Retirement Cost Type
2310: IF (x_line_type = 'R') THEN
2311:
2312: IF cdlrec.grouping_method = 'POS' THEN
2313: v_retirement_cost_type := 'POS';

Line 2320: FROM pa_lookups

2316: END IF;
2317:
2318: SELECT meaning
2319: INTO description
2320: FROM pa_lookups
2321: WHERE lookup_type = 'RETIREMENT_COST_TYPE'
2322: AND lookup_code = cdlrec.grouping_method;
2323:
2324: END IF;

Line 2797: transfer_rejection_reason pa_lookups.meaning%TYPE;

2793: x_err_stage IN OUT NOCOPY VARCHAR2,
2794: x_err_code IN OUT NOCOPY NUMBER)
2795: IS
2796:
2797: transfer_rejection_reason pa_lookups.meaning%TYPE;
2798:
2799: BEGIN
2800:
2801: x_err_code := 0;