APPS.PA_PROJECT_REQUEST_PVT dependencies on PA_LOOKUPS

Line 134: FROM pa_lookups

130: IS
131:
132: CURSOR lup IS
133: SELECT lookup_code, meaning
134: FROM pa_lookups
135: WHERE lookup_type = 'PROJ_REQ_OBJECT_TYPE'
136: AND lookup_code = p_object_type;
137:
138: v_lup lup%ROWTYPE;

Line 151: FROM pa_project_requests r, pa_project_statuses s, pa_lookups lup

147: v_prj prj%ROWTYPE;
148:
149: CURSOR prq IS
150: SELECT r.request_name, r.request_number, lup.meaning, s.project_status_name, r.description
151: FROM pa_project_requests r, pa_project_statuses s, pa_lookups lup
152: WHERE r.status_code = s.project_status_code
153: AND r.request_id = p_object_id1
154: AND r.request_type = lup.lookup_code
155: AND lup.lookup_type = 'PROJECT_REQUEST_TYPE';

Line 729: FROM pa_lookups

725: --get opportunity organization role.
726:
727: SELECT meaning
728: INTO l_opp_org_role_name
729: FROM pa_lookups
730: WHERE lookup_type='OPPORTUNITY_ORG_ROLE'
731: AND lookup_code = 'CUSTOMER';
732:
733: debug('l_opp_org_role_name = ' || l_opp_org_role_name);

Line 832: FROM pa_lookups

828: INTO l_lead_number, l_lead_description;
829:
830: SELECT meaning
831: INTO l_request_type_meaning
832: FROM pa_lookups
833: WHERE lookup_type = 'PROJECT_REQUEST_TYPE'
834: AND lookup_code = l_request_type;
835:
836: x_field_names(l_index) := 'LONG_NAME';

Line 1147: stmt_class2 := ' FROM as_leads l, as_interests i, pa_lookups lookups'

1143: || 'l.lead_id lead_id,'
1144: || 'l.org_id source_org_id,'
1145: || 'null as category ' ; /* removed h.category for bug 3744823 */
1146:
1147: stmt_class2 := ' FROM as_leads l, as_interests i, pa_lookups lookups'
1148: || ' WHERE '
1149: || 'lookups.lookup_type = ''PROJECT_REQUEST_TYPE'' '
1150: || ' AND lookups.lookup_code = :1'
1151: || ' AND ('

Line 1220: ||' , pa_lookups lookups '

1216:
1217: stmt_categ2 := ' FROM as_leads l'
1218: ||' , as_lead_lines_all ll'
1219: ||' , pa_lead_categories_v h'
1220: ||' , pa_lookups lookups '
1221: ||' WHERE '
1222: ||' lookups.lookup_type = ''PROJECT_REQUEST_TYPE'' '
1223: ||' AND lookups.lookup_code = :1 '
1224: ||' AND ll.product_category_id = h.category_id'