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.PAY_CA_RL1_REG dependencies on FF_DATABASE_ITEMS

Line 154: from ff_database_items

150: declare
151:
152: cursor cur_user_entity_id is
153: select user_entity_id
154: from ff_database_items
155: where user_name = p_user_name;
156:
157: l_user_entity_id ff_database_items.user_entity_id%TYPE;
158:

Line 157: l_user_entity_id ff_database_items.user_entity_id%TYPE;

153: select user_entity_id
154: from ff_database_items
155: where user_name = p_user_name;
156:
157: l_user_entity_id ff_database_items.user_entity_id%TYPE;
158:
159: begin
160:
161: open cur_user_entity_id;

Line 191: ff_database_items fdi1,

187:
188: sqlstr := 'select distinct to_number(fai3.value)
189: from ff_archive_items fai1,
190: ff_archive_items fai2,
191: ff_database_items fdi1,
192: ff_database_items fdi2,
193: ff_archive_items fai3,
194: ff_database_items fdi3,
195: pay_payroll_actions ppa,

Line 192: ff_database_items fdi2,

188: sqlstr := 'select distinct to_number(fai3.value)
189: from ff_archive_items fai1,
190: ff_archive_items fai2,
191: ff_database_items fdi1,
192: ff_database_items fdi2,
193: ff_archive_items fai3,
194: ff_database_items fdi3,
195: pay_payroll_actions ppa,
196: pay_assignment_actions paa

Line 194: ff_database_items fdi3,

190: ff_archive_items fai2,
191: ff_database_items fdi1,
192: ff_database_items fdi2,
193: ff_archive_items fai3,
194: ff_database_items fdi3,
195: pay_payroll_actions ppa,
196: pay_assignment_actions paa
197: where ppa.payroll_action_id = :payroll_action_id
198: and fai1.user_entity_id = fdi1.user_entity_id