APPS.AMS_GEN_APPROVAL_PVT dependencies on AMS_OBJECT_RULES_B

Line 303: FROM ams_object_rules_b

299: l_rule_name VARCHAR2(240);
300:
301: CURSOR c_API_Name(id_in IN VARCHAR2) is
302: SELECT package_name, procedure_name
303: FROM ams_object_rules_b
304: WHERE OBJECT_RULE_ID = id_in;
305:
306: BEGIN
307: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1390: FROM ams_object_rules_b

1386: AND TRUNC(NVL(end_date_active,SYSDATE + 1));
1387:
1388: CURSOR c_API_Name(rule_id_in IN NUMBER) is
1389: SELECT package_name, procedure_name
1390: FROM ams_object_rules_b
1391: WHERE OBJECT_RULE_ID = rule_id_in;
1392:
1393: BEGIN
1394: FND_MSG_PUB.initialize();

Line 2106: FROM ams_object_rules_b

2102: rule_used_by_type_in IN VARCHAR2,
2103: rule_type_in IN VARCHAR2,
2104: appr_type_in IN VARCHAR2) is
2105: SELECT package_name, procedure_name
2106: FROM ams_object_rules_b
2107: WHERE rule_used_by = rule_used_by_in
2108: AND rule_used_by_type = rule_used_by_type_in
2109: AND rule_type = rule_type_in
2110: AND nvl(APPROVAL_TYPE, 'NIL') = nvl(appr_type_in, 'NIL');