APPS.PAY_KW_ANNUAL_REPORTS dependencies on FF_DATABASE_ITEMS

Line 98: ff_database_items d

94: /*Cursor for fetching defined balance id*/
95: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS
96: SELECT u.creator_id
97: FROM ff_user_entities u,
98: ff_database_items d
99: WHERE d.user_name = p_user_name
100: AND u.user_entity_id = d.user_entity_id
101: AND u.legislation_code = 'KW'
102: AND u.business_group_id is null

Line 724: ff_database_items d

720: /*Cursor for fetching defined balance id*/
721: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS
722: SELECT u.creator_id
723: FROM ff_user_entities u,
724: ff_database_items d
725: WHERE d.user_name = p_user_name
726: AND u.user_entity_id = d.user_entity_id
727: AND u.legislation_code = 'KW'
728: AND u.business_group_id is null

Line 1384: ff_database_items d

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