APPS.PAY_US_ADHOC_UTILS dependencies on FF_ARCHIVE_ITEMS

Line 77: ff_archive_items fai

73: if (p_state_abbrev = 'IN' and p_tax_type = 'COUNTY') then
74: begin
75: select nvl(value,'N') into v_nr_flag
76: from ff_database_items fdi,
77: ff_archive_items fai
78: where user_name = 'A_IN_NR_FLAG'
79: and fdi.user_entity_id = fai.user_entity_id
80: and fai.context1 = p_assig_action_id;
81:

Line 86: ff_archive_items fai

82: if v_nr_flag = 'N' then
83: begin
84: select nvl(value,'00-000-0000') into v_nr_jd
85: from ff_database_items fdi,
86: ff_archive_items fai
87: where fdi.user_name = 'A_IN_RES_JD'
88: and fdi.user_entity_id = fai.user_entity_id
89: and context1 = p_assig_action_id;
90: