APPS.PAY_ARCHIVE dependencies on FF_CONTEXTS

Line 247: ff_contexts con

243: CURSOR contexts_csr (p_user_entity_id VARCHAR2) IS
244: SELECT con.context_name name
245: FROM ff_user_entities ue,
246: ff_route_context_usages rcu,
247: ff_contexts con
248: WHERE ue.user_entity_id = p_user_entity_id AND
249: ue.route_id = rcu.route_id AND
250: con.context_id = rcu.context_id ;
251: --

Line 668: v_context_id ff_contexts.context_id%TYPE;

664: balance_ptr number;
665: context_ptr number;
666: l_level number;
667: v_context_value ff_archive_item_contexts.context%TYPE;
668: v_context_id ff_contexts.context_id%TYPE;
669: result ff_archive_items.value%TYPE;
670: begin
671: --
672: hr_utility.set_location ('archive_dbi',1);

Line 812: from ff_contexts

808: v_context_value
809: := pay_balance_pkg.get_context(l_contexts_dbi.name(i));
810: --
811: select context_id into v_context_id
812: from ff_contexts
813: where context_name= l_contexts_dbi.name(i);
814: --
815: --
816: insert into ff_archive_item_contexts

Line 876: v_context_id ff_contexts.context_id%TYPE;

872: ass_ptr number;
873: context_ptr number;
874: l_level number;
875: v_context_value ff_archive_item_contexts.context%TYPE;
876: v_context_id ff_contexts.context_id%TYPE;
877: result ff_archive_items.value%TYPE;
878: --
879: begin
880: --

Line 1007: from ff_contexts

1003: v_context_value:=
1004: pay_balance_pkg.get_context(l_contexts_dbi.name(i));
1005: --
1006: select context_id into v_context_id
1007: from ff_contexts
1008: where context_name=l_contexts_dbi.name(i);
1009: --
1010: --
1011: insert into ff_archive_item_contexts