APPS.PAY_FI_ARCHIVE_UMFR dependencies on FF_USER_ENTITIES

Line 1127: FROM ff_user_entities u, ff_database_items d

1123: /* Cursor to retrieve Defined Balance Id */
1124: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
1125: IS
1126: SELECT u.creator_id
1127: FROM ff_user_entities u, ff_database_items d
1128: WHERE d.user_name = p_user_name
1129: AND u.user_entity_id = d.user_entity_id
1130: AND (u.legislation_code = 'FI')
1131: AND (u.business_group_id IS NULL)

Line 1134: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;

1130: AND (u.legislation_code = 'FI')
1131: AND (u.business_group_id IS NULL)
1132: AND u.creator_type = 'B';
1133:
1134: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
1135: BEGIN
1136: IF g_debug
1137: THEN
1138: hr_utility.set_location (

Line 1307: FROM ff_user_entities ue, ff_database_items di

1303: csr_v_balance_name ff_database_items.user_name%TYPE
1304: )
1305: IS
1306: SELECT ue.creator_id
1307: FROM ff_user_entities ue, ff_database_items di
1308: WHERE di.user_name = csr_v_balance_name
1309: AND ue.user_entity_id = di.user_entity_id
1310: AND ue.legislation_code = 'FI'
1311: AND ue.business_group_id IS NULL