APPS.PAY_KR_YEA_MAGTAPE_FUN_PKG dependencies on FF_ARCHIVE_ITEMS

Line 59: from ff_archive_items i1,

55: and paa.action_status = 'C';
56:
57: cursor csr_b3 (p_user_entity_id in ff_user_entities.user_entity_id%type) is
58: select nvl(sum(greatest(to_number(i1.value), 0)), 0)
59: from ff_archive_items i1,
60: pay_assignment_actions paa,
61: pay_payroll_actions ppa,
62: hr_organization_units bp,
63: hr_organization_information hoi1,

Line 421: from ff_user_entities ffue, ff_archive_items ffai

417: value varchar2(300);
418: begin
419: select ffai.value
420: into value
421: from ff_user_entities ffue, ff_archive_items ffai
422: where ffue.user_entity_name = p_user_entity_name
423: and ffue.legislation_code = 'KR'
424: and ffue.creator_type = 'X'
425: and ffai.user_entity_id = ffue.user_entity_id