APPS.PAY_ZA_MTC_PKG dependencies on FF_DATABASE_ITEMS

Line 69: ff_database_items dbi,

65: cursor other_ass_ls(p_period varchar2) is
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'

Line 202: from ff_database_items dbi,

198:
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;