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 110: pay_action_information pai

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

Line 281: pay_action_information pai

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

Line 293: pay_action_information pai

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

Line 305: pay_action_information pai

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

Line 317: pay_action_information pai

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

Line 329: pay_action_information pai

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

Line 362: l_sort pay_action_information.action_information21%type;

358: -- For existing employees
359: -- NOTE: order by statement for above query should not be changed
360: ----------------------------------------------------------------
361:
362: l_sort pay_action_information.action_information21%type;
363:
364: ----------------------------------------------------------------
365: -- Bug No:3298317 Added new column permit_type(action_information21) in select clause.
366: -- Bug No:4226037 Added new column action_information19(termination date) in select clause

Line 382: , pay_action_information pai

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

Line 390: from pay_action_information pai_dup,

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

Line 420: , pay_action_information pai

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

Line 428: from pay_action_information pai_dup,

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

Line 456: l_permit_type pay_action_information.action_information21%type;

452: --
453: function dup_bal_value ( c_assignment_action_id in number) return number
454: is
455:
456: l_permit_type pay_action_information.action_information21%type;
457:
458: /* Bug: 3595103 Modified cursor for permit type 'SP' */
459: cursor get_balances is
460: 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 470: from pay_action_information

466: nvl(to_number(action_information10),0),
467: nvl(to_number(action_information11),0),
468: nvl(to_number(action_information12),0),
469: nvl(to_number(action_information13),0)
470: from pay_action_information
471: where action_context_id = c_assignment_action_id
472: and action_information_category = 'SG CPF DETAILS'
473: and action_context_type = 'AAC';
474: