APPS.CN_SCA_CREDITS_ONLINE_PUB dependencies on CN_SCA_CREDIT_RULES

Line 24: l_win_rule_id cn_sca_credit_rules.SCA_CREDIT_RULE_ID%TYPE;

20: x_msg_count OUT NOCOPY number,
21: x_msg_data OUT NOCOPY varchar2)IS
22: l_api_name CONSTANT VARCHAR2(30) := 'get_sales_credits';
23: l_api_version CONSTANT NUMBER :=1.0;
24: l_win_rule_id cn_sca_credit_rules.SCA_CREDIT_RULE_ID%TYPE;
25: l_package_name VARCHAR2(100);
26: l_stmt VARCHAR2(4000);
27: l_org_id NUMBER := NULL;
28: l_found_rule_flag VARCHAR2(1);

Line 42: IS TABLE OF cn_sca_credit_rules.sca_credit_rule_id%type;

38: TYPE interface_id_tbl_type
39: IS TABLE OF cn_sca_headers_interface.sca_headers_interface_id%type;
40:
41: TYPE credit_rule_id_tbl_type
42: IS TABLE OF cn_sca_credit_rules.sca_credit_rule_id%type;
43:
44: TYPE process_status_tbl_type
45: IS TABLE OF cn_sca_headers_interface.process_status%type;
46: