APPS.PAY_CA_T4A_MAG dependencies on FF_ARCHIVE_ITEMS

Line 128: from ff_archive_items fai1,

124: whether GRE has the 'Fed Magnetic Reporting' information or not */
125:
126: /* Changed to fix performance bug */
127: p_sqlstr := 'select distinct to_number(fai1.value)
128: from ff_archive_items fai1,
129: ff_archive_items fai2,
130: pay_assignment_actions paa,
131: pay_payroll_actions ppa,
132: pay_payroll_actions ppa1

Line 129: ff_archive_items fai2,

125:
126: /* Changed to fix performance bug */
127: p_sqlstr := 'select distinct to_number(fai1.value)
128: from ff_archive_items fai1,
129: ff_archive_items fai2,
130: pay_assignment_actions paa,
131: pay_payroll_actions ppa,
132: pay_payroll_actions ppa1
133: where ppa1.payroll_action_id = :p_pactid

Line 675: ff_archive_items fai

671:
672: cursor c_get_dbitem_value(cp_dbitem varchar2) is
673: select fai.value
674: from ff_database_items fdi,
675: ff_archive_items fai
676: where fai.user_entity_id=fdi.user_entity_id
677: and fai.context1= p_asg_act_id
678: and fdi.user_name = cp_dbitem;
679:

Line 1282: from ff_archive_items fai,

1278: RETURN varchar2 IS
1279:
1280: cursor cur_archive (b_context_id NUMBER, b_user_name VARCHAR2) is
1281: select fai.value
1282: from ff_archive_items fai,
1283: ff_database_items fdi
1284: where fai.user_entity_id = fdi.user_entity_id
1285: and fai.context1 = b_context_id
1286: and fdi.user_name = b_user_name;