[Home] [Help]
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
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
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;
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:
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
171: * id of the assignment irrespective of the session date.*/
172: cursor csr_get_action_id (asg_id number) is
173: select to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
174: from pay_payroll_actions pa,
175: pay_assignment_actions aa
176: -- per_time_periods ptp
177: where aa.action_status = 'C'
178: and pa.payroll_action_id = aa.payroll_action_id
179: and aa.assignment_id = asg_id
310: l_action_type varchar2(2);
311: cursor periodDates is
312: select pa.action_type from
313: pay_payroll_actions pa
314: , pay_assignment_actions aa
315: where pa.payroll_action_id = aa.payroll_action_id
316: and aa.assignment_action_id = p_assignment_action_id;
317:
318: begin
341: ,pay_payroll_actions pa1
342: ,pay_payroll_actions pa2
343: ,per_time_periods tp1
344: ,per_time_periods tp2
345: ,pay_assignment_actions aa1
346: ,pay_assignment_actions aa2
347: where pa1.payroll_action_id = aa1.payroll_action_id
348: --We are considering effective_date(Date Paid) which some
349: --localizations may allows the user to change. Its the same
342: ,pay_payroll_actions pa2
343: ,per_time_periods tp1
344: ,per_time_periods tp2
345: ,pay_assignment_actions aa1
346: ,pay_assignment_actions aa2
347: where pa1.payroll_action_id = aa1.payroll_action_id
348: --We are considering effective_date(Date Paid) which some
349: --localizations may allows the user to change. Its the same
350: --case for the Date Earned as well. Its better to use
380: ,fnd_date.date_to_displaydate(tp.start_date,2) COL02 -- change as per bug 11830805
381: ,tp.period_type COL07
382: from pay_payroll_actions pa
383: ,per_time_periods tp
384: ,pay_assignment_actions aa
385: where pa.payroll_action_id = aa.payroll_action_id
386: -- Bug 9877851 : Included join on time period id rather than on effective date
387: /* and pa.effective_date = tp.regular_payment_date */
388: and pa.time_period_id = tp.time_period_id
399: ,fnd_date.date_to_displaydate(tp.start_date,2) COL02 -- change as per bug 11830805
400: ,tp.period_type COL07
401: from pay_payroll_actions pa
402: ,per_time_periods tp
403: ,pay_assignment_actions aa
404: where pa.payroll_action_id = aa.payroll_action_id
405: and pa.time_period_id = tp.time_period_id
406: and aa.assignment_action_id = :assignment_action_id';
407: end if;
440: , nvl(orginfo.org_information7,nvl(ettl.reporting_name, ettl.element_name)) COL02
441: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
442: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator,
443: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
444: from pay_assignment_actions aa
445: , pay_run_results rr
446: , pay_run_result_values rrv
447: , pay_input_values_f iv
448: , pay_input_values_f_tl ivtl
488: , nvl(ettl.reporting_name,ettl.element_name) COL02
489: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
490: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator,
491: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
492: from pay_assignment_actions aa
493: , pay_run_results rr
494: , pay_run_result_values rrv
495: , pay_input_values_f iv
496: , pay_input_values_f_tl ivtl
595: , pa.business_group_id
596: , bg.legislation_code
597: , lrl.rule_mode
598: from pay_payroll_actions pa
599: , pay_assignment_actions aa
600: , per_business_groups bg
601: , pay_legislation_rules lrl
602: where aa.assignment_action_id = p_assignment_action_id
603: and aa.payroll_action_id = pa.payroll_action_id
644: , rb.SOURCE_TEXT
645: , rb.SOURCE_NUMBER
646: , rb.SOURCE_TEXT2
647: from pay_run_balances rb
648: , pay_assignment_actions aa
649: , pay_payroll_actions pa
650: where rb.ASSIGNMENT_ID = l_assignment_id
651: and l_action_sequence >= aa.action_sequence
652: and rb.assignment_action_id = aa.assignment_action_id
672: , decode(l_st2_needed_chr,
673: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
674: ,rr.run_result_id)
675: ,null) source_text2
676: from pay_assignment_actions aa,
677: pay_payroll_actions pa,
678: pay_run_results rr
679: where aa.ASSIGNMENT_ID = l_assignment_id
680: and aa.assignment_action_id = rr.assignment_action_id
902: , ivtl.name COL03
903: , rrv.result_value COL04
904: , 1 COL05 -- to indicate that we should drilldown directly to run_result_values
905: , rr.run_result_id COL18
906: from pay_assignment_actions aa
907: , pay_run_results rr
908: , pay_run_result_values rrv
909: , pay_input_values_f iv
910: , pay_input_values_f_tl ivtl
1157: ,ptp.end_date
1158: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1159: FROM per_time_periods ptp,
1160: pay_payroll_actions ppa,
1161: pay_assignment_actions paa,
1162: pay_run_results prr,
1163: pay_element_entries_f pee
1164: WHERE pee.element_entry_id=c_element_entry_id
1165: and prr.run_result_id = pee.source_id
1179: ,ptp.end_date
1180: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1181: FROM per_time_periods ptp,
1182: pay_payroll_actions ppa,
1183: pay_assignment_actions paa,
1184: pay_run_results prr,
1185: pay_element_entries_f pee
1186: WHERE pee.element_entry_id=c_element_entry_id
1187: and prr.run_result_id = pee.source_id
1201: ,ptp.end_date
1202: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1203: FROM per_time_periods ptp,
1204: pay_payroll_actions ppa,
1205: pay_assignment_actions paa,
1206: pay_run_results prr,
1207: pay_element_entries_f pee
1208: WHERE pee.element_entry_id=c_element_entry_id
1209: and prr.run_result_id = pee.source_id
1223: ,ptp.end_date
1224: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1225: FROM per_time_periods ptp,
1226: pay_payroll_actions ppa,
1227: pay_assignment_actions paa,
1228: pay_element_entries_f pee
1229: WHERE pee.element_entry_id=c_element_entry_id
1230: and paa.assignment_action_id=pee.source_asg_action_id
1231: and ppa.payroll_action_id=paa.payroll_action_id