APPS.PAY_NL_TAXOFFICE_ARCHIVE dependencies on FF_USER_ENTITIES

Line 3503: FROM ff_user_entities u,

3499: FUNCTION get_User_Defined_Balance_Id (p_user_name IN VARCHAR2, p_bg_id IN NUMBER) RETURN NUMBER IS
3500: /* Cursor to retrieve User Defined Balance Id */
3501: CURSOR csr_def_bal_id(p_user_name VARCHAR2) IS
3502: SELECT u.creator_id
3503: FROM ff_user_entities u,
3504: ff_database_items d
3505: WHERE d.user_name = p_user_name
3506: AND u.user_entity_id = d.user_entity_id
3507: AND (u.legislation_code is NULL )

Line 3511: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;

3507: AND (u.legislation_code is NULL )
3508: AND (u.business_group_id = p_bg_id )
3509: AND u.creator_type = 'B';
3510:
3511: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
3512:
3513: BEGIN
3514: OPEN csr_def_bal_id(p_user_name);
3515: FETCH csr_def_bal_id INTO l_defined_balance_id;