APPS.PAY_HK_IR56_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS

Line 23: IS table of per_all_assignments.assignment_id%type

19: -- 10 Jan 2003 srrajago 2740270 A PL/SQL table defined to store assignment ids.
20:
21: /* Bug No : 2740270 - Defined PL/SQL table to store assignment_ids */
22: TYPE t_assignmentid_store_tab
23: IS table of per_all_assignments.assignment_id%type
24: index by binary_integer;
25:
26: t_assignmentid_store t_assignmentid_store_tab;
27:

Line 35: FROM per_all_assignments_f paa,

31: IS
32: SELECT DISTINCT
33: 'ARCHIVE_MESSAGE=P',
34: fai.value
35: FROM per_all_assignments_f paa,
36: pay_payroll_actions ppa,
37: pay_assignment_actions pac,
38: ff_database_items fdi,
39: ff_archive_items fai