DBA Data[Home] [Help]

APPS.PAY_ZA_MTC_PKG dependencies on FF_ARCHIVE_ITEMS

Line 70: ff_archive_items arc

66: select paa.serial_number, paa.assignment_action_id
67: from pay_assignment_actions paa,
68: pay_payroll_actions ppa,
69: ff_database_items dbi,
70: ff_archive_items arc
71: where ppa.business_group_id = p_bgid
72: and ppa.report_type = 'ZA_IRP5'
73: and ppa.action_type = 'X'
74: and substr(ppa.legislative_parameters, instr(ppa.legislative_parameters, 'TAX_YEAR') + 9, 4)

Line 203: ff_archive_items arc

199: -- Get the current Assignment Action's Time Period ID
200: select nvl(arc.value, '')
201: into l_period
202: from ff_database_items dbi,
203: ff_archive_items arc
204: where dbi.user_name = 'A_PAY_PROC_PERIOD_ID'
205: and arc.user_entity_id = dbi.user_entity_id
206: and arc.context1 = p_asg_action_id;
207: