APPS.ASO_VALIDATE_PVT dependencies on ASO_LOOKUPS

Line 694: FROM aso_lookups lk

690: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
691: IS
692: CURSOR C_item_type_code IS
693: SELECT lookup_code
694: FROM aso_lookups lk
695: WHERE lookup_type = 'ASO_ITEM_TYPE'
696: AND lookup_code = p_item_type_code;
697:
698: /* select item_type_code from aso_i_item_types_v

Line 925: from aso_lookups

921: from aso_i_service_types_v
922: where service_reference_type_code = p_service_ref_type_code;*/
923: CURSOR C_servicetypes IS
924: select lookup_code
925: from aso_lookups
926: where lookup_code = p_service_ref_type_code and
927: lookup_type = 'ASO_SERVICE_TYPE';
928:
929: l_service_code VARCHAR2(30);

Line 1306: from aso_lookups

1302: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1303: IS
1304: CURSOR C_party_type IS
1305: select 'VALID'
1306: from aso_lookups
1307: where lookup_type = 'ASO_PARTY_TYPE'
1308: and lookup_code = p_party_type;
1309:
1310: l_valid VARCHAR2(240);

Line 1494: from aso_lookups

1490: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1491: IS
1492: CURSOR C_party_object_type IS
1493: select 'VALID'
1494: from aso_lookups
1495: where lookup_type = 'ASO_PARTY_OBJECT_TYPE'
1496: and lookup_code = p_party_object_type;
1497:
1498: l_valid VARCHAR2(240);

Line 3561: from aso_lookups

3557: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3558: )
3559: IS
3560: CURSOR C1 IS select 'x'
3561: from aso_lookups
3562: where lookup_type = 'ASO_QUOTE_OBJECT_TYPE'
3563: and lookup_code = p_QUOTE_OBJECT_TYPE_CODE;
3564: l_exist VARCHAR2(1);
3565: BEGIN

Line 3606: from aso_lookups

3602: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3603: )
3604: IS
3605: CURSOR C1 IS select 'x'
3606: from aso_lookups
3607: where lookup_type = 'ASO_RELATED_OBJECT_TYPE'
3608: and lookup_code = p_OBJECT_TYPE_CODE;
3609:
3610: l_exist VARCHAR2(1);

Line 3653: from aso_lookups

3649: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3650: )
3651: IS
3652: CURSOR C1 IS SELECT 'x'
3653: from aso_lookups
3654: where lookup_type = 'ASO_OBJECT_RELATIONSHIP_TYPE'
3655: and lookup_code = p_RELATIONSHIP_TYPE_CODE;
3656:
3657: l_exist VARCHAR2(1);

Line 5691: from ASO_LOOKUPS

5687: CURSOR C_PAYMENT_TYPE(p_lookup_code varchar2) is --Payment Type
5688: SELECT 1 FROM DUAL WHERE exists
5689: (
5690: SELECT Lookup_Code Payment_Type_Code
5691: from ASO_LOOKUPS
5692: WHERE LOOKUP_TYPE = 'ASO_PAYMENT_TYPE'
5693: and lookup_code <> 'PO'
5694: and trunc(nvl(start_date_active,sysdate)) <= trunc(sysdate)
5695: and trunc(nvl(end_daTe_active,sysdate)) >= trunc (sysdate)

Line 5758: from aso_lookups

5754: CURSOR C_AUTOMATIC_PRICING(p_lookup_code varchar2) IS --Auotmatic Pricing
5755: SELECT 1 FROM DUAL WHERE exists
5756: (
5757: select lookup_code
5758: from aso_lookups
5759: where lookup_type='ASO_PRICE_TAX_COMPUTE_OPTION'
5760: and lookup_code = p_lookup_code
5761: and ENABLED_FLAG = 'Y'
5762: and trunc(sysdate) between trunc(start_date_active)

Line 5772: from aso_lookups

5768: CURSOR C_AUTOMATIC_TAX(p_lookup_code varchar2) IS --Auotmatic Tax
5769: SELECT 1 FROM DUAL WHERE exists
5770: (
5771: select lookup_code
5772: from aso_lookups
5773: where lookup_type='ASO_PRICE_TAX_COMPUTE_OPTION'
5774: and lookup_code = p_lookup_code
5775: and ENABLED_FLAG = 'Y'
5776: and trunc(sysdate) between trunc(start_date_active)