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_SOE_GLB dependencies on PAY_ASSIGNMENT_ACTIONS

Line 30: , pay_assignment_actions aa

26: ,'''' || bg.currency_code || '''' currency_code
27: ,action_type
28: ,fc.name currency_name
29: from pay_payroll_actions pa
30: , pay_assignment_actions aa
31: , per_business_groups bg
32: , fnd_currencies_vl fc
33: where aa.assignment_action_id = p_assignment_action_id
34: and aa.payroll_action_id = pa.payroll_action_id

Line 41: from pay_assignment_actions

37: and rownum = 1;
38:
39: cursor getActions is
40: select assignment_action_id
41: from pay_assignment_actions
42: where level =
43: (select max(level)
44: from pay_assignment_actions
45: connect by source_action_id = prior assignment_action_id

Line 44: from pay_assignment_actions

40: select assignment_action_id
41: from pay_assignment_actions
42: where level =
43: (select max(level)
44: from pay_assignment_actions
45: connect by source_action_id = prior assignment_action_id
46: start with assignment_action_id = p_assignment_action_id)
47: connect by source_action_id = prior assignment_action_id
48: start with assignment_action_id = p_assignment_action_id;

Line 56: pay_assignment_actions

52: cursor lockedActions is
53: select locked_action_id,
54: action_sequence
55: from pay_action_interlocks,
56: pay_assignment_actions
57: where locking_action_id = p_assignment_action_id
58: and locked_action_id = assignment_action_id
59: order by action_sequence desc;
60:

Line 79: ,pay_assignment_actions aa

75: -- Prepay change
76: select action_type
77: into l_action_type
78: from pay_payroll_actions pa
79: ,pay_assignment_actions aa
80: where aa.assignment_action_id = p_assignment_action_id
81: and aa.payroll_action_id = pa.payroll_action_id;
82:
83: /* exception

Line 172: pay_assignment_actions aa,

168:
169: cursor csr_get_action_id (asg_id number) is
170: select to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
171: from pay_payroll_actions pa,
172: pay_assignment_actions aa,
173: per_time_periods ptp
174: where aa.action_status = 'C'
175: and pa.payroll_action_id = aa.payroll_action_id
176: and aa.assignment_id = asg_id

Line 304: , pay_assignment_actions aa

300: l_action_type varchar2(2);
301: cursor periodDates is
302: select pa.action_type from
303: pay_payroll_actions pa
304: , pay_assignment_actions aa
305: where pa.payroll_action_id = aa.payroll_action_id
306: and aa.assignment_action_id = p_assignment_action_id;
307:
308: begin

Line 335: ,pay_assignment_actions aa1

331: ,pay_payroll_actions pa1
332: ,pay_payroll_actions pa2
333: ,per_time_periods tp1
334: ,per_time_periods tp2
335: ,pay_assignment_actions aa1
336: ,pay_assignment_actions aa2
337: where pa1.payroll_action_id = aa1.payroll_action_id
338: --We are considering effective_date(Date Paid) which some
339: --localizations may allows the user to change. Its the same

Line 336: ,pay_assignment_actions aa2

332: ,pay_payroll_actions pa2
333: ,per_time_periods tp1
334: ,per_time_periods tp2
335: ,pay_assignment_actions aa1
336: ,pay_assignment_actions aa2
337: where pa1.payroll_action_id = aa1.payroll_action_id
338: --We are considering effective_date(Date Paid) which some
339: --localizations may allows the user to change. Its the same
340: --case for the Date Earned as well. Its better to use

Line 374: ,pay_assignment_actions aa

370: ,fnd_date.date_to_displaydate(tp.start_date) COL02
371: ,tp.period_type COL07
372: from pay_payroll_actions pa
373: ,per_time_periods tp
374: ,pay_assignment_actions aa
375: where pa.payroll_action_id = aa.payroll_action_id
376: and pa.effective_date = tp.regular_payment_date
377: and pa.payroll_id = tp.payroll_id
378: and aa.assignment_action_id = :assignment_action_id';

Line 391: ,pay_assignment_actions aa

387: ,fnd_date.date_to_displaydate(tp.start_date) COL02
388: ,tp.period_type COL07
389: from pay_payroll_actions pa
390: ,per_time_periods tp
391: ,pay_assignment_actions aa
392: where pa.payroll_action_id = aa.payroll_action_id
393: and pa.time_period_id = tp.time_period_id
394: and aa.assignment_action_id = :assignment_action_id';
395: end if;

Line 433: from pay_assignment_actions aa

429: , nvl(ettl.reporting_name,ettl.element_name) COL02
430: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
431: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
432: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
433: from pay_assignment_actions aa
434: , pay_run_results rr
435: , pay_run_result_values rrv
436: , pay_input_values_f iv
437: , pay_input_values_f_tl ivtl

Line 533: , pay_assignment_actions aa

529: , pa.business_group_id
530: , bg.legislation_code
531: , lrl.rule_mode
532: from pay_payroll_actions pa
533: , pay_assignment_actions aa
534: , per_business_groups bg
535: , pay_legislation_rules lrl
536: where aa.assignment_action_id = p_assignment_action_id
537: and aa.payroll_action_id = pa.payroll_action_id

Line 582: , pay_assignment_actions aa

578: , rb.SOURCE_TEXT
579: , rb.SOURCE_NUMBER
580: , rb.SOURCE_TEXT2
581: from pay_run_balances rb
582: , pay_assignment_actions aa
583: , pay_payroll_actions pa
584: where rb.ASSIGNMENT_ID = l_assignment_id
585: and l_action_sequence >= aa.action_sequence
586: and rb.assignment_action_id = aa.assignment_action_id

Line 610: from pay_assignment_actions aa,

606: , decode(l_st2_needed_chr,
607: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
608: ,rr.run_result_id)
609: ,null) source_text2
610: from pay_assignment_actions aa,
611: pay_payroll_actions pa,
612: pay_run_results rr
613: where aa.ASSIGNMENT_ID = l_assignment_id
614: and aa.assignment_action_id = rr.assignment_action_id

Line 831: from pay_assignment_actions aa

827: , ivtl.name COL03
828: , rrv.result_value COL04
829: , 1 COL05 -- to indicate that we should drilldown directly to run_result_values
830: , rr.run_result_id COL18
831: from pay_assignment_actions aa
832: , pay_run_results rr
833: , pay_run_result_values rrv
834: , pay_input_values_f iv
835: , pay_input_values_f_tl ivtl

Line 1086: pay_assignment_actions paa,

1082: ,ptp.end_date
1083: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1084: FROM per_time_periods ptp,
1085: pay_payroll_actions ppa,
1086: pay_assignment_actions paa,
1087: pay_run_results prr,
1088: pay_element_entries_f pee
1089: WHERE pee.element_entry_id=c_element_entry_id
1090: and prr.run_result_id = pee.source_id

Line 1108: pay_assignment_actions paa,

1104: ,ptp.end_date
1105: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1106: FROM per_time_periods ptp,
1107: pay_payroll_actions ppa,
1108: pay_assignment_actions paa,
1109: pay_run_results prr,
1110: pay_element_entries_f pee
1111: WHERE pee.element_entry_id=c_element_entry_id
1112: and prr.run_result_id = pee.source_id

Line 1130: pay_assignment_actions paa,

1126: ,ptp.end_date
1127: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1128: FROM per_time_periods ptp,
1129: pay_payroll_actions ppa,
1130: pay_assignment_actions paa,
1131: pay_run_results prr,
1132: pay_element_entries_f pee
1133: WHERE pee.element_entry_id=c_element_entry_id
1134: and prr.run_result_id = pee.source_id

Line 1152: pay_assignment_actions paa,

1148: ,ptp.end_date
1149: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1150: FROM per_time_periods ptp,
1151: pay_payroll_actions ppa,
1152: pay_assignment_actions paa,
1153: pay_element_entries_f pee
1154: WHERE pee.element_entry_id=c_element_entry_id
1155: and paa.assignment_action_id=pee.source_asg_action_id
1156: and ppa.payroll_action_id=paa.payroll_action_id