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

Line 73: (assignment_action_id pay_assignment_actions.assignment_action_id%type,

69: g_trace_count number := 0;
70: -- globals used in run_balance_row_status
71: --
72: type t_asg_actions_rec is record
73: (assignment_action_id pay_assignment_actions.assignment_action_id%type,
74: feed_count number,
75: asg_run number
76: );
77: --

Line 81: g_assignment_id pay_assignment_actions.assignment_id%type;

77: --
78: type t_asg_actions_tab is table of t_asg_actions_rec index by binary_integer;
79: g_asg_actions_tab t_asg_actions_tab;
80: --
81: g_assignment_id pay_assignment_actions.assignment_id%type;
82: g_chunk_number pay_assignment_actions.chunk_number%type;
83: g_defined_balance_id pay_defined_balances.defined_balance_id%type;
84: g_balance_type_id pay_defined_balances.balance_type_id%type;
85: g_business_group_id per_all_assignments_f.business_group_id%type;

Line 82: g_chunk_number pay_assignment_actions.chunk_number%type;

78: type t_asg_actions_tab is table of t_asg_actions_rec index by binary_integer;
79: g_asg_actions_tab t_asg_actions_tab;
80: --
81: g_assignment_id pay_assignment_actions.assignment_id%type;
82: g_chunk_number pay_assignment_actions.chunk_number%type;
83: g_defined_balance_id pay_defined_balances.defined_balance_id%type;
84: g_balance_type_id pay_defined_balances.balance_type_id%type;
85: g_business_group_id per_all_assignments_f.business_group_id%type;
86:

Line 172: tax_unit_id pay_assignment_actions.tax_unit_id%type,

168: balance_type_id pay_balance_types.balance_type_id%type,
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,

Line 195: tax_unit_id pay_assignment_actions.tax_unit_id%type,

191: (
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,

Line 233: tax_unit_id pay_assignment_actions.tax_unit_id%type,

229: -- Context Details cache
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,

Line 244: prv_tax_unit_id pay_assignment_actions.tax_unit_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,
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,

Line 575: pay_assignment_actions paa,

571: --
572: select min(effective_date)
573: into l_return_date
574: from pay_payroll_actions ppa,
575: pay_assignment_actions paa,
576: pay_action_interlocks pai
577: where pai.locking_action_id = p_asg_action
578: and pai.locked_action_id = paa.assignment_action_id
579: and paa.payroll_action_id = ppa.payroll_action_id;

Line 738: pay_assignment_actions paa,

734: --
735: select max(effective_date)
736: into l_return_date
737: from pay_payroll_actions ppa,
738: pay_assignment_actions paa,
739: pay_action_interlocks pai
740: where pai.locking_action_id = p_asg_action
741: and pai.locked_action_id = paa.assignment_action_id
742: and paa.payroll_action_id = ppa.payroll_action_id;

Line 3243: pay_assignment_actions paa

3239: g_bus_grp_id,
3240: g_payroll_id,
3241: g_action_type
3242: from pay_payroll_actions ppa,
3243: pay_assignment_actions paa
3244: where paa.assignment_action_id = p_asg_action_id
3245: and paa.payroll_action_id = ppa.payroll_action_id;
3246:
3247: g_aa_id := p_asg_action_id;

Line 3481: from pay_assignment_actions ASG

3477: select PAY.payroll_action_id,
3478: PAY.effective_date
3479: into l_bal_owner_pay_action,
3480: l_bal_owner_eff_date
3481: from pay_assignment_actions ASG
3482: , pay_payroll_actions PAY
3483: where ASG.assignment_action_id = p_bal_owner_asg_action
3484: and PAY.payroll_action_id = ASG.payroll_action_id;
3485: --

Line 3495: from pay_assignment_actions ASG

3491: select PAY.payroll_action_id,
3492: PAY.effective_date
3493: into l_payroll_action,
3494: l_effective_date
3495: from pay_assignment_actions ASG
3496: , pay_payroll_actions PAY
3497: where ASG.assignment_action_id = p_assignment_action_id
3498: and PAY.payroll_action_id = ASG.payroll_action_id;
3499: --

Line 3822: , pay_assignment_actions ACT

3818: ASGBAL.expired_value,
3819: ASGBAL.prev_assignment_action_id,
3820: ASGBAL.prev_balance_value
3821: from pay_assignment_latest_balances ASGBAL
3822: , pay_assignment_actions ACT
3823: , pay_assignment_actions OWN_ACT
3824: where ASGBAL.defined_balance_id = p_defined_balance_id
3825: and ACT.assignment_action_id = p_assignment_action_id
3826: and ASGBAL.assignment_id = ACT.assignment_id

Line 3823: , pay_assignment_actions OWN_ACT

3819: ASGBAL.prev_assignment_action_id,
3820: ASGBAL.prev_balance_value
3821: from pay_assignment_latest_balances ASGBAL
3822: , pay_assignment_actions ACT
3823: , pay_assignment_actions OWN_ACT
3824: where ASGBAL.defined_balance_id = p_defined_balance_id
3825: and ACT.assignment_action_id = p_assignment_action_id
3826: and ASGBAL.assignment_id = ACT.assignment_id
3827: and OWN_ACT.assignment_action_id = ASGBAL.assignment_action_id

Line 3844: , pay_assignment_actions ACT

3840: PERBAL.prev_assignment_action_id,
3841: PERBAL.prev_balance_value
3842: from pay_person_latest_balances PERBAL
3843: , per_all_assignments_f ASSIGN
3844: , pay_assignment_actions ACT
3845: , pay_payroll_actions PACT
3846: , pay_assignment_actions OWN_ACT
3847: where PERBAL.defined_balance_id = p_defined_balance_id
3848: and ACT.assignment_action_id = p_assignment_action_id

Line 3846: , pay_assignment_actions OWN_ACT

3842: from pay_person_latest_balances PERBAL
3843: , per_all_assignments_f ASSIGN
3844: , pay_assignment_actions ACT
3845: , pay_payroll_actions PACT
3846: , pay_assignment_actions OWN_ACT
3847: where PERBAL.defined_balance_id = p_defined_balance_id
3848: and ACT.assignment_action_id = p_assignment_action_id
3849: and ASSIGN.assignment_id = ACT.assignment_id
3850: and PERBAL.person_id = ASSIGN.person_id

Line 3874: l_bal_owner_act_seq pay_assignment_actions.action_sequence%type;

3870: order by 1;
3871: --
3872: l_balance_value pay_person_latest_balances.value%type;
3873: l_bal_owner_asg_action pay_person_latest_balances.assignment_action_id%type;
3874: l_bal_owner_act_seq pay_assignment_actions.action_sequence%type;
3875: l_bal_asg_act_seq pay_assignment_actions.action_sequence%type;
3876: l_bal_expired_action
3877: pay_person_latest_balances.expired_assignment_action_id%type;
3878: l_bal_expired_value pay_person_latest_balances.expired_value%type;

Line 3875: l_bal_asg_act_seq pay_assignment_actions.action_sequence%type;

3871: --
3872: l_balance_value pay_person_latest_balances.value%type;
3873: l_bal_owner_asg_action pay_person_latest_balances.assignment_action_id%type;
3874: l_bal_owner_act_seq pay_assignment_actions.action_sequence%type;
3875: l_bal_asg_act_seq pay_assignment_actions.action_sequence%type;
3876: l_bal_expired_action
3877: pay_person_latest_balances.expired_assignment_action_id%type;
3878: l_bal_expired_value pay_person_latest_balances.expired_value%type;
3879: l_prev_action pay_person_latest_balances.prev_assignment_action_id%type;

Line 4101: pay_assignment_actions paa2,

4097: select count(*)
4098: into l_num_of_runs
4099: from
4100: pay_payroll_actions ppa2,
4101: pay_assignment_actions paa2,
4102: pay_assignment_actions paa
4103: where paa.assignment_action_id = l_bal_expired_action
4104: and paa2.assignment_id = paa.assignment_id
4105: and ppa2.payroll_action_id = paa2.payroll_action_id

Line 4102: pay_assignment_actions paa

4098: into l_num_of_runs
4099: from
4100: pay_payroll_actions ppa2,
4101: pay_assignment_actions paa2,
4102: pay_assignment_actions paa
4103: where paa.assignment_action_id = l_bal_expired_action
4104: and paa2.assignment_id = paa.assignment_id
4105: and ppa2.payroll_action_id = paa2.payroll_action_id
4106: and ppa2.action_type in ('R', 'Q', 'B', 'V')

Line 4134: pay_assignment_actions paa2,

4130: select count(*)
4131: into l_num_of_runs
4132: from
4133: pay_payroll_actions ppa2,
4134: pay_assignment_actions paa2,
4135: pay_assignment_actions paa
4136: where paa.assignment_action_id = l_prev_action
4137: and paa2.assignment_id = paa.assignment_id
4138: and ppa2.payroll_action_id = paa2.payroll_action_id

Line 4135: pay_assignment_actions paa

4131: into l_num_of_runs
4132: from
4133: pay_payroll_actions ppa2,
4134: pay_assignment_actions paa2,
4135: pay_assignment_actions paa
4136: where paa.assignment_action_id = l_prev_action
4137: and paa2.assignment_id = paa.assignment_id
4138: and ppa2.payroll_action_id = paa2.payroll_action_id
4139: and ppa2.action_type in ('R', 'Q', 'B', 'V')

Line 4293: , pay_assignment_actions ACT

4289: plb.organization_id,
4290: plb.source_number2
4291: from pay_latest_balances plb
4292: , per_all_assignments_f ASSIGN
4293: , pay_assignment_actions ACT
4294: , pay_payroll_actions PACT
4295: , pay_assignment_actions OWN_ACT
4296: where plb.defined_balance_id = p_defined_balance_id
4297: and ACT.assignment_action_id = p_assignment_action_id

Line 4295: , pay_assignment_actions OWN_ACT

4291: from pay_latest_balances plb
4292: , per_all_assignments_f ASSIGN
4293: , pay_assignment_actions ACT
4294: , pay_payroll_actions PACT
4295: , pay_assignment_actions OWN_ACT
4296: where plb.defined_balance_id = p_defined_balance_id
4297: and ACT.assignment_action_id = p_assignment_action_id
4298: and ASSIGN.assignment_id = ACT.assignment_id
4299: and (( plb.process_group_id is null ) or (

Line 4407: pay_assignment_actions paa2,

4403: select count(*)
4404: into l_num_of_runs
4405: from
4406: pay_payroll_actions ppa2,
4407: pay_assignment_actions paa2,
4408: pay_assignment_actions paa
4409: where paa.assignment_action_id = lbrec.expired_assignment_action_id
4410: and paa2.assignment_id = paa.assignment_id
4411: and ppa2.payroll_action_id = paa2.payroll_action_id

Line 4408: pay_assignment_actions paa

4404: into l_num_of_runs
4405: from
4406: pay_payroll_actions ppa2,
4407: pay_assignment_actions paa2,
4408: pay_assignment_actions paa
4409: where paa.assignment_action_id = lbrec.expired_assignment_action_id
4410: and paa2.assignment_id = paa.assignment_id
4411: and ppa2.payroll_action_id = paa2.payroll_action_id
4412: and ppa2.action_type in ('R', 'Q', 'B', 'V')

Line 4441: pay_assignment_actions paa2,

4437: select count(*)
4438: into l_num_of_runs
4439: from
4440: pay_payroll_actions ppa2,
4441: pay_assignment_actions paa2,
4442: pay_assignment_actions paa
4443: where paa.assignment_action_id = lbrec.prev_assignment_action_id
4444: and paa2.assignment_id = paa.assignment_id
4445: and ppa2.payroll_action_id = paa2.payroll_action_id

Line 4442: pay_assignment_actions paa

4438: into l_num_of_runs
4439: from
4440: pay_payroll_actions ppa2,
4441: pay_assignment_actions paa2,
4442: pay_assignment_actions paa
4443: where paa.assignment_action_id = lbrec.prev_assignment_action_id
4444: and paa2.assignment_id = paa.assignment_id
4445: and ppa2.payroll_action_id = paa2.payroll_action_id
4446: and ppa2.action_type in ('R', 'Q', 'B', 'V')

Line 4647: pay_assignment_actions paa

4643: --
4644: select ppa.business_group_id
4645: into l_business_group_id
4646: from pay_payroll_actions ppa,
4647: pay_assignment_actions paa
4648: where ppa.payroll_action_id = paa.payroll_action_id
4649: and paa.assignment_action_id = p_assignment_action_id;
4650: --
4651: pay_core_utils.get_upgrade_status(l_business_group_id,

Line 5823: l_ass_action_id pay_assignment_actions.assignment_action_id%type;

5819: --
5820: l_payroll_id per_all_assignments_f.payroll_id%type;
5821: l_bus_grp_id per_all_assignments_f.business_group_id%type;
5822: l_consol_set_id pay_all_payrolls_f.payroll_id%type;
5823: l_ass_action_id pay_assignment_actions.assignment_action_id%type;
5824: l_pay_action_id pay_payroll_actions.payroll_action_id%type;
5825: l_time_period_id per_time_periods.time_period_id%type;
5826: l_asg_lock boolean;
5827: --

Line 5938: from pay_assignment_actions

5934: hr_utility.set_location ('pay_balance_pkg.get_value', 30);
5935: end if;
5936: select assignment_action_id
5937: into l_ass_action_id
5938: from pay_assignment_actions
5939: where payroll_action_id = l_pay_action_id;
5940: --
5941: if g_debug then
5942: hr_utility.trace ('Assignment action id = ' || to_char (l_ass_action_id));

Line 5975: FROM pay_assignment_actions paa,

5971: SELECT /*+ ORDERED USE_NL(paa,ppa) */
5972: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'
5973: 0')||
5974: paa.assignment_action_id),16))
5975: FROM pay_assignment_actions paa,
5976: pay_payroll_actions ppa
5977: WHERE
5978: paa.assignment_id = c_assignment_id
5979: AND ppa.payroll_action_id = paa.payroll_action_id

Line 5988: FROM pay_assignment_actions paa,

5984: c_effective_date IN DATE) is
5985: SELECT /*+ INDEX(PPA PAY_PAYROLL_ACTIONS_PK) */
5986: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
5987: paa.assignment_action_id),16))
5988: FROM pay_assignment_actions paa,
5989: pay_payroll_actions ppa,
5990: (SELECT DISTINCT paf2.assignment_id
5991: FROM per_all_assignments_f paf1,
5992: per_all_assignments_f paf2

Line 6032: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

6028: p_defbal_rec in t_def_bal_rec,
6029: p_balance_value out nocopy number
6030: )
6031: is
6032: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
6033: l_pact_payroll_id pay_payroll_actions.payroll_action_id%type;
6034: l_pact_eff_date date;
6035: l_expiry_date date;
6036: l_balance_value number := null;

Line 6081: pay_assignment_actions paa

6077: ppa.payroll_id
6078: into l_pact_eff_date,
6079: l_pact_payroll_id
6080: from pay_payroll_actions ppa,
6081: pay_assignment_actions paa
6082: where paa.assignment_action_id = l_assignment_action_id
6083: and paa.payroll_action_id = ppa.payroll_action_id;
6084: --
6085: if (p_defbal_rec.period_type is not null

Line 6278: pay_assignment_actions assact

6274: where pbv.defined_balance_id = pdb.defined_balance_id
6275: and pbv.run_balance_status in ('P', 'V') )
6276: and exists ( select /*+ no_unnest */ 'x'
6277: from pay_run_balances rb,
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,

Line 6342: pay_assignment_actions assact

6338: where pbv.defined_balance_id = pdb.defined_balance_id
6339: and pbv.run_balance_status in ('P', 'V') )
6340: and exists ( select 'x'
6341: from pay_run_balances rb,
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,

Line 6515: pay_assignment_actions paa

6511: ,prr.time_definition_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

Line 7089: from pay_assignment_actions paa,

7085: , prr.time_definition_id
7086: , nvl(prr.end_date, ptp.end_date) balance_date
7087: , prr.local_unit_id local_unit_id
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

Line 7436: p_asgact_id in pay_assignment_actions.assignment_action_id%type,

7432: -- procedure ins_run_balance_bulk
7433: -- Inserts into pay_run_balances /* Added for bug 6676876 */
7434: --------------------------------------------------------------------------
7435: procedure ins_run_balance_bulk (p_output_list in t_detailed_bal_out_tab,
7436: p_asgact_id in pay_assignment_actions.assignment_action_id%type,
7437: p_pact_id in pay_assignment_actions.payroll_action_id%type,
7438: p_assignment_id in pay_assignment_actions.assignment_id%type,
7439: p_action_sequence in pay_assignment_actions.action_sequence%type,
7440: p_effective_date in pay_payroll_actions.effective_date%type

Line 7437: p_pact_id in pay_assignment_actions.payroll_action_id%type,

7433: -- Inserts into pay_run_balances /* Added for bug 6676876 */
7434: --------------------------------------------------------------------------
7435: procedure ins_run_balance_bulk (p_output_list in t_detailed_bal_out_tab,
7436: p_asgact_id in pay_assignment_actions.assignment_action_id%type,
7437: p_pact_id in pay_assignment_actions.payroll_action_id%type,
7438: p_assignment_id in pay_assignment_actions.assignment_id%type,
7439: p_action_sequence in pay_assignment_actions.action_sequence%type,
7440: p_effective_date in pay_payroll_actions.effective_date%type
7441: )

Line 7438: p_assignment_id in pay_assignment_actions.assignment_id%type,

7434: --------------------------------------------------------------------------
7435: procedure ins_run_balance_bulk (p_output_list in t_detailed_bal_out_tab,
7436: p_asgact_id in pay_assignment_actions.assignment_action_id%type,
7437: p_pact_id in pay_assignment_actions.payroll_action_id%type,
7438: p_assignment_id in pay_assignment_actions.assignment_id%type,
7439: p_action_sequence in pay_assignment_actions.action_sequence%type,
7440: p_effective_date in pay_payroll_actions.effective_date%type
7441: )
7442: is

Line 7439: p_action_sequence in pay_assignment_actions.action_sequence%type,

7435: procedure ins_run_balance_bulk (p_output_list in t_detailed_bal_out_tab,
7436: p_asgact_id in pay_assignment_actions.assignment_action_id%type,
7437: p_pact_id in pay_assignment_actions.payroll_action_id%type,
7438: p_assignment_id in pay_assignment_actions.assignment_id%type,
7439: p_action_sequence in pay_assignment_actions.action_sequence%type,
7440: p_effective_date in pay_payroll_actions.effective_date%type
7441: )
7442: is
7443:

Line 7525: from pay_assignment_actions

7521: --
7522: cursor get_aa_info(p_asg_act_id in number) is
7523: select assignment_id
7524: , action_sequence
7525: from pay_assignment_actions
7526: where assignment_action_id = p_asg_act_id;
7527: --
7528: bal_val number;
7529: l_tx_ut pay_assignment_actions.tax_unit_id%type;

Line 7529: l_tx_ut pay_assignment_actions.tax_unit_id%type;

7525: from pay_assignment_actions
7526: where assignment_action_id = p_asg_act_id;
7527: --
7528: bal_val number;
7529: l_tx_ut pay_assignment_actions.tax_unit_id%type;
7530: l_asg_id pay_assignment_actions.assignment_id%type;
7531: l_act_seq pay_assignment_actions.action_sequence%type;
7532: l_asgact_id pay_assignment_actions.assignment_action_id%type;
7533: l_pactid pay_payroll_actions.payroll_action_id%type;

Line 7530: l_asg_id pay_assignment_actions.assignment_id%type;

7526: where assignment_action_id = p_asg_act_id;
7527: --
7528: bal_val number;
7529: l_tx_ut pay_assignment_actions.tax_unit_id%type;
7530: l_asg_id pay_assignment_actions.assignment_id%type;
7531: l_act_seq pay_assignment_actions.action_sequence%type;
7532: l_asgact_id pay_assignment_actions.assignment_action_id%type;
7533: l_pactid pay_payroll_actions.payroll_action_id%type;
7534: begin

Line 7531: l_act_seq pay_assignment_actions.action_sequence%type;

7527: --
7528: bal_val number;
7529: l_tx_ut pay_assignment_actions.tax_unit_id%type;
7530: l_asg_id pay_assignment_actions.assignment_id%type;
7531: l_act_seq pay_assignment_actions.action_sequence%type;
7532: l_asgact_id pay_assignment_actions.assignment_action_id%type;
7533: l_pactid pay_payroll_actions.payroll_action_id%type;
7534: begin
7535: --

Line 7532: l_asgact_id pay_assignment_actions.assignment_action_id%type;

7528: bal_val number;
7529: l_tx_ut pay_assignment_actions.tax_unit_id%type;
7530: l_asg_id pay_assignment_actions.assignment_id%type;
7531: l_act_seq pay_assignment_actions.action_sequence%type;
7532: l_asgact_id pay_assignment_actions.assignment_action_id%type;
7533: l_pactid pay_payroll_actions.payroll_action_id%type;
7534: begin
7535: --
7536: --

Line 8080: from pay_assignment_actions paa,

8076: null) organization_id
8077: , prr.local_unit_id
8078: , prr.time_definition_id
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

Line 8097: from pay_assignment_actions paa,

8093: select paa.assignment_action_id,
8094: ppa.effective_date,
8095: paa.assignment_id,
8096: paa.action_sequence
8097: from pay_assignment_actions paa,
8098: pay_payroll_actions ppa
8099: where ppa.payroll_action_id = paa.payroll_action_id
8100: and paa.assignment_action_id = asgact;
8101: --

Line 8105: pay_assignment_actions paa,

8101: --
8102: cursor get_bg (aaid number) is
8103: select pbg.business_group_id, pbg.legislation_code
8104: from pay_payroll_actions ppa,
8105: pay_assignment_actions paa,
8106: per_business_groups_perf pbg
8107: where ppa.payroll_action_id = paa.payroll_action_id
8108: and paa.assignment_action_id = aaid
8109: and pbg.business_group_id = ppa.business_group_id;

Line 8392: from pay_assignment_actions paa,

8388: null) source_number2
8389: , decode(p_org_needed,
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

Line 8620: pay_assignment_actions paa,

8616: pbt.jurisdiction_level,
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,

Line 8697: from pay_assignment_actions paa,

8693: and pdb.balance_dimension_id = pbd.balance_dimension_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

Line 8728: from pay_assignment_actions paa,

8724: and pbd.dimension_level = 'GRP'
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

Line 8769: from pay_assignment_actions paa,

8765: and pbv.balance_load_date > p_eff_date)
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

Line 8785: from pay_assignment_actions paa,

8781: select paa.assignment_action_id,
8782: ppa.effective_date,
8783: paa.assignment_id,
8784: paa.action_sequence
8785: from pay_assignment_actions paa,
8786: pay_payroll_actions ppa
8787: where ppa.payroll_action_id = paa.payroll_action_id
8788: and ppa.payroll_action_id = p_pact_id
8789: and rownum = 1;

Line 8824: from pay_assignment_actions paa,

8820: null) organization_id
8821: , prr.time_definition_id
8822: , nvl(prr.end_date, ptp.end_date) balance_date
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

Line 9267: from pay_assignment_actions paa,

9263: null) balance_date
9264: , decode(p_lu_needed,
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

Line 9333: from pay_assignment_actions paa,

9329: end if;
9330: if (l_defbal_rec.bd_needed = TRUE) then
9331: l_bd_needed_chr := 'Y';
9332: select ptp.end_date into l_earned_period_end_date
9333: from pay_assignment_actions paa,
9334: pay_payroll_actions ppa,
9335: per_time_periods ptp
9336: where paa.assignment_action_id = p_asgact_id
9337: and ppa.payroll_action_id = paa.payroll_action_id

Line 9692: from pay_assignment_actions paa,

9688: select paa.assignment_action_id,
9689: ppa.effective_date,
9690: paa.assignment_id,
9691: paa.action_sequence
9692: from pay_assignment_actions paa,
9693: pay_payroll_actions ppa
9694: where ppa.payroll_action_id = paa.payroll_action_id
9695: and paa.assignment_action_id = asgact;
9696: --

Line 9729: from pay_assignment_actions paa,

9725: null) organization_id
9726: , prr.time_definition_id
9727: , nvl(prr.end_date, ptp.end_date) balance_date
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

Line 9744: pay_assignment_actions paa,

9740: --
9741: cursor get_bg (aaid number) is
9742: select pbg.business_group_id, pbg.legislation_code
9743: from pay_payroll_actions ppa,
9744: pay_assignment_actions paa,
9745: per_business_groups_perf pbg
9746: where ppa.payroll_action_id = paa.payroll_action_id
9747: and paa.assignment_action_id = aaid
9748: and pbg.business_group_id = ppa.business_group_id;

Line 9789: pay_assignment_actions paa

9785: into l_bg_id,
9786: l_leg_code
9787: from per_business_groups_perf pbg,
9788: pay_payroll_actions ppa,
9789: pay_assignment_actions paa
9790: where paa.assignment_action_id = p_asgact_id
9791: and ppa.payroll_action_id = paa.payroll_action_id
9792: and ppa.business_group_id = pbg.business_group_id;
9793: --

Line 10119: pay_assignment_actions paa,

10115: is
10116: select pdb.defined_balance_id
10117: from pay_defined_balances pdb,
10118: pay_balance_dimensions pbd,
10119: pay_assignment_actions paa,
10120: pay_payroll_actions ppa,
10121: per_business_groups_perf pbg
10122: where pbd.dimension_level = 'ASG'
10123: and pdb.save_run_balance = 'Y'

Line 10142: from pay_assignment_actions paa,

10138: cursor crs_invalid (p_asg_act_id number)
10139: is
10140: select /*+ ORDERED */
10141: pdb.defined_balance_id
10142: from pay_assignment_actions paa,
10143: pay_payroll_actions ppa,
10144: per_business_groups_perf pbg,
10145: pay_balance_validation pbv,
10146: pay_defined_balances pdb,

Line 10204: pay_assignment_actions paa

10200: into save_run_bals
10201: from pay_legislation_rules plr,
10202: per_business_groups_perf pbg,
10203: pay_payroll_actions ppa,
10204: pay_assignment_actions paa
10205: where ppa.payroll_action_id = paa.payroll_action_id
10206: and paa.assignment_action_id = p_asgact_id
10207: and ppa.business_group_id = pbg.business_group_id
10208: and pbg.legislation_code = plr.legislation_code

Line 10317: from pay_assignment_actions paa,

10313: null) organization_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

Line 10332: from pay_assignment_actions paa,

10328: --
10329: cursor get_aa (p_pact_id in number) is
10330: select paa.assignment_action_id,
10331: ppa.effective_date
10332: from pay_assignment_actions paa,
10333: pay_payroll_actions ppa
10334: where ppa.payroll_action_id = p_pact_id
10335: and ppa.payroll_action_id = paa.payroll_action_id
10336: and rownum = 1;

Line 11037: from pay_assignment_actions paa,

11033: decode(p_org_needed,
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

Line 11088: from pay_assignment_actions paa,

11084: l_eff_date,
11085: l_pactid,
11086: l_act_type,
11087: l_bus_grp
11088: from pay_assignment_actions paa,
11089: pay_payroll_actions ppa
11090: where paa.assignment_action_id = p_asg_action
11091: and ppa.payroll_action_id = paa.payroll_action_id;
11092: --

Line 11259: pay_assignment_actions paa

11255: if leg_code = 'US' then
11256: select hoi.org_information5
11257: into l_tax_group
11258: from hr_organization_information hoi,
11259: pay_assignment_actions paa
11260: where UPPER(hoi.org_information_context) = 'FEDERAL TAX RULES'
11261: and hoi.organization_id = paa.tax_unit_id
11262: and paa.assignment_action_id = p_asg_action
11263: and hoi.org_information5 is not null;

Line 11268: pay_assignment_actions paa

11264: else
11265: select hoi.org_information4
11266: into l_tax_group
11267: from hr_organization_information hoi,
11268: pay_assignment_actions paa
11269: where UPPER(hoi.org_information_context) = 'CANADA EMPLOYER IDENTIFICATION'
11270: and hoi.organization_id = paa.tax_unit_id
11271: and paa.assignment_action_id = p_asg_action
11272: and hoi.org_information4 is not null;

Line 11429: select /*+ ORDERED INDEX(assact PAY_ASSIGNMENT_ACTIONS_N51)

11425: p_effective_end_date date,
11426: p_assignment_id number,
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,

Line 11437: pay_assignment_actions assact,

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
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

Line 11443: -- ( select assignment_action_id from pay_assignment_actions where assignment_id = p_assignment_id

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
11444: -- minus select source_action_id from pay_assignment_actions where assignment_id = p_assignment_id)
11445: and pact.payroll_action_id = assact.payroll_action_id
11446: and pact.action_type in ('R', 'Q', 'V', 'B', 'I')
11447: and pact.effective_date >= nvl(p_from_date, pact.effective_date)

Line 11444: -- minus select source_action_id from pay_assignment_actions where assignment_id = p_assignment_id)

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
11444: -- minus select source_action_id from pay_assignment_actions where assignment_id = p_assignment_id)
11445: and pact.payroll_action_id = assact.payroll_action_id
11446: and pact.action_type in ('R', 'Q', 'V', 'B', 'I')
11447: and pact.effective_date >= nvl(p_from_date, pact.effective_date)
11448: and rr.assignment_action_id = assact.assignment_action_id

Line 11535: select /*+ ORDERED INDEX(assact PAY_ASSIGNMENT_ACTIONS_N51)

11531: else -- more than 4 feeds
11532: if g_debug then
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,

Line 11544: pay_assignment_actions assact,

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

Line 11551: -- ( select assignment_action_id from pay_assignment_actions where assignment_id = g_assignment_id

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
11551: -- ( select assignment_action_id from pay_assignment_actions where assignment_id = g_assignment_id
11552: -- minus select source_action_id from pay_assignment_actions where assignment_id = g_assignment_id)
11553: and pact.payroll_action_id = assact.payroll_action_id
11554: and pact.action_type in ('R', 'Q', 'V', 'B', 'I')
11555: and pact.effective_date >= nvl(p_from_date, pact.effective_date)

Line 11552: -- minus select source_action_id from pay_assignment_actions where assignment_id = g_assignment_id)

11548: pay_balance_feeds_f feed
11549: where assact.assignment_id = g_assignment_id
11550: --and assact.assignment_action_id in
11551: -- ( select assignment_action_id from pay_assignment_actions where assignment_id = g_assignment_id
11552: -- minus select source_action_id from pay_assignment_actions where assignment_id = g_assignment_id)
11553: and pact.payroll_action_id = assact.payroll_action_id
11554: and pact.action_type in ('R', 'Q', 'V', 'B', 'I')
11555: and pact.effective_date >= nvl(p_from_date, pact.effective_date)
11556: and rr.assignment_action_id = assact.assignment_action_id

Line 11728: INDEX(gen_assact PAY_ASSIGNMENT_ACTIONS_N50)

11724: p_chunk_number number,
11725: p_from_date date )
11726: is
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: */

Line 11729: INDEX(assact PAY_ASSIGNMENT_ACTIONS_N51)

11725: p_from_date date )
11726: is
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,

Line 11737: pay_assignment_actions gen_assact,

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

Line 11738: pay_assignment_actions assact,

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

Line 11838: INDEX(gen_assact PAY_ASSIGNMENT_ACTIONS_N50)

11834: if g_debug then
11835: hr_utility.set_location('pay_balance_pkg.run_balance_row_status. classbal feed.cnt:'||g_feeds_tab.count, 26);
11836: end if;
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: */

Line 11839: INDEX(assact PAY_ASSIGNMENT_ACTIONS_N51)

11835: hr_utility.set_location('pay_balance_pkg.run_balance_row_status. classbal feed.cnt:'||g_feeds_tab.count, 26);
11836: end if;
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,

Line 11848: pay_assignment_actions gen_assact,

11844: count(1) feed_count,
11845: nvl(sum(fnd_number.canonical_to_number(rrv.result_value) * FEED.scale), 0) asg_run
11846: bulk collect into g_asg_actions_tab
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,

Line 11849: pay_assignment_actions assact,

11845: nvl(sum(fnd_number.canonical_to_number(rrv.result_value) * FEED.scale), 0) asg_run
11846: bulk collect into g_asg_actions_tab
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