APPS.PAY_NL_GENERAL dependencies on FF_USER_ENTITIES

Line 425: FROM ff_user_entities u,

421: IS
422: /* Cursor to retrieve Defined Balance Id */
423: CURSOR csr_def_bal_id(p_user_name VARCHAR2) IS
424: SELECT u.creator_id
425: FROM ff_user_entities u,
426: ff_database_items d
427: WHERE d.user_name = p_user_name
428: AND u.user_entity_id = d.user_entity_id
429: AND (u.legislation_code = 'NL' )

Line 433: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;

429: AND (u.legislation_code = 'NL' )
430: AND (u.business_group_id IS NULL )
431: AND u.creator_type = 'B';
432:
433: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
434:
435: BEGIN
436: OPEN csr_def_bal_id(p_user_name);
437: FETCH csr_def_bal_id INTO l_defined_balance_id;

Line 936: delete from ff_user_entities

932: --
933: -- delete user entities (and dbitems) owned by a user entity
934: -- for an old value of the S leg rule
935: --
936: delete from ff_user_entities
937: where creator_type = 'KF'
938: and creator_id <> p_id_flex_num
939: and user_entity_name like 'SCL%'
940: and nvl (legislation_code, ' ') = nvl (l_legislation_code, ' ')