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_AE_SI_REPORTS dependencies on FF_USER_ENTITIES

Line 316: FROM ff_user_entities u,

312:
313: /*Cursor for fetching defined balance id for subject_to_social_asg_run*/
314: CURSOR csr_get_def_id(p_user_name VARCHAR2) IS
315: SELECT u.creator_id
316: FROM ff_user_entities u,
317: ff_database_items d
318: WHERE d.user_name = p_user_name
319: AND u.user_entity_id = d.user_entity_id
320: AND u.legislation_code = 'AE'

Line 1382: FROM ff_user_entities u,

1378:
1379: /*Cursor for fetching defined balance id*/
1380: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS
1381: SELECT u.creator_id
1382: FROM ff_user_entities u,
1383: ff_database_items d
1384: WHERE d.user_name = p_user_name
1385: AND u.user_entity_id = d.user_entity_id
1386: AND u.legislation_code = 'AE'

Line 2151: FROM ff_user_entities u,

2147:
2148: /* Cursor for fetching Subject to SI defined balance ID */
2149: CURSOR csr_get_si_id(p_user_name VARCHAR2) IS
2150: SELECT u.creator_id
2151: FROM ff_user_entities u,
2152: ff_database_items d
2153: WHERE d.user_name = p_user_name
2154: AND u.user_entity_id = d.user_entity_id
2155: AND u.legislation_code = 'AE'

Line 2755: FROM ff_user_entities u,

2751:
2752: /*Cursor for fetching defined balance id*/
2753: CURSOR csr_get_si_id(p_user_name VARCHAR2) IS
2754: SELECT u.creator_id
2755: FROM ff_user_entities u,
2756: ff_database_items d
2757: WHERE d.user_name = p_user_name
2758: AND u.user_entity_id = d.user_entity_id
2759: AND u.legislation_code = 'AE'

Line 3854: FROM ff_user_entities u,ff_database_items d

3850:
3851: /* Cursor for fetching Defined balance ids for UAE balances */
3852: CURSOR csr_get_seeded_def_bal_ids (l_user_name varchar2) IS
3853: SELECT u.creator_id
3854: FROM ff_user_entities u,ff_database_items d
3855: WHERE d.user_name = l_user_name
3856: AND u.user_entity_id = d.user_entity_id
3857: AND u.legislation_code = 'AE'
3858: AND u.business_group_id is null

Line 4624: FROM ff_user_entities u,

4620:
4621: /* Cursor to retrieve Defined Balance Id */
4622: CURSOR csr_def_bal_id(p_user_name VARCHAR2) IS
4623: SELECT u.creator_id
4624: FROM ff_user_entities u,
4625: ff_database_items d
4626: WHERE d.user_name = p_user_name
4627: AND u.user_entity_id = d.user_entity_id
4628: AND (u.legislation_code = 'AE' )