825: cp_tax_unit_id in number,
826: cp_state_code in varchar2) is
827: select fdi.user_name,fai.value
828: from ff_database_items fdi,
829: ff_archive_items fai,
830: ff_archive_item_contexts fac,
831: ff_archive_item_contexts fac1,
832: ff_contexts fc,
833: ff_contexts fc1
847: cursor c_archive_dtls_fed(cp_asg_act_id in number,
848: cp_tax_unit_id in number) is
849: select fdi.user_name,fai.value
850: from ff_database_items fdi,
851: ff_archive_items fai,
852: ff_archive_item_contexts fac,
853: ff_contexts fc
854: where fai.user_entity_id = fdi.user_entity_id
855: and fai.context1 = to_char(cp_asg_act_id)
868: cursor c_get_asg_details(p_asg_action_id in number,
869: p_asg_id in number) is
870: select fdi.user_name,fai.value
871: from ff_database_items fdi,
872: ff_archive_items fai,
873: ff_archive_item_contexts fac,
874: ff_contexts fc
875: where fai.user_entity_id = fdi.user_entity_id
876: and fai.context1 = to_char(p_asg_action_id)