DBA Data[Home] [Help]

APPS.PO_POXPOVPS_XMLP_PKG dependencies on FND_LOOKUPS

Line 8: l_yes_no fnd_lookups.meaning%type;

4: function BeforeReport return boolean is
5: begin
6: declare
7: l_sort po_lookup_codes.displayed_field%type;
8: l_yes_no fnd_lookups.meaning%type;
9: begin
10: P_CREATION_DATE_FROM_LP := to_char(P_CREATION_DATE_FROM,'DD-MON-YY');
11: P_CREATION_DATE_TO_LP := to_char(P_CREATION_DATE_TO,'DD-MON-YY');
12: if P_orderby is not null then

Line 27: FROM fnd_lookups

23: P_SMALL_BUSINESS_DISP := '';
24: ELSE
25: SELECT meaning
26: INTO l_yes_no
27: FROM fnd_lookups
28: WHERE lookup_type = 'YES_NO'
29: AND lookup_code = P_SMALL_BUSINESS;
30: P_SMALL_BUSINESS_DISP := l_yes_no;
31: END IF;

Line 37: FROM fnd_lookups

33: P_WOMEN_OWNED_DISP := '';
34: ELSE
35: SELECT meaning
36: INTO l_yes_no
37: FROM fnd_lookups
38: WHERE lookup_type = 'YES_NO'
39: AND lookup_code = P_WOMEN_OWNED;
40: P_WOMEN_OWNED_DISP := l_yes_no;
41: END IF;

Line 47: FROM fnd_lookups

43: P_MINORITY_OWNED_DISP := '';
44: ELSE
45: SELECT meaning
46: INTO l_yes_no
47: FROM fnd_lookups
48: WHERE lookup_type = 'YES_NO'
49: AND lookup_code = P_MINORITY_OWNED;
50: P_MINORITY_OWNED_DISP := l_yes_no;
51: END IF;