DBA Data[Home] [Help]

APPS.PAY_US_W2_INFO_PKG dependencies on FF_ARCHIVE_ITEMS

Line 1005: ff_archive_items fai

1001: and l_local_tab(l_local_total_count).tax_type = 'COUNTY') THEN
1002: BEGIN
1003: select nvl(value,'N') into l_nr_flag
1004: from ff_database_items fdi,
1005: ff_archive_items fai
1006: where user_name = 'A_IN_NR_FLAG'
1007: and fdi.user_entity_id = fai.user_entity_id
1008: and fai.context1 = p_asg_action_id;
1009:

Line 1014: ff_archive_items fai

1010: IF l_nr_flag = 'N' THEN
1011: BEGIN
1012: select nvl(value,'00-000-0000') into l_nr_jd
1013: from ff_database_items fdi,
1014: ff_archive_items fai
1015: where fdi.user_name = 'A_IN_RES_JD'
1016: and fdi.user_entity_id = fai.user_entity_id
1017: and context1 = p_asg_action_id;
1018: