eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SG_CPFLINE_BALANCES dependencies on PER_ALL_ASSIGNMENTS_F

Line 347: p_assignment_id in per_all_assignments_f.assignment_id%type,

343: end stat_type_count;
344: --
345: function get_balance_value
346: ( p_employee_type in varchar2,
347: p_assignment_id in per_all_assignments_f.assignment_id%type,
348: p_cpf_acc_number in varchar2,
349: p_department in varchar2,
350: p_assignment_action_id in varchar2,
351: p_tax_unit_id in varchar2,

Line 401: -- check on ppa.effective_date and per_all_assignments_f

397: order by cpf_acc_number,pai.action_information3 desc,pai.action_information23 desc;
398: ------------------------------------------------------------------------------
399: -- for new employees
400: -- Bug:3010644. Modified paa.effective_start_date join and added date track
401: -- check on ppa.effective_date and per_all_assignments_f
402: -- NOTE: order by statement for above query should not be changed
403: -- Bug No:3298317 Added new column permit_type(action_information21) in select clause.
404: -- Bug No:4226037 Added new column action_information19(termination date) in select clause
405: ------------------------------------------------------------------------------