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_ASSIGNMENT_ACTIONS

Line 15: ( assact_id pay_assignment_actions.assignment_action_id%type

11: -- in the existing /new employees cursor
12: -- Bug No:3298317 Added column permit_type
13: ------------------------------------------------------
14: TYPE t_cpf_balances IS RECORD
15: ( assact_id pay_assignment_actions.assignment_action_id%type
16: ,vol_cpf_liab number -- action_information4
17: ,cpf_liab number -- action_information6
18: ,vol_cpf_wheld number -- action_information5
19: ,cpf_wheld number -- action_information7

Line 108: pay_assignment_actions paa,

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
112: and paa.assignment_action_id = pai.action_context_id

Line 272: pay_assignment_actions paa,

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
276: and paa.assignment_action_id = pai.action_context_id

Line 284: pay_assignment_actions paa,

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
288: and paa.assignment_action_id = pai.action_context_id

Line 296: pay_assignment_actions paa,

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
300: and paa.assignment_action_id = pai.action_context_id

Line 308: pay_assignment_actions paa,

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
312: and paa.assignment_action_id = pai.action_context_id

Line 320: pay_assignment_actions paa,

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
324: and paa.assignment_action_id = pai.action_context_id

Line 373: , pay_assignment_actions paa

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
377: and paa.assignment_action_id = pai.action_context_id

Line 383: pay_assignment_actions paa_dup

379: and pai.action_context_type = 'AAC'
380: and pai.action_information2 = 'EE'
381: and exists ( select 1
382: from pay_action_information pai_dup,
383: pay_assignment_actions paa_dup
384: where pai.action_information_category = pai_dup.action_information_category
385: and pai.rowid <> pai_dup.rowid
386: and paa_dup.payroll_action_id = ppa.payroll_action_id
387: and paa_dup.assignment_action_id = pai_dup.action_context_id

Line 411: , pay_assignment_actions paa

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
415: and paa.assignment_action_id = pai.action_context_id

Line 421: pay_assignment_actions paa_dup

417: and pai.action_context_type = 'AAC'
418: and pai.action_information2 = 'NEW'
419: and exists ( select 1
420: from pay_action_information pai_dup,
421: pay_assignment_actions paa_dup
422: where pai.action_information_category = pai_dup.action_information_category
423: and pai.rowid <> pai_dup.rowid
424: and paa_dup.payroll_action_id = ppa.payroll_action_id
425: and paa_dup.assignment_action_id = pai_dup.action_context_id