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 PAY_PAYROLL_ACTIONS

Line 52: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type)

48: --Bug# 3501950
49: -- This function is called from company_identification cursor
50: -------------------------------------------------------------
51: function get_cpf_interest
52: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
53: return varchar2
54: is
55: l_cpf_interest varchar2(100);
56: begin

Line 59: from pay_payroll_actions

55: l_cpf_interest varchar2(100);
56: begin
57: select nvl(pay_core_utils.get_parameter('CPF_INTEREST',legislative_parameters),0)
58: into l_cpf_interest
59: from pay_payroll_actions
60: where payroll_action_id = c_payroll_action_id;
61: return l_cpf_interest;
62: end get_cpf_interest;
63: -------------------------------------------------------------

Line 68: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type)

64: --Bug# 3501950
65: -- This function is called from company_identification cursor
66: -------------------------------------------------------------
67: function get_fwl_interest
68: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
69: return varchar2
70: is
71: l_fwl_interest varchar2(100);
72: begin

Line 75: from pay_payroll_actions

71: l_fwl_interest varchar2(100);
72: begin
73: select nvl(pay_core_utils.get_parameter('FWL_INTEREST',legislative_parameters),0)
74: into l_fwl_interest
75: from pay_payroll_actions
76: where payroll_action_id = c_payroll_action_id;
77: return l_fwl_interest;
78: end get_fwl_interest;
79: -----------------------------------------------

Line 107: from pay_payroll_actions ppa,

103: nvl(to_char(sum(decode(sign(to_number(pai.action_information16)),1,to_number(pai.action_information16),0)),'999999.99'),0),
104: nvl(to_char(sum(decode(sign(to_number(pai.action_information9)),1,to_number(pai.action_information9),0)),'999999.99'),0),
105: nvl(to_char(sum(decode(sign(to_number(pai.action_information10)),1,to_number(pai.action_information10),0)),'999999.99'),0),
106: nvl(to_char(sum(decode(sign(to_number(pai.action_information11)),1,to_number(pai.action_information11),0)),'999999.99'),0)
107: from pay_payroll_actions ppa,
108: pay_assignment_actions paa,
109: pay_action_information pai
110: where ppa.payroll_action_id = p_payroll_action_id
111: and ppa.payroll_action_id = paa.payroll_action_id

Line 120: pay_payroll_actions ppa

116: cursor fwl_amount_reporting
117: is
118: select nvl(hoi.org_information20,'Y')
119: from hr_organization_information hoi,
120: pay_payroll_actions ppa
121: where ppa.payroll_action_id = p_payroll_action_id
122: and hoi.organization_id =
123: to_number(pay_core_utils.get_parameter('LEGAL_ENTITY_ID',
124: ppa.legislative_parameters))

Line 271: from pay_payroll_actions ppa,

267: ----------------------------------------------------------------------------------------------
268: if p_stat_type = 'MUS' then
269: select count( distinct nvl(pai.action_information1,pai.source_id) )
270: into l_count
271: from pay_payroll_actions ppa,
272: pay_assignment_actions paa,
273: pay_action_information pai
274: where ppa.payroll_action_id = p_payroll_action_id
275: and ppa.payroll_action_id = paa.payroll_action_id

Line 283: from pay_payroll_actions ppa,

279: and to_number(pai.action_information8) > 0;
280: elsif p_stat_type = 'SHA' then
281: select count( distinct nvl(pai.action_information1,pai.source_id) )
282: into l_count
283: from pay_payroll_actions ppa,
284: pay_assignment_actions paa,
285: pay_action_information pai
286: where ppa.payroll_action_id = p_payroll_action_id
287: and ppa.payroll_action_id = paa.payroll_action_id

Line 295: from pay_payroll_actions ppa,

291: and to_number(pai.action_information14) > 0;
292: elsif p_stat_type = 'SIN' then
293: select count( distinct nvl(pai.action_information1,pai.source_id) )
294: into l_count
295: from pay_payroll_actions ppa,
296: pay_assignment_actions paa,
297: pay_action_information pai
298: where ppa.payroll_action_id = p_payroll_action_id
299: and ppa.payroll_action_id = paa.payroll_action_id

Line 307: from pay_payroll_actions ppa,

303: and to_number(pai.action_information9) > 0;
304: elsif p_stat_type = 'CDA' then
305: select count( distinct nvl(pai.action_information1,pai.source_id) )
306: into l_count
307: from pay_payroll_actions ppa,
308: pay_assignment_actions paa,
309: pay_action_information pai
310: where ppa.payroll_action_id = p_payroll_action_id
311: and ppa.payroll_action_id = paa.payroll_action_id

Line 319: from pay_payroll_actions ppa,

315: and to_number(pai.action_information10) > 0;
316: elsif p_stat_type = 'ECF' then
317: select count( distinct nvl(pai.action_information1,pai.source_id) )
318: into l_count
319: from pay_payroll_actions ppa,
320: pay_assignment_actions paa,
321: pay_action_information pai
322: where ppa.payroll_action_id = p_payroll_action_id
323: and ppa.payroll_action_id = paa.payroll_action_id

Line 372: from pay_payroll_actions ppa

368: paa.assignment_action_id,
369: pai.tax_unit_id,
370: fnd_date.canonical_to_date(pai.action_information20),
371: pai.action_information19
372: from pay_payroll_actions ppa
373: , pay_assignment_actions paa
374: , pay_action_information pai
375: where ppa.payroll_action_id = p_payroll_action_id
376: and ppa.payroll_action_id = paa.payroll_action_id

Line 410: from pay_payroll_actions ppa

406: paa.assignment_action_id,
407: pai.tax_unit_id,
408: fnd_date.canonical_to_date(pai.action_information20),
409: pai.action_information19
410: from pay_payroll_actions ppa
411: , pay_assignment_actions paa
412: , pay_action_information pai
413: where ppa.payroll_action_id = p_payroll_action_id
414: and ppa.payroll_action_id = paa.payroll_action_id