APPS.PAY_CA_ARCHIVE_UTILS dependencies on FF_ARCHIVE_ITEMS

Line 18: from ff_archive_items fai,

14: p_db_name varchar2)
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;

Line 68: from ff_archive_items fai,

64: RETURN VARCHAR2 IS
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