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 361: ff_database_items fdi1,

357: cursor c_get_dbitem_value(cp_dbitem varchar2,
358: cp_jurisdiction varchar2) is
359: SELECT fai1.value
360: FROM FF_ARCHIVE_ITEMS FAI1,
361: ff_database_items fdi1,
362: ff_archive_item_contexts faic,
363: ff_contexts fc
364: WHERE FAI1.USER_ENTITY_ID = fdi1.user_entity_id
365: and fdi1.user_name = cp_dbitem

Line 460: ff_database_items fdi

456:
457: cursor cur_archive (b_context_id NUMBER, b_user_name VARCHAR2) is
458: select fai.value
459: from ff_archive_items fai,
460: ff_database_items fdi
461: where fai.user_entity_id = fdi.user_entity_id
462: and fai.context1 = b_context_id
463: and fdi.user_name = b_user_name;
464: