eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_LO_UTILITY dependencies on HZ_PARTIES

Line 121: p_party_id hz_parties.party_id%type) return number is

117: end lesson_status_transition_valid;
118:
119:
120: function get_contact_id_for_party(
121: p_party_id hz_parties.party_id%type) return number is
122:
123: cursor contact(
124: p_party_id hz_parties.party_id%type) is
125: select acct_role.cust_account_role_id

Line 124: p_party_id hz_parties.party_id%type) is

120: function get_contact_id_for_party(
121: p_party_id hz_parties.party_id%type) return number is
122:
123: cursor contact(
124: p_party_id hz_parties.party_id%type) is
125: select acct_role.cust_account_role_id
126: from hz_cust_account_roles acct_role,
127: hz_relationships rel,
128: hz_cust_accounts role_acct

Line 134: rel.subject_table_name = 'HZ_PARTIES' and

130: acct_role.role_type = 'CONTACT' and
131: acct_role.cust_account_id = role_acct.cust_account_id and
132: role_acct.party_id = rel.object_id and
133: rel.subject_id = p_party_id and
134: rel.subject_table_name = 'HZ_PARTIES' and
135: rel.object_table_name = 'HZ_PARTIES';
136:
137: v_result hz_parties.party_id%type;
138: begin

Line 135: rel.object_table_name = 'HZ_PARTIES';

131: acct_role.cust_account_id = role_acct.cust_account_id and
132: role_acct.party_id = rel.object_id and
133: rel.subject_id = p_party_id and
134: rel.subject_table_name = 'HZ_PARTIES' and
135: rel.object_table_name = 'HZ_PARTIES';
136:
137: v_result hz_parties.party_id%type;
138: begin
139: open contact(p_party_id);

Line 137: v_result hz_parties.party_id%type;

133: rel.subject_id = p_party_id and
134: rel.subject_table_name = 'HZ_PARTIES' and
135: rel.object_table_name = 'HZ_PARTIES';
136:
137: v_result hz_parties.party_id%type;
138: begin
139: open contact(p_party_id);
140: fetch contact into v_result;
141: close contact;

Line 269: rel.subject_table_name = 'HZ_PARTIES' and

265: acct_role.role_type = 'CONTACT' and
266: acct_role.cust_account_id = role_acct.cust_account_id and
267: role_acct.party_id = rel.object_id and
268: rel.subject_id = p_party_id and
269: rel.subject_table_name = 'HZ_PARTIES' and
270: rel.object_table_name = 'HZ_PARTIES';
271:
272: cursor perf_lesson_status is
273: select per.lesson_status,

Line 270: rel.object_table_name = 'HZ_PARTIES';

266: acct_role.cust_account_id = role_acct.cust_account_id and
267: role_acct.party_id = rel.object_id and
268: rel.subject_id = p_party_id and
269: rel.subject_table_name = 'HZ_PARTIES' and
270: rel.object_table_name = 'HZ_PARTIES';
271:
272: cursor perf_lesson_status is
273: select per.lesson_status,
274: offe.learning_object_id

Line 424: rel.subject_table_name = 'HZ_PARTIES' and

420: acct_role.role_type = 'CONTACT' and
421: acct_role.cust_account_id = role_acct.cust_account_id and
422: role_acct.party_id = rel.object_id and
423: rel.subject_id = p_party_id and
424: rel.subject_table_name = 'HZ_PARTIES' and
425: rel.object_table_name = 'HZ_PARTIES';
426:
427: l_event_id OTA_EVENTS.EVENT_ID%TYPE:= null;
428: l_test_id OTA_TESTS.TEST_ID%type:=null;

Line 425: rel.object_table_name = 'HZ_PARTIES';

421: acct_role.cust_account_id = role_acct.cust_account_id and
422: role_acct.party_id = rel.object_id and
423: rel.subject_id = p_party_id and
424: rel.subject_table_name = 'HZ_PARTIES' and
425: rel.object_table_name = 'HZ_PARTIES';
426:
427: l_event_id OTA_EVENTS.EVENT_ID%TYPE:= null;
428: l_test_id OTA_TESTS.TEST_ID%type:=null;
429: Cursor csr_attempt_info is