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 108: from pay_payroll_actions ppa,

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

Line 127: pay_payroll_actions ppa

123: cursor fwl_amount_reporting
124: is
125: select nvl(hoi.org_information20,'Y')
126: from hr_organization_information hoi,
127: pay_payroll_actions ppa
128: where ppa.payroll_action_id = p_payroll_action_id
129: and hoi.organization_id =
130: to_number(pay_core_utils.get_parameter('LEGAL_ENTITY_ID',
131: ppa.legislative_parameters))

Line 279: from pay_payroll_actions ppa,

275: ----------------------------------------------------------------------------------------------
276: if p_stat_type = 'MUS' then
277: select count( distinct nvl(pai.action_information1,pai.source_id) )
278: into l_count
279: from pay_payroll_actions ppa,
280: pay_assignment_actions paa,
281: pay_action_information pai
282: where ppa.payroll_action_id = p_payroll_action_id
283: and ppa.payroll_action_id = paa.payroll_action_id

Line 291: from pay_payroll_actions ppa,

287: and to_number(pai.action_information8) > 0;
288: elsif p_stat_type = 'SHA' then
289: select count( distinct nvl(pai.action_information1,pai.source_id) )
290: into l_count
291: from pay_payroll_actions ppa,
292: pay_assignment_actions paa,
293: pay_action_information pai
294: where ppa.payroll_action_id = p_payroll_action_id
295: and ppa.payroll_action_id = paa.payroll_action_id

Line 303: from pay_payroll_actions ppa,

299: and to_number(pai.action_information14) > 0;
300: elsif p_stat_type = 'SIN' then
301: select count( distinct nvl(pai.action_information1,pai.source_id) )
302: into l_count
303: from pay_payroll_actions ppa,
304: pay_assignment_actions paa,
305: pay_action_information pai
306: where ppa.payroll_action_id = p_payroll_action_id
307: and ppa.payroll_action_id = paa.payroll_action_id

Line 315: from pay_payroll_actions ppa,

311: and to_number(pai.action_information9) > 0;
312: elsif p_stat_type = 'CDA' then
313: select count( distinct nvl(pai.action_information1,pai.source_id) )
314: into l_count
315: from pay_payroll_actions ppa,
316: pay_assignment_actions paa,
317: pay_action_information pai
318: where ppa.payroll_action_id = p_payroll_action_id
319: and ppa.payroll_action_id = paa.payroll_action_id

Line 327: from pay_payroll_actions ppa,

323: and to_number(pai.action_information10) > 0;
324: elsif p_stat_type = 'ECF' then
325: select count( distinct nvl(pai.action_information1,pai.source_id) )
326: into l_count
327: from pay_payroll_actions ppa,
328: pay_assignment_actions paa,
329: pay_action_information pai
330: where ppa.payroll_action_id = p_payroll_action_id
331: and ppa.payroll_action_id = paa.payroll_action_id

Line 380: from pay_payroll_actions ppa

376: paa.assignment_action_id,
377: pai.tax_unit_id,
378: fnd_date.canonical_to_date(pai.action_information20),
379: pai.action_information19
380: from pay_payroll_actions ppa
381: , pay_assignment_actions paa
382: , pay_action_information pai
383: where ppa.payroll_action_id = p_payroll_action_id
384: and ppa.payroll_action_id = paa.payroll_action_id

Line 418: from pay_payroll_actions ppa

414: paa.assignment_action_id,
415: pai.tax_unit_id,
416: fnd_date.canonical_to_date(pai.action_information20),
417: pai.action_information19
418: from pay_payroll_actions ppa
419: , pay_assignment_actions paa
420: , pay_action_information pai
421: where ppa.payroll_action_id = p_payroll_action_id
422: and ppa.payroll_action_id = paa.payroll_action_id