DBA Data[Home] [Help]

APPS.PAY_KW_MONTHLY_REPORTS dependencies on FF_USER_ENTITIES

Line 56: FROM ff_user_entities u,

52:
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'

Line 736: FROM ff_user_entities u,

732:
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'

Line 1145: FROM ff_user_entities u,

1141:
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'

Line 1786: FROM ff_user_entities u,

1782:
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'