893: cp_state_code in varchar2) is
894: select fdi.user_name,fai.value
895: from ff_database_items fdi,
896: ff_archive_items fai,
897: ff_archive_item_contexts fac,
898: ff_archive_item_contexts fac1,
899: ff_contexts fc,
900: ff_contexts fc1
901: where fai.user_entity_id = fdi.user_entity_id
894: select fdi.user_name,fai.value
895: from ff_database_items fdi,
896: ff_archive_items fai,
897: ff_archive_item_contexts fac,
898: ff_archive_item_contexts fac1,
899: ff_contexts fc,
900: ff_contexts fc1
901: where fai.user_entity_id = fdi.user_entity_id
902: and fai.context1 = to_char(cp_asg_act_id)
915: cp_tax_unit_id in number) is
916: select fdi.user_name,fai.value
917: from ff_database_items fdi,
918: ff_archive_items fai,
919: ff_archive_item_contexts fac,
920: ff_contexts fc
921: where fai.user_entity_id = fdi.user_entity_id
922: and fai.context1 = to_char(cp_asg_act_id)
923: /* context assignment action id */
936: p_asg_id in number) is
937: select fdi.user_name,fai.value
938: from ff_database_items fdi,
939: ff_archive_items fai,
940: ff_archive_item_contexts fac,
941: ff_contexts fc
942: where fai.user_entity_id = fdi.user_entity_id
943: and fai.context1 = to_char(p_asg_action_id)
944: /* context assignment action id */