APPS.PAY_MAGTAPE_EXTRACT dependencies on FF_CONTEXTS

Line 265: ff_contexts cx

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;
269: --

Line 984: FROM ff_contexts con,

980: -- Delete archive items
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

Line 998: FROM ff_contexts con,

994: AND rcu.sequence_no = 1
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

Line 1014: FROM ff_contexts con,

1010: hr_utility.set_location ('arch_rolbk',2);
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

Line 1026: FROM ff_contexts con,

1022: AND rcu.sequence_no = 1
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