APPS.PAY_KW_MONTHLY_REPORTS dependencies on FF_DATABASE_ITEMS

Line 53: ff_database_items d

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

Line 586: ff_database_items d

582: /*Cursor for fetching defined balance id*/
583: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS
584: SELECT u.creator_id
585: FROM ff_user_entities u,
586: ff_database_items d
587: WHERE d.user_name = p_user_name
588: AND u.user_entity_id = d.user_entity_id
589: AND u.legislation_code = 'KW'
590: AND u.business_group_id is null

Line 995: ff_database_items d

991: /*Cursor for fetching defined balance id*/
992: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS
993: SELECT u.creator_id
994: FROM ff_user_entities u,
995: ff_database_items d
996: WHERE d.user_name = p_user_name
997: AND u.user_entity_id = d.user_entity_id
998: AND u.legislation_code = 'KW'
999: AND u.business_group_id is null

Line 1629: ff_database_items d

1625: /*Cursor for fetching defined balance id*/
1626: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS
1627: SELECT u.creator_id
1628: FROM ff_user_entities u,
1629: ff_database_items d
1630: WHERE d.user_name = p_user_name
1631: AND u.user_entity_id = d.user_entity_id
1632: AND u.legislation_code = 'KW'
1633: AND u.business_group_id is null