APPS.OZF_CLAIM_SETTLEMENT_PVT dependencies on AMS_CUSTOM_SETUP_ATTR

Line 977: FROM ams_custom_setup_attr

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

Line 2197: FROM ams_custom_setup_attr

2193: )
2194: IS
2195: CURSOR csr_check_approval_require(cv_custom_setup_id IN NUMBER) IS
2196: SELECT NVL(attr_available_flag, 'N')
2197: FROM ams_custom_setup_attr
2198: WHERE custom_setup_id = cv_custom_setup_id
2199: AND object_attribute = 'APPR';
2200:
2201: l_approval_require VARCHAR2(1) := 'Y'; --//Bugfix : 8479176 , Changed from T to Y