[Home] [Help]
169: balance_found boolean,
170: balance_value number,
171: jurisdiction_level pay_balance_types.jurisdiction_level%type,
172: tax_unit_id pay_assignment_actions.tax_unit_id%type,
173: jurisdiction_code pay_run_results.jurisdiction_code%type,
174: source_id number,
175: source_text pay_run_result_values.result_value%type,
176: source_number number,
177: source_text2 pay_run_result_values.result_value%type,
174: source_id number,
175: source_text pay_run_result_values.result_value%type,
176: source_number number,
177: source_text2 pay_run_result_values.result_value%type,
178: time_def_id pay_run_results.time_definition_id%type,
179: balance_date pay_run_results.end_date%type,
180: original_entry_id number,
181: local_unit_id pay_run_results.local_unit_id%type,
182: source_number2 number,
175: source_text pay_run_result_values.result_value%type,
176: source_number number,
177: source_text2 pay_run_result_values.result_value%type,
178: time_def_id pay_run_results.time_definition_id%type,
179: balance_date pay_run_results.end_date%type,
180: original_entry_id number,
181: local_unit_id pay_run_results.local_unit_id%type,
182: source_number2 number,
183: organization_id number
177: source_text2 pay_run_result_values.result_value%type,
178: time_def_id pay_run_results.time_definition_id%type,
179: balance_date pay_run_results.end_date%type,
180: original_entry_id number,
181: local_unit_id pay_run_results.local_unit_id%type,
182: source_number2 number,
183: organization_id number
184: );
185: --
192: run_balance_id pay_run_balances.run_balance_id%type,
193: defined_balance_id pay_defined_balances.defined_balance_id%type,
194: payroll_action_id pay_payroll_actions.payroll_action_id%type,
195: tax_unit_id pay_assignment_actions.tax_unit_id%type,
196: jurisdiction_code pay_run_results.jurisdiction_code%type,
197: source_id number,
198: source_text pay_run_result_values.result_value%type,
199: source_number number,
200: source_text2 pay_run_result_values.result_value%type,
197: source_id number,
198: source_text pay_run_result_values.result_value%type,
199: source_number number,
200: source_text2 pay_run_result_values.result_value%type,
201: time_def_id pay_run_results.time_definition_id%type,
202: balance_date pay_run_results.end_date%type,
203: local_unit_id pay_run_results.local_unit_id%type,
204: source_number2 number,
205: organization_id number,
198: source_text pay_run_result_values.result_value%type,
199: source_number number,
200: source_text2 pay_run_result_values.result_value%type,
201: time_def_id pay_run_results.time_definition_id%type,
202: balance_date pay_run_results.end_date%type,
203: local_unit_id pay_run_results.local_unit_id%type,
204: source_number2 number,
205: organization_id number,
206: next number
199: source_number number,
200: source_text2 pay_run_result_values.result_value%type,
201: time_def_id pay_run_results.time_definition_id%type,
202: balance_date pay_run_results.end_date%type,
203: local_unit_id pay_run_results.local_unit_id%type,
204: source_number2 number,
205: organization_id number,
206: next number
207: );
230: --
231: type t_context_details_rec is record
232: (
233: tax_unit_id pay_assignment_actions.tax_unit_id%type,
234: jurisdiction_code pay_run_results.jurisdiction_code%type,
235: source_id pay_run_result_values.result_value%type,
236: source_text pay_run_result_values.result_value%type,
237: source_number pay_run_result_values.result_value%type,
238: source_text2 pay_run_result_values.result_value%type,
235: source_id pay_run_result_values.result_value%type,
236: source_text pay_run_result_values.result_value%type,
237: source_number pay_run_result_values.result_value%type,
238: source_text2 pay_run_result_values.result_value%type,
239: time_def_id pay_run_results.time_definition_id%type,
240: balance_date pay_run_results.end_date%type,
241: local_unit_id pay_run_results.local_unit_id%type,
242: source_number2 number,
243: organization_id number,
236: source_text pay_run_result_values.result_value%type,
237: source_number pay_run_result_values.result_value%type,
238: source_text2 pay_run_result_values.result_value%type,
239: time_def_id pay_run_results.time_definition_id%type,
240: balance_date pay_run_results.end_date%type,
241: local_unit_id pay_run_results.local_unit_id%type,
242: source_number2 number,
243: organization_id number,
244: prv_tax_unit_id pay_assignment_actions.tax_unit_id%type,
237: source_number pay_run_result_values.result_value%type,
238: source_text2 pay_run_result_values.result_value%type,
239: time_def_id pay_run_results.time_definition_id%type,
240: balance_date pay_run_results.end_date%type,
241: local_unit_id pay_run_results.local_unit_id%type,
242: source_number2 number,
243: organization_id number,
244: prv_tax_unit_id pay_assignment_actions.tax_unit_id%type,
245: prv_jurisdiction_code pay_run_results.jurisdiction_code%type,
241: local_unit_id pay_run_results.local_unit_id%type,
242: source_number2 number,
243: organization_id number,
244: prv_tax_unit_id pay_assignment_actions.tax_unit_id%type,
245: prv_jurisdiction_code pay_run_results.jurisdiction_code%type,
246: prv_source_id pay_run_result_values.result_value%type,
247: prv_source_text pay_run_result_values.result_value%type,
248: prv_source_number pay_run_result_values.result_value%type,
249: prv_source_text2 pay_run_result_values.result_value%type,
246: prv_source_id pay_run_result_values.result_value%type,
247: prv_source_text pay_run_result_values.result_value%type,
248: prv_source_number pay_run_result_values.result_value%type,
249: prv_source_text2 pay_run_result_values.result_value%type,
250: prv_time_def_id pay_run_results.time_definition_id%type,
251: prv_balance_date pay_run_results.end_date%type,
252: prv_local_unit_id pay_run_results.local_unit_id%type,
253: prv_source_number2 number,
254: prv_organization_id number,
247: prv_source_text pay_run_result_values.result_value%type,
248: prv_source_number pay_run_result_values.result_value%type,
249: prv_source_text2 pay_run_result_values.result_value%type,
250: prv_time_def_id pay_run_results.time_definition_id%type,
251: prv_balance_date pay_run_results.end_date%type,
252: prv_local_unit_id pay_run_results.local_unit_id%type,
253: prv_source_number2 number,
254: prv_organization_id number,
255: tu_needed boolean,
248: prv_source_number pay_run_result_values.result_value%type,
249: prv_source_text2 pay_run_result_values.result_value%type,
250: prv_time_def_id pay_run_results.time_definition_id%type,
251: prv_balance_date pay_run_results.end_date%type,
252: prv_local_unit_id pay_run_results.local_unit_id%type,
253: prv_source_number2 number,
254: prv_organization_id number,
255: tu_needed boolean,
256: jc_needed boolean,
280: --
281: type t_run_result_rec is record
282: (run_result_id number
283: ,element_type_id number
284: ,jurisdiction_code pay_run_results.jurisdiction_code%type
285: ,assignment_action_id number
286: ,assignment_id number
287: ,tax_unit_id number
288: ,payroll_action_id number
285: ,assignment_action_id number
286: ,assignment_id number
287: ,tax_unit_id number
288: ,payroll_action_id number
289: ,time_def_id pay_run_results.time_definition_id%type
290: ,balance_date pay_run_results.end_date%type
291: ,local_unit_id pay_run_results.local_unit_id%type
292: ,source_number2 number
293: ,organization_id number
286: ,assignment_id number
287: ,tax_unit_id number
288: ,payroll_action_id number
289: ,time_def_id pay_run_results.time_definition_id%type
290: ,balance_date pay_run_results.end_date%type
291: ,local_unit_id pay_run_results.local_unit_id%type
292: ,source_number2 number
293: ,organization_id number
294: ,business_group_id number
287: ,tax_unit_id number
288: ,payroll_action_id number
289: ,time_def_id pay_run_results.time_definition_id%type
290: ,balance_date pay_run_results.end_date%type
291: ,local_unit_id pay_run_results.local_unit_id%type
292: ,source_number2 number
293: ,organization_id number
294: ,business_group_id number
295: ,legislation_code per_business_groups.legislation_code%type
4794: prev_def_bal_id number;
4795: l_add_balance boolean;
4796: start_def_bal_ptr number;
4797: pos_indx number_tab;
4798: bal_ju_code pay_run_results.jurisdiction_code%type;
4799: con_ju_code pay_run_results.jurisdiction_code%type;
4800: begin
4801: --
4802: -- Now get the balances
4795: l_add_balance boolean;
4796: start_def_bal_ptr number;
4797: pos_indx number_tab;
4798: bal_ju_code pay_run_results.jurisdiction_code%type;
4799: con_ju_code pay_run_results.jurisdiction_code%type;
4800: begin
4801: --
4802: -- Now get the balances
4803: --
4936: l_add_balance boolean;
4937: start_def_bal_ptr number;
4938: l_retrieval_cnt number;
4939: pos_indx number_tab;
4940: bal_ju_code pay_run_results.jurisdiction_code%type;
4941: con_ju_code pay_run_results.jurisdiction_code%type;
4942: --
4943: begin
4944: g_debug := hr_utility.debug_enabled;
4937: start_def_bal_ptr number;
4938: l_retrieval_cnt number;
4939: pos_indx number_tab;
4940: bal_ju_code pay_run_results.jurisdiction_code%type;
4941: con_ju_code pay_run_results.jurisdiction_code%type;
4942: --
4943: begin
4944: g_debug := hr_utility.debug_enabled;
4945: --
6247: and exists ( select /*+ no_unnest */ 'x'
6248: from pay_run_balances rb
6249: where rb.defined_balance_id = pdb.defined_balance_id
6250: and rb.effective_date >= p_inv_date
6251: and exists ( select /*+ no_unnest */ 1 from pay_run_results rr,
6252: pay_run_result_values rrv
6253: where rr.assignment_action_id = rb.assignment_action_id
6254: and rr.element_type_id = p_element_type_id
6255: and rrv.run_result_id = rr.run_result_id
6278: pay_assignment_actions assact
6279: where rb.defined_balance_id = pdb.defined_balance_id
6280: and rb.effective_date >= p_inv_date
6281: and assact.payroll_action_id = rb.payroll_action_id
6282: and exists ( select /*+ no_unnest */ 1 from pay_run_results rr,
6283: pay_run_result_values rrv
6284: where rr.assignment_action_id = assact.assignment_action_id
6285: and rr.element_type_id = p_element_type_id
6286: and rrv.run_result_id = rr.run_result_id
6311: and exists ( select 'x'
6312: from pay_run_balances rb
6313: where rb.defined_balance_id = pdb.defined_balance_id
6314: and rb.effective_date >= p_inv_date
6315: and exists ( select 1 from pay_run_results rr,
6316: pay_run_result_values rrv
6317: where rr.assignment_action_id = rb.assignment_action_id
6318: and rr.element_type_id = p_element_type_id
6319: and rrv.run_result_id = rr.run_result_id
6342: pay_assignment_actions assact
6343: where rb.defined_balance_id = pdb.defined_balance_id
6344: and rb.effective_date >= p_inv_date
6345: and assact.payroll_action_id = rb.payroll_action_id
6346: and exists ( select 1 from pay_run_results rr,
6347: pay_run_result_values rrv
6348: where rr.assignment_action_id = assact.assignment_action_id
6349: and rr.element_type_id = p_element_type_id
6350: and rrv.run_result_id = rr.run_result_id
6512: ,prr.end_date
6513: ,prr.local_unit_id
6514: from
6515: pay_assignment_actions paa
6516: ,pay_run_results prr
6517: where
6518: paa.assignment_action_id = prr.assignment_action_id
6519: and prr.run_result_id = p_run_result_id
6520: ;
7059: p_sn_needed in varchar2,
7060: p_st2_needed in varchar2,
7061: p_sn2_needed in varchar2,
7062: p_org_needed in varchar2) is
7063: select /*+ ORDERED USE_NL(prr) INDEX(prr pay_run_results_n50)*/
7064: distinct
7065: paa.tax_unit_id tax_unit_id
7066: , prr.jurisdiction_code jurisdiction_code
7067: , decode(p_si_needed,
7088: , ppa.effective_date
7089: from pay_assignment_actions paa,
7090: pay_payroll_actions ppa,
7091: per_time_periods ptp,
7092: pay_run_results prr
7093: where paa.assignment_action_id = p_asg_action
7094: and ppa.payroll_action_id = paa.payroll_action_id
7095: and paa.assignment_action_id = prr.assignment_action_id
7096: and ptp.payroll_id = ppa.payroll_id
8051: p_sn_needed in varchar2,
8052: p_st2_needed in varchar2,
8053: p_sn2_needed in varchar2,
8054: p_org_needed in varchar2) is
8055: select /*+ ORDERED USE_NL(prr) INDEX(prr pay_run_results_n50)*/
8056: distinct
8057: paa.tax_unit_id tax_unit_id
8058: , prr.jurisdiction_code jurisdiction_code
8059: , decode(p_si_needed,
8079: , nvl(prr.end_date, ptp.end_date) balance_date
8080: from pay_assignment_actions paa,
8081: pay_payroll_actions ppa,
8082: per_time_periods ptp,
8083: pay_run_results prr
8084: where paa.assignment_action_id = asgact
8085: and paa.assignment_action_id = prr.assignment_action_id
8086: and ppa.payroll_action_id = paa.payroll_action_id
8087: and ppa.payroll_id = ptp.payroll_id
8353: p_org_needed in varchar2,
8354: p_earned_period_end_date date) is
8355:
8356: -- bug 9368185 avoid to per_time_periods for balance date context
8357: select /*+ ORDERED USE_NL (prr) INDEX(prr pay_run_results_n50)*/
8358: distinct
8359: decode(p_tu_needed,
8360: 'Y', paa.tax_unit_id,
8361: null) tax_unit_id
8390: 'Y', find_context('ORGANIZATION_ID', prr.run_result_id),
8391: null) organization_id
8392: from pay_assignment_actions paa,
8393: pay_payroll_actions ppa,
8394: pay_run_results prr
8395: where paa.payroll_action_id = p_pact_id
8396: and paa.assignment_action_id = prr.assignment_action_id
8397: and ppa.payroll_action_id = paa.payroll_action_id
8398: order by 1, 2, 3, 4;
8617: pbt.balance_type_id,
8618: pbd.balance_dimension_id
8619: from
8620: pay_assignment_actions paa,
8621: pay_run_results prr,
8622: pay_input_values_f piv,
8623: pay_balance_feeds_f pbf,
8624: pay_balance_types pbt,
8625: pay_defined_balances pdb,
8662: and prrv.run_result_id = prr.run_result_id
8663: and prrv.input_value_id = piv.input_value_id
8664: and prrv.result_value is not null;
8665: -- and exists (select /*+ ORDERED */ ''
8666: -- from pay_run_results prr,
8667: -- pay_run_result_values prrv,
8668: -- pay_balance_feeds_f pbf
8669: -- where prr.assignment_action_id = p_asg_act_id
8670: -- and prr.run_result_id = prrv.run_result_id
8694: and pbd.dimension_level = 'GRP'
8695: and p_def_bal_id = pba.defined_balance_id
8696: and exists (select /*+ ORDERED */ ''
8697: from pay_assignment_actions paa,
8698: pay_run_results prr,
8699: pay_run_result_values prrv,
8700: pay_balance_feeds_f pbf
8701: where paa.payroll_action_id = p_pact_id
8702: and prr.assignment_action_id = paa.assignment_action_id
8725: and pdb.balance_type_id in
8726: (select /*+ USE_NL(paa,prr,prrv,pbf) ORDERED */
8727: distinct pbf.balance_type_id
8728: from pay_assignment_actions paa,
8729: pay_run_results prr,
8730: pay_run_result_values prrv,
8731: pay_balance_feeds_f pbf
8732: where paa.payroll_action_id = p_pact_id
8733: and prr.assignment_action_id = paa.assignment_action_id
8766: and pdb.balance_type_id in
8767: (select /*+ USE_NL(paa,prr,prrv,pbf) ORDERED */
8768: distinct pbf.balance_type_id
8769: from pay_assignment_actions paa,
8770: pay_run_results prr,
8771: pay_run_result_values prrv,
8772: pay_balance_feeds_f pbf
8773: where paa.payroll_action_id = p_pact_id
8774: and prr.assignment_action_id = paa.assignment_action_id
8795: p_sn_needed in varchar2,
8796: p_st2_needed in varchar2,
8797: p_sn2_needed in varchar2,
8798: p_org_needed in varchar2) is
8799: select /*+ ORDERED USE_NL (prr) INDEX(prr pay_run_results_n50)*/
8800: distinct
8801: paa.tax_unit_id tax_unit_id
8802: , prr.jurisdiction_code jurisdiction_code
8803: , decode(p_si_needed,
8823: , prr.local_unit_id local_unit_id
8824: from pay_assignment_actions paa,
8825: pay_payroll_actions ppa,
8826: per_time_periods ptp,
8827: pay_run_results prr
8828: where paa.payroll_action_id = p_pact_id
8829: and paa.assignment_action_id = prr.assignment_action_id
8830: and ppa.payroll_action_id = paa.payroll_action_id
8831: and ppa.payroll_id = ptp.payroll_id
9228: p_sn2_needed in varchar2,
9229: p_org_needed in varchar2,
9230: p_earned_period_end_date in date) is
9231: -- bug 9368185 join to per_time_periods only for balance date context
9232: select /*+ ORDERED USE_NL(prr) INDEX(prr pay_run_results_n50)*/
9233: distinct
9234: decode(p_tu_needed,
9235: 'Y', paa.tax_unit_id,
9236: null) tax_unit_id
9265: 'Y', prr.local_unit_id,
9266: null) local_unit_id
9267: from pay_assignment_actions paa,
9268: pay_payroll_actions ppa,
9269: pay_run_results prr
9270: where paa.assignment_action_id = asgact
9271: and paa.assignment_action_id = prr.assignment_action_id
9272: and ppa.payroll_action_id = paa.payroll_action_id
9273: order by 1, 2, 3, 4;
9484: pbt.jurisdiction_level,
9485: pbt.balance_type_id,
9486: pbd.balance_dimension_id
9487: from
9488: pay_run_results prr,
9489: pay_run_result_values prrv,
9490: pay_balance_feeds_f pbf,
9491: pay_balance_types pbt,
9492: pay_defined_balances pdb,
9520: and prr.run_result_id = prrv.run_result_id
9521: and prrv.input_value_id = pbf.input_value_id
9522: and pbt.balance_type_id = pbf.balance_type_id;
9523: -- and exists (select /*+ ORDERED */ ''
9524: -- from pay_run_results prr,
9525: -- pay_run_result_values prrv,
9526: -- pay_balance_feeds_f pbf
9527: -- where prr.assignment_action_id = p_asg_act_id
9528: -- and prr.run_result_id = prrv.run_result_id
9551: and pdb.balance_dimension_id = pbd.balance_dimension_id
9552: and pbd.dimension_level = 'ASG'
9553: and p_def_bal_id = pba.defined_balance_id
9554: and exists (select /*+ ORDERED */ ''
9555: from pay_run_results prr,
9556: pay_run_result_values prrv
9557: where prr.assignment_action_id = p_asg_act_id
9558: and prr.run_result_id = prrv.run_result_id
9559: and exists ( select /*+ no_unnest */ ''
9582: and pbd.dimension_level = 'ASG'
9583: and pdb.balance_type_id in
9584: (select /*+ USE_NL(paa,prr,prrv,pbf) ORDERED */
9585: distinct pbf.balance_type_id
9586: from pay_run_results prr,
9587: pay_run_result_values prrv,
9588: pay_balance_feeds_f pbf
9589: where prr.assignment_action_id = p_asg_act_id
9590: and prr.run_result_id = prrv.run_result_id
9621: -- and pbv.balance_load_date > p_eff_date)
9622: -- and pdb.balance_type_id in
9623: -- (select /*+ USE_NL(paa,prr,prrv,pbf) ORDERED */
9624: -- distinct pbf.balance_type_id
9625: -- from pay_run_results prr,
9626: -- pay_run_result_values prrv,
9627: -- pay_balance_feeds_f pbf
9628: -- where prr.assignment_action_id = p_asg_act_id
9629: -- and prr.run_result_id = prrv.run_result_id
9651: pdb.defined_balance_id,
9652: pdb.balance_type_id,
9653: pdb.balance_dimension_id
9654: from
9655: pay_run_results prr,
9656: pay_input_values_f piv,
9657: pay_balance_feeds_f pbf,
9658: pay_defined_balances pdb,
9659: pay_balance_attributes pba,
9700: p_sn_needed in varchar2,
9701: p_st2_needed in varchar2,
9702: p_sn2_needed in varchar2,
9703: p_org_needed in varchar2) is
9704: select /*+ ORDERED USE_NL(prr) INDEX(prr pay_run_results_n50)*/
9705: distinct
9706: paa.tax_unit_id tax_unit_id
9707: , prr.jurisdiction_code jurisdiction_code
9708: , decode(p_si_needed,
9728: , prr.local_unit_id
9729: from pay_assignment_actions paa,
9730: pay_payroll_actions ppa,
9731: per_time_periods ptp,
9732: pay_run_results prr
9733: where paa.assignment_action_id = asgact
9734: and paa.assignment_action_id = prr.assignment_action_id
9735: and ppa.payroll_action_id = paa.payroll_action_id
9736: and ppa.payroll_id = ptp.payroll_id
10314: , prr.time_definition_id
10315: , nvl(prr.end_date, ptp.end_date) balance_date
10316: , prr.local_unit_id
10317: from pay_assignment_actions paa,
10318: pay_run_results prr,
10319: pay_payroll_actions ppa,
10320: per_time_periods ptp
10321: where ppa.payroll_action_id = p_pact_id
10322: and paa.payroll_action_id = ppa.payroll_action_id
11034: 'Y', pay_balance_pkg.find_context('ORGANIZATION_ID', prr.run_result_id),
11035: null) organization_id,
11036: ppa.effective_date
11037: from pay_assignment_actions paa,
11038: pay_run_results prr,
11039: pay_payroll_actions ppa
11040: where paa.assignment_action_id = revassactid
11041: and ppa.payroll_action_id = paa.payroll_action_id
11042: and paa.assignment_action_id = prr.assignment_action_id;
11427: p_from_date date )
11428: is
11429: select /*+ ORDERED INDEX(assact PAY_ASSIGNMENT_ACTIONS_N51)
11430: INDEX(pact PAY_PAYROLL_ACTIONS_PK)
11431: INDEX(rr PAY_RUN_RESULTS_N50)
11432: */
11433: assact.assignment_action_id,
11434: count(1) feed_count,
11435: nvl(sum(fnd_number.canonical_to_number(rrv.result_value) * p_scale), 0) value
11435: nvl(sum(fnd_number.canonical_to_number(rrv.result_value) * p_scale), 0) value
11436: from
11437: pay_assignment_actions assact,
11438: pay_payroll_actions pact,
11439: pay_run_results rr,
11440: pay_run_result_values rrv
11441: where assact.assignment_id = p_assignment_id
11442: --and assact.assignment_action_id in
11443: -- ( select assignment_action_id from pay_assignment_actions where assignment_id = p_assignment_id
11533: hr_utility.set_location('pay_balance_pkg.run_balance_row_status. classbal feed.cnt:'||g_feeds_tab.count, 26);
11534: end if;
11535: select /*+ ORDERED INDEX(assact PAY_ASSIGNMENT_ACTIONS_N51)
11536: INDEX(pact PAY_PAYROLL_ACTIONS_PK)
11537: INDEX(rr PAY_RUN_RESULTS_N50)
11538: */
11539: assact.assignment_action_id,
11540: count(1) feed_count,
11541: nvl(sum(fnd_number.canonical_to_number(rrv.result_value) * FEED.scale), 0) asg_run
11542: bulk collect into g_asg_actions_tab
11543: from
11544: pay_assignment_actions assact,
11545: pay_payroll_actions pact,
11546: pay_run_results rr,
11547: pay_run_result_values rrv,
11548: pay_balance_feeds_f feed
11549: where assact.assignment_id = g_assignment_id
11550: --and assact.assignment_action_id in
11727: select /*+ ORDERED
11728: INDEX(gen_assact PAY_ASSIGNMENT_ACTIONS_N50)
11729: INDEX(assact PAY_ASSIGNMENT_ACTIONS_N51)
11730: INDEX(pact PAY_PAYROLL_ACTIONS_PK)
11731: INDEX(rr PAY_RUN_RESULTS_N50)
11732: */
11733: assact.assignment_action_id,
11734: count(1) feed_count,
11735: nvl(sum(fnd_number.canonical_to_number(rrv.result_value) * p_scale), 0) value
11736: from
11737: pay_assignment_actions gen_assact,
11738: pay_assignment_actions assact,
11739: pay_payroll_actions pact,
11740: pay_run_results rr,
11741: pay_run_result_values rrv
11742: where gen_assact.payroll_action_id = p_generate_pact
11743: and gen_assact.chunk_number = p_chunk_number
11744: and assact.assignment_id = gen_assact.assignment_id
11837: select /*+ ORDERED
11838: INDEX(gen_assact PAY_ASSIGNMENT_ACTIONS_N50)
11839: INDEX(assact PAY_ASSIGNMENT_ACTIONS_N51)
11840: INDEX(pact PAY_PAYROLL_ACTIONS_PK)
11841: INDEX(rr PAY_RUN_RESULTS_N50)
11842: */
11843: assact.assignment_action_id,
11844: count(1) feed_count,
11845: nvl(sum(fnd_number.canonical_to_number(rrv.result_value) * FEED.scale), 0) asg_run
11847: from
11848: pay_assignment_actions gen_assact,
11849: pay_assignment_actions assact,
11850: pay_payroll_actions pact,
11851: pay_run_results rr,
11852: pay_run_result_values rrv,
11853: pay_balance_feeds_f feed
11854: where gen_assact.payroll_action_id = p_generate_pact
11855: and gen_assact.chunk_number = g_chunk_number