APPS.PAY_FI_ARCHIVE_PYSA dependencies on FF_USER_ENTITIES

Line 1206: FROM ff_user_entities u,

1202: IS
1203: /* Cursor to retrieve Defined Balance Id */
1204: CURSOR csr_def_bal_id(p_user_name VARCHAR2) IS
1205: SELECT u.creator_id
1206: FROM ff_user_entities u,
1207: ff_database_items d
1208: WHERE d.user_name = p_user_name
1209: AND u.user_entity_id = d.user_entity_id
1210: AND (u.legislation_code = 'FI' )

Line 1213: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;

1209: AND u.user_entity_id = d.user_entity_id
1210: AND (u.legislation_code = 'FI' )
1211: AND (u.business_group_id IS NULL )
1212: AND u.creator_type = 'B';
1213: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
1214: BEGIN
1215: IF g_debug THEN
1216: hr_utility.set_location(' Entering Function GET_DEFINED_BALANCE_ID',240);
1217: END IF;