APPS.PAY_CA_T4_MAG dependencies on FF_ARCHIVE_ITEMS

Line 94: from ff_archive_items fai1,

90:
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,

Line 96: ff_archive_items fai2,

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,
100: pay_payroll_actions ppa1

Line 325: FROM FF_ARCHIVE_ITEMS FAI1,

321:
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

Line 399: from ff_archive_items fai,

395: RETURN varchar2 IS
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;