APPS.ASO_PA_APR_INT dependencies on FND_LOOKUPS

Line 57: from fnd_lookups

53:
54: /* Cursor to fetch approver category description*/
55: CURSOR c_appr_cat (l_value VARCHAR2 ) is
56: select meaning
57: from fnd_lookups
58: where lookup_type = 'AME_APPROVER_CATEGORY'
59: and lookup_code = l_value
60: and enabled_flag = 'Y';
61:

Line 65: from fnd_lookups

61:
62: /* Cursor to fetch approver type description*/
63: CURSOR c_appr_type (l_value VARCHAR2 ) is
64: select meaning
65: from fnd_lookups
66: where lookup_type = 'FND_WF_ORIG_SYSTEMS'
67: and lookup_code = l_value
68: and enabled_flag = 'Y';
69:

Line 73: from fnd_lookups

69:
70: /* Cursor to fetch Sublist Desc */
71: CURSOR c_appr_sublist (l_value VARCHAR2 ) is
72: select meaning
73: from fnd_lookups
74: where lookup_type = 'AME_SUBLIST_TYPES'
75: and lookup_code = l_value
76: and enabled_flag = 'Y';
77:

Line 1883: from fnd_lookups

1879:
1880: /* Cursor to fetch approver category description*/
1881: CURSOR c_appr_cat (l_value VARCHAR2 ) is
1882: select meaning
1883: from fnd_lookups
1884: where lookup_type = 'AME_APPROVER_CATEGORY'
1885: and lookup_code = l_value
1886: and enabled_flag = 'Y';
1887:

Line 1892: from fnd_lookups

1888:
1889: /* Cursor to fetch Sublist Desc */
1890: CURSOR c_appr_sublist (l_value VARCHAR2 ) is
1891: select meaning
1892: from fnd_lookups
1893: where lookup_type = 'AME_SUBLIST_TYPES'
1894: and lookup_code = l_value
1895: and enabled_flag = 'Y';
1896: