APPS.AMS_TCOP_UTIL_PKG dependencies on AMS_LIST_ENTRIES

Line 59: from ams_list_entries list1

55:
56: cursor c_get_null_party_map(p_list_header_id number)
57: is
58: select list1.list_entry_id
59: from ams_list_entries list1
60: where list1.list_header_id = p_list_header_id
61: and exists
62: (
63: select list2.list_entry_id

Line 64: from ams_list_entries list2

60: where list1.list_header_id = p_list_header_id
61: and exists
62: (
63: select list2.list_entry_id
64: from ams_list_entries list2
65: where list1.list_entry_id=list2.list_entry_id
66: and list2.list_header_id = p_list_header_id
67: and list2.party_id is null
68: );

Line 73: from ams_list_entries list1

69:
70: cursor c_get_non_tca_map(p_list_header_id number)
71: is
72: select list1.list_entry_id
73: from ams_list_entries list1
74: where list1.list_header_id=p_list_header_id
75: and not exists
76: (
77: select list2.party_id

Line 78: from ams_list_entries list2

74: where list1.list_header_id=p_list_header_id
75: and not exists
76: (
77: select list2.party_id
78: from ams_list_entries list2
79: ,hz_parties hz
80: where list2.party_id=hz.party_id
81: and list2.list_header_id = p_list_header_id
82: and list2.list_entry_id=list1.list_entry_id

Line 110: -- Check whether party_id column in AMS_LIST_ENTRIES is null

106: close c_get_rule;
107:
108: if (l_rule_id is not null) then
109:
110: -- Check whether party_id column in AMS_LIST_ENTRIES is null
111: -- if party_id column is null then Fatigue Rule will not be applied
112: open c_get_null_party_map(l_list_header_id);
113: fetch c_get_null_party_map
114: into l_list_entry_id;

Line 120: -- Check whether party_id mapped in AMS_LIST_ENTRIES

116:
117: if (l_list_entry_id is not null) then
118: return 'N';
119: else
120: -- Check whether party_id mapped in AMS_LIST_ENTRIES
121: -- refer to HZ_PARTIES.PARTY_ID
122: -- if party_id columns is mapped to anything other than TCA Party Id
123: -- then fatigue rule will not be applicable.
124: open c_get_non_tca_map(l_list_header_id);