DBA Data[Home] [Help]

APPS.PAY_US_W2_INFO_PKG dependencies on FF_DATABASE_ITEMS

Line 1004: from ff_database_items fdi,

1000: IF (l_local_tab(l_local_total_count).state_code = 'IN'
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;

Line 1013: from ff_database_items fdi,

1009:
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;