APPS.OZF_CLAIM_SETTLEMENT_PVT dependencies on AMS_CUSTOM_SETUP_ATTR

Line 975: FROM ams_custom_setup_attr

971: WHERE claim_id = cv_claim_id;
972:
973: CURSOR csr_claim_perf_appr_req(cv_custom_setup_id IN NUMBER) IS
974: SELECT NVL(attr_available_flag, 'N')
975: FROM ams_custom_setup_attr
976: WHERE custom_setup_id = cv_custom_setup_id
977: AND object_attribute = 'PAPR';
978:
979:

Line 2184: FROM ams_custom_setup_attr

2180: )
2181: IS
2182: CURSOR csr_check_approval_require(cv_custom_setup_id IN NUMBER) IS
2183: SELECT NVL(attr_available_flag, 'N')
2184: FROM ams_custom_setup_attr
2185: WHERE custom_setup_id = cv_custom_setup_id
2186: AND object_attribute = 'APPR';
2187:
2188: l_approval_require VARCHAR2(1) := 'T';