APPS.PAY_MAGTAPE_EXTRACT dependencies on FF_ROUTE_CONTEXT_USAGES

Line 264: ff_route_context_usages rcu,

260: --
261: CURSOR contexts_csr (p_user_entity_id VARCHAR2) IS
262: SELECT cx.context_name
263: FROM ff_user_entities ue,
264: ff_route_context_usages rcu,
265: ff_contexts cx
266: WHERE ue.user_entity_id = p_user_entity_id AND
267: ue.route_id = rcu.route_id AND
268: rcu.context_id = cx.context_id;

Line 985: ff_route_context_usages rcu,

981: --------------------------------------------------------------------------------
982: DELETE FROM ff_archive_item_contexts ic
983: WHERE EXISTS ( SELECT '1'
984: FROM ff_contexts con,
985: ff_route_context_usages rcu,
986: ff_user_entities ue,
987: pay_assignment_actions assact,
988: ff_archive_items i
989: WHERE i.archive_item_id = ic.archive_item_id

Line 999: ff_route_context_usages rcu,

995: AND rcu.context_id = con.context_id
996: AND con.context_name ||''= 'ASSIGNMENT_ACTION_ID' )
997: OR EXISTS ( SELECT '1'
998: FROM ff_contexts con,
999: ff_route_context_usages rcu,
1000: ff_user_entities ue,
1001: ff_archive_items i
1002: WHERE i.archive_item_id = ic.archive_item_id
1003: AND i.context1 = p_payroll_action_id

Line 1015: ff_route_context_usages rcu,

1011: --
1012: DELETE FROM ff_archive_items i
1013: WHERE EXISTS ( SELECT '1'
1014: FROM ff_contexts con,
1015: ff_route_context_usages rcu,
1016: ff_user_entities ue,
1017: pay_assignment_actions assact
1018: WHERE assact.payroll_action_id = p_payroll_action_id
1019: AND assact.assignment_action_id = i.context1

Line 1027: ff_route_context_usages rcu,

1023: AND rcu.context_id = con.context_id
1024: AND con.context_name ||''= 'ASSIGNMENT_ACTION_ID' )
1025: OR EXISTS ( SELECT '1'
1026: FROM ff_contexts con,
1027: ff_route_context_usages rcu,
1028: ff_user_entities ue
1029: WHERE i.context1 = p_payroll_action_id
1030: AND i.user_entity_id = ue.user_entity_id
1031: AND rcu.route_id = ue.route_id