eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FI_ARCHIVE_UMFR dependencies on FF_DATABASE_ITEMS

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 1303: csr_v_balance_name ff_database_items.user_name%TYPE

1299:
1300: lr_person_details csr_person_details%ROWTYPE;
1301:
1302: CURSOR csr_get_defined_balance_id (
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

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