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 360: FROM FF_ARCHIVE_ITEMS FAI1,

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

Line 459: from ff_archive_items fai,

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