APPS.PAY_HK_IR56_REPORT dependencies on FF_ARCHIVE_ITEMS

Line 465: return ff_archive_items.value%type is

461:
462: function get_archive_value
463: (p_archive_name in ff_user_entities.user_entity_name%type,
464: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type)
465: return ff_archive_items.value%type is
466:
467: l_value ff_archive_items.value%type;
468: e_no_value_found exception;
469:

Line 467: l_value ff_archive_items.value%type;

463: (p_archive_name in ff_user_entities.user_entity_name%type,
464: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type)
465: return ff_archive_items.value%type is
466:
467: l_value ff_archive_items.value%type;
468: e_no_value_found exception;
469:
470: -- cursor to fetch the archive value
471:

Line 475: from ff_archive_items fai,

471:
472: cursor csr_get_archive_value(c_archive_name varchar2,
473: c_assignment_action_id number) is
474: select fai.value
475: from ff_archive_items fai,
476: ff_user_entities fue
477: where fai.context1 = c_assignment_action_id
478: and fai.user_entity_id = fue.user_entity_id
479: and fue.user_entity_name = c_archive_name;