APPS.PAY_SG_IRAS_MAGTAPE dependencies on FF_DATABASE_ITEMS

Line 106: v_type ff_database_items.user_name%type;

102: p_chunk in number) is
103:
104: v_next_action_id pay_assignment_actions.assignment_action_id%type;
105: v_archive_action_id pay_assignment_actions.assignment_action_id%type;
106: v_type ff_database_items.user_name%type;
107:
108: cursor next_action_id is
109: select pay_assignment_actions_s.nextval
110: from dual;

Line 116: c_type in ff_database_items.user_name%type) is

112: cursor process_assignments
113: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
114: c_start_person_id in per_all_people_f.person_id%type,
115: c_end_person_id in per_all_people_f.person_id%type,
116: c_type in ff_database_items.user_name%type) is
117: select distinct a.assignment_id,
118: pay_core_utils.get_parameter('ARCHIVE_RUN_ID', pa.legislative_parameters) archive_run_id,
119: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', pa.legislative_parameters) legal_entity_id
120: from per_assignments_f a, /* Bug# 2920732 */

Line 176: ff_database_items fdis

172: or (g_report_type='A' AND exists (select '' from
173: pay_assignment_actions aacs,
174: pay_payroll_Actions ppas,
175: ff_archive_items ffis,
176: ff_database_items fdis
177: where ffis.context1 = aacs.assignment_action_id
178: and a.assignment_id = aacs.assignment_id
179: and aacs.payroll_action_id = ppas.payroll_action_id
180: and fdis.user_name = c_type