APPS.PA_FAXFACE dependencies on PA_LOOKUPS

Line 934: FROM pa_lookups

930:
931: BEGIN
932: SELECT meaning
933: INTO x_translated_reversal
934: FROM pa_lookups
935: WHERE lookup_type = 'TRANSLATION' and
936: lookup_code = 'REVERSAL';
937: EXCEPTION
938: WHEN NO_DATA_FOUND THEN

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

2539: FROM sys.dual;
2540: curr_grouping_method:=cdlrec.grouping_method;
2541: description:= curr_grouping_method ;
2542:
2543: --Get Meaning from pa_lookups for Retirement Cost Type, populate Retirement Cost Type
2544: IF (x_line_type = 'R') THEN
2545:
2546: IF cdlrec.grouping_method = 'POS' THEN
2547: v_retirement_cost_type := 'POS';

Line 2554: FROM pa_lookups

2550: END IF;
2551:
2552: SELECT meaning
2553: INTO description
2554: FROM pa_lookups
2555: WHERE lookup_type = 'RETIREMENT_COST_TYPE'
2556: AND lookup_code = cdlrec.grouping_method;
2557:
2558: END IF;

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

2632: curr_grouping_method:=cdlrec.grouping_method;
2633: description:= curr_grouping_method ;
2634:
2635:
2636: --Get Meaning from pa_lookups for Retirement Cost Type
2637: IF (x_line_type = 'R') THEN
2638:
2639: IF cdlrec.grouping_method = 'POS' THEN
2640: v_retirement_cost_type := 'POS';

Line 2647: FROM pa_lookups

2643: END IF;
2644:
2645: SELECT meaning
2646: INTO description
2647: FROM pa_lookups
2648: WHERE lookup_type = 'RETIREMENT_COST_TYPE'
2649: AND lookup_code = cdlrec.grouping_method;
2650:
2651: END IF;

Line 3130: transfer_rejection_reason pa_lookups.meaning%TYPE;

3126: x_err_stage IN OUT NOCOPY VARCHAR2,
3127: x_err_code IN OUT NOCOPY NUMBER)
3128: IS
3129:
3130: transfer_rejection_reason pa_lookups.meaning%TYPE;
3131:
3132: BEGIN
3133:
3134: x_err_code := 0;