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_ACTION_INFORMATION

Line 109: pay_action_information pai

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
113: and pai.action_information_category = 'SG CPF DETAILS'

Line 273: pay_action_information pai

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
277: and pai.action_information_category = 'SG CPF DETAILS'

Line 285: pay_action_information pai

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
289: and pai.action_information_category = 'SG CPF DETAILS'

Line 297: pay_action_information pai

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
301: and pai.action_information_category = 'SG CPF DETAILS'

Line 309: pay_action_information pai

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
313: and pai.action_information_category = 'SG CPF DETAILS'

Line 321: pay_action_information pai

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
325: and pai.action_information_category = 'SG CPF DETAILS'

Line 354: l_sort pay_action_information.action_information21%type;

350: -- For existing employees
351: -- NOTE: order by statement for above query should not be changed
352: ----------------------------------------------------------------
353:
354: l_sort pay_action_information.action_information21%type;
355:
356: ----------------------------------------------------------------
357: -- Bug No:3298317 Added new column permit_type(action_information21) in select clause.
358: -- Bug No:4226037 Added new column action_information19(termination date) in select clause

Line 374: , pay_action_information pai

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
378: and pai.action_information_category = 'SG CPF DETAILS'

Line 382: from pay_action_information pai_dup,

378: and pai.action_information_category = 'SG CPF DETAILS'
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

Line 412: , pay_action_information pai

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
416: and pai.action_information_category = 'SG CPF DETAILS'

Line 420: from pay_action_information pai_dup,

416: and pai.action_information_category = 'SG CPF DETAILS'
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

Line 448: l_permit_type pay_action_information.action_information21%type;

444: --
445: function dup_bal_value ( c_assignment_action_id in number) return number
446: is
447:
448: l_permit_type pay_action_information.action_information21%type;
449:
450: /* Bug: 3595103 Modified cursor for permit type 'SP' */
451: cursor get_balances is
452: select nvl(decode( action_information1,null,0,(decode(action_information21,'WP',0,(decode(action_information21,'EP',0,(decode(action_information21,'SP',0,to_number(action_information4) ))))))),0),

Line 462: from pay_action_information

458: nvl(to_number(action_information10),0),
459: nvl(to_number(action_information11),0),
460: nvl(to_number(action_information12),0),
461: nvl(to_number(action_information13),0)
462: from pay_action_information
463: where action_context_id = c_assignment_action_id
464: and action_information_category = 'SG CPF DETAILS'
465: and action_context_type = 'AAC';
466: