APPS.PAY_CA_RL1_REG dependencies on FF_DATABASE_ITEMS

Line 138: from ff_database_items

134: declare
135:
136: cursor cur_user_entity_id is
137: select user_entity_id
138: from ff_database_items
139: where user_name = p_user_name;
140:
141: l_user_entity_id ff_database_items.user_entity_id%TYPE;
142:

Line 141: l_user_entity_id ff_database_items.user_entity_id%TYPE;

137: select user_entity_id
138: from ff_database_items
139: where user_name = p_user_name;
140:
141: l_user_entity_id ff_database_items.user_entity_id%TYPE;
142:
143: begin
144:
145: open cur_user_entity_id;

Line 175: ff_database_items fdi1,

171:
172: sqlstr := 'select distinct to_number(fai3.value)
173: from ff_archive_items fai1,
174: ff_archive_items fai2,
175: ff_database_items fdi1,
176: ff_database_items fdi2,
177: ff_archive_items fai3,
178: ff_database_items fdi3,
179: pay_payroll_actions ppa,

Line 176: ff_database_items fdi2,

172: sqlstr := 'select distinct to_number(fai3.value)
173: from ff_archive_items fai1,
174: ff_archive_items fai2,
175: ff_database_items fdi1,
176: ff_database_items fdi2,
177: ff_archive_items fai3,
178: ff_database_items fdi3,
179: pay_payroll_actions ppa,
180: pay_assignment_actions paa

Line 178: ff_database_items fdi3,

174: ff_archive_items fai2,
175: ff_database_items fdi1,
176: ff_database_items fdi2,
177: ff_archive_items fai3,
178: ff_database_items fdi3,
179: pay_payroll_actions ppa,
180: pay_assignment_actions paa
181: where ppa.payroll_action_id = :payroll_action_id
182: and fai1.user_entity_id = fdi1.user_entity_id