APPS.PAY_AE_SI_REPORTS dependencies on FF_DATABASE_ITEMS

Line 317: ff_database_items d

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'
321: AND u.business_group_id is null

Line 1383: ff_database_items d

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'
1387: AND u.business_group_id is null

Line 2152: ff_database_items d

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'
2156: AND u.business_group_id is null

Line 2756: ff_database_items d

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'
2760: AND u.business_group_id is null

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 4625: ff_database_items d

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' )
4629: AND (u.business_group_id IS NULL )