APPS.PAY_CA_T4A_AMEND_MAG dependencies on FF_ARCHIVE_ITEMS

Line 34: FROM ff_archive_items fai1,

30: WHERE user_name='CAEOY_PERSON_ID';
31:
32:
33: p_sqlstr := 'SELECT DISTINCT to_number(fai1.value)
34: FROM ff_archive_items fai1,
35: ff_archive_items fai2,
36: pay_assignment_actions paa,
37: pay_payroll_actions ppa,
38: pay_payroll_actions ppa1

Line 35: ff_archive_items fai2,

31:
32:
33: p_sqlstr := 'SELECT DISTINCT to_number(fai1.value)
34: FROM ff_archive_items fai1,
35: ff_archive_items fai2,
36: pay_assignment_actions paa,
37: pay_payroll_actions ppa,
38: pay_payroll_actions ppa1
39: WHERE ppa1.payroll_action_id = :p_pactid

Line 161: FROM ff_archive_items

157: -----
158: CURSOR c_get_fed_amend_flag(cp_asg_act_id IN NUMBER
159: ,cp_uid_t4amend_flag IN NUMBER) IS
160: SELECT value
161: FROM ff_archive_items
162: WHERE context1 = cp_asg_act_id
163: AND user_entity_id = cp_uid_t4amend_flag;
164: -----
165: CURSOR c_get_ue_id(cp_user_name IN VARCHAR2) IS

Line 546: FROM ff_archive_items fai,

542:
543: CURSOR cur_archive (b_context_id IN NUMBER,
544: b_user_name VARCHAR2) IS
545: SELECT fai.value
546: FROM ff_archive_items fai,
547: ff_database_items fdi
548: WHERE fai.user_entity_id = fdi.user_entity_id
549: AND fai.context1 = b_context_id
550: AND fdi.user_name = b_user_name;

Line 742: l_context1 ff_archive_items.context1%TYPE;

738: BEGIN
739: DECLARE
740:
741: l_final_xml VARCHAR2(32000);
742: l_context1 ff_archive_items.context1%TYPE;
743: EOL VARCHAR2(5) := fnd_global.local_chr(13)
744: || fnd_global.local_chr(10);
745: l_return VARCHAR2(240);
746: l_status BOOLEAN := TRUE;

Line 997: l_context1 ff_archive_items.context1%TYPE;

993: PROCEDURE t4a_amend_employer_record is
994: BEGIN
995: DECLARE
996: l_final_xml_string VARCHAR2(32000);
997: l_context1 ff_archive_items.context1%TYPE;
998: l_return VARCHAR2(240);
999: EOL varchar2(5) := fnd_global.local_chr(13) || fnd_global.local_chr(10);
1000: l_transfer_pact_id VARCHAR2(15);
1001: l_transfer_tax_unit_id VARCHAR2(10);