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 665: from ff_archive_items fai,

661: RETURN varchar2 IS
662:
663: cursor cur_archive (b_context_id NUMBER, b_user_name VARCHAR2) is
664: select fai.value
665: from ff_archive_items fai,
666: ff_database_items fdi
667: where fai.user_entity_id = fdi.user_entity_id
668: and fai.context1 = b_context_id
669: and fdi.user_name = b_user_name;