APPS.PAY_SE_WAGES_SALARIES dependencies on FF_USER_ENTITIES

Line 470: FROM ff_user_entities ue,

466:
467: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
468: IS
469: SELECT ue.creator_id
470: FROM ff_user_entities ue,
471: ff_database_items di
472: WHERE di.user_name = csr_v_Balance_Name
473: AND ue.user_entity_id = di.user_entity_id
474: AND ue.legislation_code = 'SE'

Line 1008: FROM ff_user_entities ue,

1004:
1005: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
1006: IS
1007: SELECT ue.creator_id
1008: FROM ff_user_entities ue,
1009: ff_database_items di
1010: WHERE di.user_name = csr_v_Balance_Name
1011: AND ue.user_entity_id = di.user_entity_id
1012: AND ue.legislation_code = 'SE'

Line 3346: FROM ff_user_entities u, ff_database_items d

3342: /* Cursor to retrieve Defined Balance Id */
3343: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
3344: IS
3345: SELECT u.creator_id
3346: FROM ff_user_entities u, ff_database_items d
3347: WHERE d.user_name = p_user_name
3348: AND u.user_entity_id = d.user_entity_id
3349: AND (u.legislation_code = 'SE')
3350: AND (u.business_group_id IS NULL)

Line 3353: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;

3349: AND (u.legislation_code = 'SE')
3350: AND (u.business_group_id IS NULL)
3351: AND u.creator_type = 'B';
3352:
3353: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
3354: BEGIN
3355: IF g_debug
3356: THEN
3357: hr_utility.set_location

Line 3391: FROM ff_user_entities u, ff_database_items d

3387: /* Cursor to retrieve Defined Balance Id */
3388: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
3389: IS
3390: SELECT u.creator_id
3391: FROM ff_user_entities u, ff_database_items d
3392: WHERE d.user_name = p_user_name
3393: AND u.user_entity_id = d.user_entity_id
3394: AND (u.legislation_code = 'SE')
3395: AND (u.business_group_id IS NULL)

Line 3398: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;

3394: AND (u.legislation_code = 'SE')
3395: AND (u.business_group_id IS NULL)
3396: AND u.creator_type = 'B';
3397:
3398: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
3399: l_return_balance_value NUMBER;
3400: BEGIN
3401: IF g_debug
3402: THEN