APPS.AMW_ASSERTIONS_PKG dependencies on AMW_ACCOUNT_ASSERTIONS

Line 20: from amw_account_assertions

16: n number;
17: BEGIN
18: select count(*)
19: into n
20: from amw_account_assertions
21: where natural_account_id = p_natural_account_id
22: and assertion_code = p_assertion_code;
23:
24: if n > 0 then

Line 50: from amw_account_assertions

46: no varchar2(80);
47: BEGIN
48: select count(*)
49: into n
50: from amw_account_assertions
51: where natural_account_id = p_natural_account_id
52: and assertion_code = p_assertion_code;
53:
54: select meaning

Line 98: delete from amw_account_assertions

94: l_account_assertion_id number;
95: l_object_version_number number;
96:
97: BEGIN
98: delete from amw_account_assertions
99: where natural_account_id = p_natural_account_id
100: and assertion_code = p_assertion_code;
101:
102: if (p_select_flag = 'Y') then

Line 113: insert into amw_account_assertions (account_assertion_id,

109: l_object_version_number := 1;
110:
111: select amw_account_assertion_s.nextval into l_account_assertion_id from dual;
112:
113: insert into amw_account_assertions (account_assertion_id,
114: natural_account_id,
115: assertion_code,
116: creation_date,
117: created_by,