APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on FF_USER_ENTITIES

Line 573: FROM ff_user_entities ue,

569: (csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE
570: ,p_business_group_id NUMBER)
571: IS
572: SELECT ue.creator_id
573: FROM ff_user_entities ue,
574: ff_database_items di
575: WHERE di.user_name = csr_v_Balance_Name
576: AND ue.user_entity_id = di.user_entity_id
577: AND ue.legislation_code is NULL

Line 2381: FROM ff_user_entities u

2377: /* Cursor to retrieve Defined Balance Id */
2378: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
2379: IS
2380: SELECT u.creator_id
2381: FROM ff_user_entities u
2382: ,ff_database_items d
2383: WHERE d.user_name = p_user_name
2384: AND u.user_entity_id = d.user_entity_id
2385: AND (u.legislation_code = 'SE')

Line 2389: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;

2385: AND (u.legislation_code = 'SE')
2386: AND (u.business_group_id IS NULL)
2387: AND u.creator_type = 'B';
2388:
2389: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
2390: BEGIN
2391: IF g_debug
2392: THEN
2393: hr_utility.set_location

Line 2429: FROM ff_user_entities u

2425: /* Cursor to retrieve Defined Balance Id */
2426: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
2427: IS
2428: SELECT u.creator_id
2429: FROM ff_user_entities u
2430: ,ff_database_items d
2431: WHERE d.user_name = p_user_name
2432: AND u.user_entity_id = d.user_entity_id
2433: AND (u.legislation_code = 'SE')

Line 2437: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;

2433: AND (u.legislation_code = 'SE')
2434: AND (u.business_group_id IS NULL)
2435: AND u.creator_type = 'B';
2436:
2437: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
2438: l_return_balance_value NUMBER;
2439: BEGIN
2440: IF g_debug
2441: THEN