APPS.PAY_MAGTAPE_EXTRACT dependencies on FF_USER_ENTITIES

Line 263: FROM ff_user_entities ue,

259: us.usage = 'D';
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

Line 275: creator_type ff_user_entities.creator_type%TYPE;

271: contexts_row contexts_csr%ROWTYPE;
272: user_entity_id ff_database_items.user_entity_id%TYPE;
273: a_user_entity_id ff_database_items.user_entity_id%TYPE;
274: a_data_type ff_database_items.data_type%TYPE;
275: creator_type ff_user_entities.creator_type%TYPE;
276: name VARCHAR2(240);
277: flag VARCHAR2(1);
278: BEGIN
279: hr_utility.set_location ('arch_db_items_loop',1);

Line 317: ff_user_entities ue

313: --------------------------------------------------------------------------------
314: SELECT dbi.user_entity_id,ue.creator_type
315: INTO user_entity_id,creator_type
316: FROM ff_database_items dbi,
317: ff_user_entities ue
318: WHERE dbi.user_name = name AND
319: dbi.user_entity_id = ue.user_entity_id;
320: --
321: --------------------------------------------------------------------------------

Line 986: ff_user_entities ue,

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
990: AND assact.payroll_action_id = p_payroll_action_id

Line 1000: ff_user_entities ue,

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
1004: AND i.user_entity_id = ue.user_entity_id

Line 1016: ff_user_entities ue,

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
1020: AND i.user_entity_id = ue.user_entity_id

Line 1028: ff_user_entities ue

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