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 109: pay_assignment_actions paa,

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

Line 280: pay_assignment_actions paa,

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

Line 292: pay_assignment_actions paa,

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

Line 304: pay_assignment_actions paa,

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

Line 316: pay_assignment_actions paa,

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

Line 328: pay_assignment_actions paa,

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

Line 381: , pay_assignment_actions paa

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

Line 391: pay_assignment_actions paa_dup

387: and pai.action_context_type = 'AAC'
388: and pai.action_information2 = 'EE'
389: and exists ( select 1
390: from pay_action_information pai_dup,
391: pay_assignment_actions paa_dup
392: where pai.action_information_category = pai_dup.action_information_category
393: and pai.rowid <> pai_dup.rowid
394: and paa_dup.payroll_action_id = ppa.payroll_action_id
395: and paa_dup.assignment_action_id = pai_dup.action_context_id

Line 419: , pay_assignment_actions paa

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

Line 429: pay_assignment_actions paa_dup

425: and pai.action_context_type = 'AAC'
426: and pai.action_information2 = 'NEW'
427: and exists ( select 1
428: from pay_action_information pai_dup,
429: pay_assignment_actions paa_dup
430: where pai.action_information_category = pai_dup.action_information_category
431: and pai.rowid <> pai_dup.rowid
432: and paa_dup.payroll_action_id = ppa.payroll_action_id
433: and paa_dup.assignment_action_id = pai_dup.action_context_id