DBA Data[Home] [Help]

APPS.PAY_US_W2C_RPT dependencies on FF_ARCHIVE_ITEMS

Line 1590: ff_archive_items fai,

1586:
1587: select fai.value
1588: into lv_ein
1589: from ff_database_items fdi,
1590: ff_archive_items fai,
1591: ff_archive_item_contexts fac,
1592: ff_archive_item_contexts fac1
1593: where fai.user_entity_id = fdi.user_entity_id
1594: and fai.context1 = to_char(ln_eoy_pactid)

Line 2121: ff_archive_items fai

2117: and l_local_tab(l_local_total_count).tax_type_c = 'COUNTY') THEN
2118: BEGIN
2119: select nvl(value,'N') into l_nr_flag
2120: from ff_database_items fdi,
2121: ff_archive_items fai
2122: where user_name = 'A_IN_NR_FLAG'
2123: and fdi.user_entity_id = fai.user_entity_id
2124: and fai.context1 = p_asg_action_id;
2125:

Line 2130: ff_archive_items fai

2126: IF l_nr_flag = 'N' THEN
2127: BEGIN
2128: select nvl(value,'00-000-0000') into l_nr_jd
2129: from ff_database_items fdi,
2130: ff_archive_items fai
2131: where fdi.user_name = 'A_IN_RES_JD'
2132: and fdi.user_entity_id = fai.user_entity_id
2133: and context1 = p_asg_action_id;
2134: