APPS.PAY_KW_ANNUAL_REPORTS dependencies on FF_DATABASE_ITEMS

Line 83: ff_database_items d

79: /*Cursor for fetching defined balance id*/
80: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS
81: SELECT u.creator_id
82: FROM ff_user_entities u,
83: ff_database_items d
84: WHERE d.user_name = p_user_name
85: AND u.user_entity_id = d.user_entity_id
86: AND u.legislation_code = 'KW'
87: AND u.business_group_id is null

Line 666: ff_database_items d

662: /*Cursor for fetching defined balance id*/
663: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS
664: SELECT u.creator_id
665: FROM ff_user_entities u,
666: ff_database_items d
667: WHERE d.user_name = p_user_name
668: AND u.user_entity_id = d.user_entity_id
669: AND u.legislation_code = 'KW'
670: AND u.business_group_id is null

Line 1326: ff_database_items d

1322: /*Cursor for fetching defined balance id*/
1323: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS
1324: SELECT u.creator_id
1325: FROM ff_user_entities u,
1326: ff_database_items d
1327: WHERE d.user_name = p_user_name
1328: AND u.user_entity_id = d.user_entity_id
1329: AND u.legislation_code = 'KW'
1330: AND u.business_group_id is null