APPS.ASO_DEAL_PUB dependencies on ASO_QUOTE_STATUSES_B

Line 29: FROM aso_quote_statuses_b

25: -- for fetching status id
26: CURSOR C_qte_status_id (pc_quote_status_code VARCHAR2)
27: IS
28: SELECT quote_status_id
29: FROM aso_quote_statuses_b
30: WHERE status_code = pc_quote_status_code;
31:
32: -- for fetching quote header details
33: CURSOR C_quote_header(pc_quote_header_id NUMBER)

Line 953: FROM aso_quote_statuses_b

949: -- check additional conditions for max version, batch pricing, status
950: IF l_access_level = 'UPDATE' then
951:
952: SELECT quote_status_id INTO t_quote_status_id
953: FROM aso_quote_statuses_b
954: WHERE status_code = 'PRICE APPROVAL PENDING';
955:
956:
957: if l_max_version_flag='N' then -- checking for max version

Line 963: FROM aso_quote_statuses_b

959: elsif (t_quote_status_id<>l_quote_status_id) then
960:
961: SELECT update_allowed_flag
962: INTO t_update_allowed_flag
963: FROM aso_quote_statuses_b
964: WHERE quote_status_id = l_quote_status_id;
965:
966: l_status_override :=nvl(fnd_profile.value('ASO_STATUS_OVERRIDE'),'N');
967: