APPS.PAY_CA_T4_MAG dependencies on FF_DATABASE_ITEMS

Line 95: ff_database_items fdi1,

91: hr_utility.set_location( 'pay_ca_t4_mag.range_cursor', 20);
92:
93: p_sqlstr := 'select distinct to_number(fai1.value)
94: from ff_archive_items fai1,
95: ff_database_items fdi1,
96: ff_archive_items fai2,
97: ff_database_items fdi2,
98: pay_assignment_actions paa,
99: pay_payroll_actions ppa,

Line 97: ff_database_items fdi2,

93: p_sqlstr := 'select distinct to_number(fai1.value)
94: from ff_archive_items fai1,
95: ff_database_items fdi1,
96: ff_archive_items fai2,
97: ff_database_items fdi2,
98: pay_assignment_actions paa,
99: pay_payroll_actions ppa,
100: pay_payroll_actions ppa1
101: where ppa1.payroll_action_id = :payroll_action_id

Line 326: ff_database_items fdi1,

322: cursor c_get_dbitem_value(cp_dbitem varchar2,
323: cp_jurisdiction varchar2) is
324: SELECT fai1.value
325: FROM FF_ARCHIVE_ITEMS FAI1,
326: ff_database_items fdi1,
327: ff_archive_item_contexts faic,
328: ff_contexts fc
329: WHERE FAI1.USER_ENTITY_ID = fdi1.user_entity_id
330: and fdi1.user_name = cp_dbitem

Line 400: ff_database_items fdi

396:
397: cursor cur_archive (b_context_id NUMBER, b_user_name VARCHAR2) is
398: select fai.value
399: from ff_archive_items fai,
400: ff_database_items fdi
401: where fai.user_entity_id = fdi.user_entity_id
402: and fai.context1 = b_context_id
403: and fdi.user_name = b_user_name;
404: