DBA Data[Home] [Help]

APPS.PAY_CA_ARCHIVE_UTILS dependencies on FF_DATABASE_ITEMS

Line 19: ff_database_items fdi

15: RETURN VARCHAR2 IS
16: CURSOR csr_get_value(p_archive_action_id NUMBER,p_db_name varchar2) IS
17: select fai.value
18: from ff_archive_items fai,
19: ff_database_items fdi
20: where fai.context1 = p_archive_action_id
21: and fai.user_entity_id=fdi.user_entity_id
22: and fdi.user_name=p_db_name;
23:

Line 69: ff_database_items fdi,

65: CURSOR csr_get_value(p_asg_act_id NUMBER,p_context varchar2,p_context_name varchar2,
66: p_db_name varchar2) IS
67: select fai.value
68: from ff_archive_items fai,
69: ff_database_items fdi,
70: ff_archive_item_contexts fac,
71: ff_contexts ffc
72: where fai.context1 = p_asg_act_id
73: and fai.archive_item_id = fac.archive_item_id