APPS.PAY_KW_MONTHLY_REPORTS dependencies on FF_DATABASE_ITEMS

Line 57: ff_database_items d

53: /*Cursor for fetching defined balance id*/
54: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS
55: SELECT u.creator_id
56: FROM ff_user_entities u,
57: ff_database_items d
58: WHERE d.user_name = p_user_name
59: AND u.user_entity_id = d.user_entity_id
60: AND u.legislation_code = 'KW'
61: AND u.business_group_id is null

Line 737: ff_database_items d

733: /*Cursor for fetching defined balance id*/
734: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS
735: SELECT u.creator_id
736: FROM ff_user_entities u,
737: ff_database_items d
738: WHERE d.user_name = p_user_name
739: AND u.user_entity_id = d.user_entity_id
740: AND u.legislation_code = 'KW'
741: AND u.business_group_id is null

Line 1146: ff_database_items d

1142: /*Cursor for fetching defined balance id*/
1143: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS
1144: SELECT u.creator_id
1145: FROM ff_user_entities u,
1146: ff_database_items d
1147: WHERE d.user_name = p_user_name
1148: AND u.user_entity_id = d.user_entity_id
1149: AND u.legislation_code = 'KW'
1150: AND u.business_group_id is null

Line 1787: ff_database_items d

1783: /*Cursor for fetching defined balance id*/
1784: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS
1785: SELECT u.creator_id
1786: FROM ff_user_entities u,
1787: ff_database_items d
1788: WHERE d.user_name = p_user_name
1789: AND u.user_entity_id = d.user_entity_id
1790: AND u.legislation_code = 'KW'
1791: AND u.business_group_id is null