DBA Data[Home] [Help]

APPS.PAY_AU_RECON_SUMMARY dependencies on PER_ALL_ASSIGNMENTS_F

Line 126: assignment_number per_all_assignments_f.assignment_number%type,

122: g_lst_yr_term varchar2(10);--Bug:3686549
123:
124: type exclusion_asg is record
125: (employee_name per_all_people_f.full_name%type,
126: assignment_number per_all_assignments_f.assignment_number%type,
127: assignment_id per_all_assignments_f.assignment_id%type,
128: reason varchar2(100)
129: );
130:

Line 127: assignment_id per_all_assignments_f.assignment_id%type,

123:
124: type exclusion_asg is record
125: (employee_name per_all_people_f.full_name%type,
126: assignment_number per_all_assignments_f.assignment_number%type,
127: assignment_id per_all_assignments_f.assignment_id%type,
128: reason varchar2(100)
129: );
130:
131: type exc_table is table of exclusion_asg index by binary_integer;

Line 221: function populate_exclusion_table(p_assignment_id per_all_assignments_f.assignment_id%type,

217: function get_exclusion_info(flag varchar2 ,p_assignment_id number) return varchar2;
218:
219: function get_assignment_id(p_assignment_id number) return number;
220:
221: function populate_exclusion_table(p_assignment_id per_all_assignments_f.assignment_id%type,
222: p_financial_year varchar2,
223: p_financial_year_end date,
224: p_tax_unit_id number --2610141
225: )