DBA Data[Home] [Help]

APPS.PAY_US_W2_INFO_PKG dependencies on FF_ARCHIVE_ITEMS

Line 932: ff_archive_items fai

928: and l_local_tab(l_local_total_count).tax_type = 'COUNTY') THEN
929: BEGIN
930: select nvl(value,'N') into l_nr_flag
931: from ff_database_items fdi,
932: ff_archive_items fai
933: where user_name = 'A_IN_NR_FLAG'
934: and fdi.user_entity_id = fai.user_entity_id
935: and fai.context1 = p_asg_action_id;
936:

Line 941: ff_archive_items fai

937: IF l_nr_flag = 'N' THEN
938: BEGIN
939: select nvl(value,'00-000-0000') into l_nr_jd
940: from ff_database_items fdi,
941: ff_archive_items fai
942: where fdi.user_name = 'A_IN_RES_JD'
943: and fdi.user_entity_id = fai.user_entity_id
944: and context1 = p_asg_action_id;
945: