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 124: tax_unit_id pay_assignment_actions.tax_unit_id%type,

120: balance_type_id pay_balance_types.balance_type_id%type,
121: balance_found boolean,
122: balance_value number,
123: jurisdiction_level pay_balance_types.jurisdiction_level%type,
124: tax_unit_id pay_assignment_actions.tax_unit_id%type,
125: jurisdiction_code pay_run_results.jurisdiction_code%type,
126: source_id number,
127: source_text pay_run_result_values.result_value%type,
128: source_number number,

Line 147: tax_unit_id pay_assignment_actions.tax_unit_id%type,

143: (
144: run_balance_id pay_run_balances.run_balance_id%type,
145: defined_balance_id pay_defined_balances.defined_balance_id%type,
146: payroll_action_id pay_payroll_actions.payroll_action_id%type,
147: tax_unit_id pay_assignment_actions.tax_unit_id%type,
148: jurisdiction_code pay_run_results.jurisdiction_code%type,
149: source_id number,
150: source_text pay_run_result_values.result_value%type,
151: source_number number,

Line 185: tax_unit_id pay_assignment_actions.tax_unit_id%type,

181: -- Context Details cache
182: --
183: type t_context_details_rec is record
184: (
185: tax_unit_id pay_assignment_actions.tax_unit_id%type,
186: jurisdiction_code pay_run_results.jurisdiction_code%type,
187: source_id pay_run_result_values.result_value%type,
188: source_text pay_run_result_values.result_value%type,
189: source_number pay_run_result_values.result_value%type,

Line 196: prv_tax_unit_id pay_assignment_actions.tax_unit_id%type,

192: balance_date pay_run_results.end_date%type,
193: local_unit_id pay_run_results.local_unit_id%type,
194: source_number2 number,
195: organization_id number,
196: prv_tax_unit_id pay_assignment_actions.tax_unit_id%type,
197: prv_jurisdiction_code pay_run_results.jurisdiction_code%type,
198: prv_source_id pay_run_result_values.result_value%type,
199: prv_source_text pay_run_result_values.result_value%type,
200: prv_source_number pay_run_result_values.result_value%type,

Line 501: pay_assignment_actions paa,

497: --
498: select min(effective_date)
499: into l_return_date
500: from pay_payroll_actions ppa,
501: pay_assignment_actions paa,
502: pay_action_interlocks pai
503: where pai.locking_action_id = p_asg_action
504: and pai.locked_action_id = paa.assignment_action_id
505: and paa.payroll_action_id = ppa.payroll_action_id;

Line 648: pay_assignment_actions paa,

644: --
645: select max(effective_date)
646: into l_return_date
647: from pay_payroll_actions ppa,
648: pay_assignment_actions paa,
649: pay_action_interlocks pai
650: where pai.locking_action_id = p_asg_action
651: and pai.locked_action_id = paa.assignment_action_id
652: and paa.payroll_action_id = ppa.payroll_action_id;

Line 2966: pay_assignment_actions paa

2962: g_bus_grp_id,
2963: g_payroll_id,
2964: g_action_type
2965: from pay_payroll_actions ppa,
2966: pay_assignment_actions paa
2967: where paa.assignment_action_id = p_asg_action_id
2968: and paa.payroll_action_id = ppa.payroll_action_id;
2969:
2970: g_aa_id := p_asg_action_id;

Line 3203: from pay_assignment_actions ASG

3199: select PAY.payroll_action_id,
3200: PAY.effective_date
3201: into l_bal_owner_pay_action,
3202: l_bal_owner_eff_date
3203: from pay_assignment_actions ASG
3204: , pay_payroll_actions PAY
3205: where ASG.assignment_action_id = p_bal_owner_asg_action
3206: and PAY.payroll_action_id = ASG.payroll_action_id;
3207: --

Line 3217: from pay_assignment_actions ASG

3213: select PAY.payroll_action_id,
3214: PAY.effective_date
3215: into l_payroll_action,
3216: l_effective_date
3217: from pay_assignment_actions ASG
3218: , pay_payroll_actions PAY
3219: where ASG.assignment_action_id = p_assignment_action_id
3220: and PAY.payroll_action_id = ASG.payroll_action_id;
3221: --

Line 3524: , pay_assignment_actions ACT

3520: ASGBAL.expired_value,
3521: ASGBAL.prev_assignment_action_id,
3522: ASGBAL.prev_balance_value
3523: from pay_assignment_latest_balances ASGBAL
3524: , pay_assignment_actions ACT
3525: , pay_assignment_actions OWN_ACT
3526: where ASGBAL.defined_balance_id = p_defined_balance_id
3527: and ACT.assignment_action_id = p_assignment_action_id
3528: and ASGBAL.assignment_id = ACT.assignment_id

Line 3525: , pay_assignment_actions OWN_ACT

3521: ASGBAL.prev_assignment_action_id,
3522: ASGBAL.prev_balance_value
3523: from pay_assignment_latest_balances ASGBAL
3524: , pay_assignment_actions ACT
3525: , pay_assignment_actions OWN_ACT
3526: where ASGBAL.defined_balance_id = p_defined_balance_id
3527: and ACT.assignment_action_id = p_assignment_action_id
3528: and ASGBAL.assignment_id = ACT.assignment_id
3529: and OWN_ACT.assignment_action_id = ASGBAL.assignment_action_id

Line 3546: , pay_assignment_actions ACT

3542: PERBAL.prev_assignment_action_id,
3543: PERBAL.prev_balance_value
3544: from pay_person_latest_balances PERBAL
3545: , per_all_assignments_f ASSIGN
3546: , pay_assignment_actions ACT
3547: , pay_payroll_actions PACT
3548: , pay_assignment_actions OWN_ACT
3549: where PERBAL.defined_balance_id = p_defined_balance_id
3550: and ACT.assignment_action_id = p_assignment_action_id

Line 3548: , pay_assignment_actions OWN_ACT

3544: from pay_person_latest_balances PERBAL
3545: , per_all_assignments_f ASSIGN
3546: , pay_assignment_actions ACT
3547: , pay_payroll_actions PACT
3548: , pay_assignment_actions OWN_ACT
3549: where PERBAL.defined_balance_id = p_defined_balance_id
3550: and ACT.assignment_action_id = p_assignment_action_id
3551: and ASSIGN.assignment_id = ACT.assignment_id
3552: and PERBAL.person_id = ASSIGN.person_id

Line 3576: l_bal_owner_act_seq pay_assignment_actions.action_sequence%type;

3572: order by 1;
3573: --
3574: l_balance_value pay_person_latest_balances.value%type;
3575: l_bal_owner_asg_action pay_person_latest_balances.assignment_action_id%type;
3576: l_bal_owner_act_seq pay_assignment_actions.action_sequence%type;
3577: l_bal_asg_act_seq pay_assignment_actions.action_sequence%type;
3578: l_bal_expired_action
3579: pay_person_latest_balances.expired_assignment_action_id%type;
3580: l_bal_expired_value pay_person_latest_balances.expired_value%type;

Line 3577: l_bal_asg_act_seq pay_assignment_actions.action_sequence%type;

3573: --
3574: l_balance_value pay_person_latest_balances.value%type;
3575: l_bal_owner_asg_action pay_person_latest_balances.assignment_action_id%type;
3576: l_bal_owner_act_seq pay_assignment_actions.action_sequence%type;
3577: l_bal_asg_act_seq pay_assignment_actions.action_sequence%type;
3578: l_bal_expired_action
3579: pay_person_latest_balances.expired_assignment_action_id%type;
3580: l_bal_expired_value pay_person_latest_balances.expired_value%type;
3581: l_prev_action pay_person_latest_balances.prev_assignment_action_id%type;

Line 3803: pay_assignment_actions paa2,

3799: select count(*)
3800: into l_num_of_runs
3801: from
3802: pay_payroll_actions ppa2,
3803: pay_assignment_actions paa2,
3804: pay_assignment_actions paa
3805: where paa.assignment_action_id = l_bal_expired_action
3806: and paa2.assignment_id = paa.assignment_id
3807: and ppa2.payroll_action_id = paa2.payroll_action_id

Line 3804: pay_assignment_actions paa

3800: into l_num_of_runs
3801: from
3802: pay_payroll_actions ppa2,
3803: pay_assignment_actions paa2,
3804: pay_assignment_actions paa
3805: where paa.assignment_action_id = l_bal_expired_action
3806: and paa2.assignment_id = paa.assignment_id
3807: and ppa2.payroll_action_id = paa2.payroll_action_id
3808: and ppa2.action_type in ('R', 'Q', 'B', 'V')

Line 3836: pay_assignment_actions paa2,

3832: select count(*)
3833: into l_num_of_runs
3834: from
3835: pay_payroll_actions ppa2,
3836: pay_assignment_actions paa2,
3837: pay_assignment_actions paa
3838: where paa.assignment_action_id = l_prev_action
3839: and paa2.assignment_id = paa.assignment_id
3840: and ppa2.payroll_action_id = paa2.payroll_action_id

Line 3837: pay_assignment_actions paa

3833: into l_num_of_runs
3834: from
3835: pay_payroll_actions ppa2,
3836: pay_assignment_actions paa2,
3837: pay_assignment_actions paa
3838: where paa.assignment_action_id = l_prev_action
3839: and paa2.assignment_id = paa.assignment_id
3840: and ppa2.payroll_action_id = paa2.payroll_action_id
3841: and ppa2.action_type in ('R', 'Q', 'B', 'V')

Line 3995: , pay_assignment_actions ACT

3991: plb.organization_id,
3992: plb.source_number2
3993: from pay_latest_balances plb
3994: , per_all_assignments_f ASSIGN
3995: , pay_assignment_actions ACT
3996: , pay_payroll_actions PACT
3997: , pay_assignment_actions OWN_ACT
3998: where plb.defined_balance_id = p_defined_balance_id
3999: and ACT.assignment_action_id = p_assignment_action_id

Line 3997: , pay_assignment_actions OWN_ACT

3993: from pay_latest_balances plb
3994: , per_all_assignments_f ASSIGN
3995: , pay_assignment_actions ACT
3996: , pay_payroll_actions PACT
3997: , pay_assignment_actions OWN_ACT
3998: where plb.defined_balance_id = p_defined_balance_id
3999: and ACT.assignment_action_id = p_assignment_action_id
4000: and ASSIGN.assignment_id = ACT.assignment_id
4001: and exists (select ''

Line 4110: pay_assignment_actions paa2,

4106: select count(*)
4107: into l_num_of_runs
4108: from
4109: pay_payroll_actions ppa2,
4110: pay_assignment_actions paa2,
4111: pay_assignment_actions paa
4112: where paa.assignment_action_id = lbrec.expired_assignment_action_id
4113: and paa2.assignment_id = paa.assignment_id
4114: and ppa2.payroll_action_id = paa2.payroll_action_id

Line 4111: pay_assignment_actions paa

4107: into l_num_of_runs
4108: from
4109: pay_payroll_actions ppa2,
4110: pay_assignment_actions paa2,
4111: pay_assignment_actions paa
4112: where paa.assignment_action_id = lbrec.expired_assignment_action_id
4113: and paa2.assignment_id = paa.assignment_id
4114: and ppa2.payroll_action_id = paa2.payroll_action_id
4115: and ppa2.action_type in ('R', 'Q', 'B', 'V')

Line 4144: pay_assignment_actions paa2,

4140: select count(*)
4141: into l_num_of_runs
4142: from
4143: pay_payroll_actions ppa2,
4144: pay_assignment_actions paa2,
4145: pay_assignment_actions paa
4146: where paa.assignment_action_id = lbrec.prev_assignment_action_id
4147: and paa2.assignment_id = paa.assignment_id
4148: and ppa2.payroll_action_id = paa2.payroll_action_id

Line 4145: pay_assignment_actions paa

4141: into l_num_of_runs
4142: from
4143: pay_payroll_actions ppa2,
4144: pay_assignment_actions paa2,
4145: pay_assignment_actions paa
4146: where paa.assignment_action_id = lbrec.prev_assignment_action_id
4147: and paa2.assignment_id = paa.assignment_id
4148: and ppa2.payroll_action_id = paa2.payroll_action_id
4149: and ppa2.action_type in ('R', 'Q', 'B', 'V')

Line 4350: pay_assignment_actions paa

4346: --
4347: select ppa.business_group_id
4348: into l_business_group_id
4349: from pay_payroll_actions ppa,
4350: pay_assignment_actions paa
4351: where ppa.payroll_action_id = paa.payroll_action_id
4352: and paa.assignment_action_id = p_assignment_action_id;
4353: --
4354: pay_core_utils.get_upgrade_status(l_business_group_id,

Line 5521: l_ass_action_id pay_assignment_actions.assignment_action_id%type;

5517: --
5518: l_payroll_id per_all_assignments_f.payroll_id%type;
5519: l_bus_grp_id per_all_assignments_f.business_group_id%type;
5520: l_consol_set_id pay_all_payrolls_f.payroll_id%type;
5521: l_ass_action_id pay_assignment_actions.assignment_action_id%type;
5522: l_pay_action_id pay_payroll_actions.payroll_action_id%type;
5523: l_time_period_id per_time_periods.time_period_id%type;
5524: l_asg_lock boolean;
5525: --

Line 5636: from pay_assignment_actions

5632: hr_utility.set_location ('pay_balance_pkg.get_value', 30);
5633: end if;
5634: select assignment_action_id
5635: into l_ass_action_id
5636: from pay_assignment_actions
5637: where payroll_action_id = l_pay_action_id;
5638: --
5639: if g_debug then
5640: hr_utility.trace ('Assignment action id = ' || to_char (l_ass_action_id));

Line 5673: FROM pay_assignment_actions paa,

5669: SELECT /*+ USE_NL(paa, ppa) */
5670: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'
5671: 0')||
5672: paa.assignment_action_id),16))
5673: FROM pay_assignment_actions paa,
5674: pay_payroll_actions ppa
5675: WHERE
5676: paa.assignment_id = c_assignment_id
5677: AND ppa.payroll_action_id = paa.payroll_action_id

Line 5685: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51)

5681: cursor get_per_latest_id (c_assignment_id IN NUMBER,
5682: c_effective_date IN DATE) is
5683: SELECT /*+ INDEX(PAF1 PER_ASSIGNMENTS_F_PK)
5684: INDEX(PAF2 PER_ASSIGNMENTS_F_N12)
5685: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51)
5686: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
5687: USE_NL(paa, ppa) */
5688: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
5689: paa.assignment_action_id),16))

Line 5690: FROM pay_assignment_actions paa,

5686: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
5687: USE_NL(paa, ppa) */
5688: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
5689: paa.assignment_action_id),16))
5690: FROM pay_assignment_actions paa,
5691: pay_payroll_actions ppa,
5692: per_all_assignments_f paf1,
5693: per_all_assignments_f paf2
5694: WHERE

Line 5738: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

5734: p_defbal_rec in t_def_bal_rec,
5735: p_balance_value out nocopy number
5736: )
5737: is
5738: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
5739: l_pact_payroll_id pay_payroll_actions.payroll_action_id%type;
5740: l_pact_eff_date date;
5741: l_expiry_date date;
5742: l_balance_value number := null;

Line 5787: pay_assignment_actions paa

5783: ppa.payroll_id
5784: into l_pact_eff_date,
5785: l_pact_payroll_id
5786: from pay_payroll_actions ppa,
5787: pay_assignment_actions paa
5788: where paa.assignment_action_id = l_assignment_action_id
5789: and paa.payroll_action_id = ppa.payroll_action_id;
5790: --
5791: if (p_defbal_rec.period_type is not null

Line 6063: pay_assignment_actions paa

6059: ,prr.time_definition_id
6060: ,prr.end_date
6061: ,prr.local_unit_id
6062: from
6063: pay_assignment_actions paa
6064: ,pay_run_results prr
6065: where
6066: paa.assignment_action_id = prr.assignment_action_id
6067: and prr.run_result_id = p_run_result_id

Line 6595: from pay_assignment_actions paa,

6591: , prr.time_definition_id
6592: , nvl(prr.end_date, ptp.end_date) balance_date
6593: , prr.local_unit_id local_unit_id
6594: , ppa.effective_date
6595: from pay_assignment_actions paa,
6596: pay_payroll_actions ppa,
6597: per_time_periods ptp,
6598: pay_run_results prr
6599: where paa.assignment_action_id = p_asg_action

Line 6951: from pay_assignment_actions

6947: --
6948: cursor get_aa_info(p_asg_act_id in number) is
6949: select assignment_id
6950: , action_sequence
6951: from pay_assignment_actions
6952: where assignment_action_id = p_asg_act_id;
6953: --
6954: bal_val number;
6955: l_tx_ut pay_assignment_actions.tax_unit_id%type;

Line 6955: l_tx_ut pay_assignment_actions.tax_unit_id%type;

6951: from pay_assignment_actions
6952: where assignment_action_id = p_asg_act_id;
6953: --
6954: bal_val number;
6955: l_tx_ut pay_assignment_actions.tax_unit_id%type;
6956: l_asg_id pay_assignment_actions.assignment_id%type;
6957: l_act_seq pay_assignment_actions.action_sequence%type;
6958: l_asgact_id pay_assignment_actions.assignment_action_id%type;
6959: l_pactid pay_payroll_actions.payroll_action_id%type;

Line 6956: l_asg_id pay_assignment_actions.assignment_id%type;

6952: where assignment_action_id = p_asg_act_id;
6953: --
6954: bal_val number;
6955: l_tx_ut pay_assignment_actions.tax_unit_id%type;
6956: l_asg_id pay_assignment_actions.assignment_id%type;
6957: l_act_seq pay_assignment_actions.action_sequence%type;
6958: l_asgact_id pay_assignment_actions.assignment_action_id%type;
6959: l_pactid pay_payroll_actions.payroll_action_id%type;
6960: begin

Line 6957: l_act_seq pay_assignment_actions.action_sequence%type;

6953: --
6954: bal_val number;
6955: l_tx_ut pay_assignment_actions.tax_unit_id%type;
6956: l_asg_id pay_assignment_actions.assignment_id%type;
6957: l_act_seq pay_assignment_actions.action_sequence%type;
6958: l_asgact_id pay_assignment_actions.assignment_action_id%type;
6959: l_pactid pay_payroll_actions.payroll_action_id%type;
6960: begin
6961: --

Line 6958: l_asgact_id pay_assignment_actions.assignment_action_id%type;

6954: bal_val number;
6955: l_tx_ut pay_assignment_actions.tax_unit_id%type;
6956: l_asg_id pay_assignment_actions.assignment_id%type;
6957: l_act_seq pay_assignment_actions.action_sequence%type;
6958: l_asgact_id pay_assignment_actions.assignment_action_id%type;
6959: l_pactid pay_payroll_actions.payroll_action_id%type;
6960: begin
6961: --
6962: --

Line 7507: from pay_assignment_actions paa,

7503: null) organization_id
7504: , prr.local_unit_id
7505: , prr.time_definition_id
7506: , nvl(prr.end_date, ptp.end_date) balance_date
7507: from pay_assignment_actions paa,
7508: pay_payroll_actions ppa,
7509: per_time_periods ptp,
7510: pay_run_results prr
7511: where paa.assignment_action_id = asgact

Line 7524: from pay_assignment_actions paa,

7520: select paa.assignment_action_id,
7521: ppa.effective_date,
7522: paa.assignment_id,
7523: paa.action_sequence
7524: from pay_assignment_actions paa,
7525: pay_payroll_actions ppa
7526: where ppa.payroll_action_id = paa.payroll_action_id
7527: and paa.assignment_action_id = asgact;
7528: --

Line 7532: pay_assignment_actions paa,

7528: --
7529: cursor get_bg (aaid number) is
7530: select pbg.business_group_id, pbg.legislation_code
7531: from pay_payroll_actions ppa,
7532: pay_assignment_actions paa,
7533: per_business_groups_perf pbg
7534: where ppa.payroll_action_id = paa.payroll_action_id
7535: and paa.assignment_action_id = aaid
7536: and pbg.business_group_id = ppa.business_group_id;

Line 7802: from pay_assignment_actions paa,

7798: null) source_number2
7799: , decode(p_org_needed,
7800: 'Y', find_context('ORGANIZATION_ID', prr.run_result_id),
7801: null) organization_id
7802: from pay_assignment_actions paa,
7803: pay_payroll_actions ppa,
7804: per_time_periods ptp,
7805: pay_run_results prr
7806: where paa.payroll_action_id = p_pact_id

Line 8020: pay_assignment_actions paa,

8016: pbt.jurisdiction_level,
8017: pbt.balance_type_id,
8018: pbd.balance_dimension_id
8019: from
8020: pay_assignment_actions paa,
8021: pay_run_results prr,
8022: pay_input_values_f piv,
8023: pay_balance_feeds_f pbf,
8024: pay_balance_types pbt,

Line 8098: from pay_assignment_actions paa,

8094: and pdb.balance_dimension_id = pbd.balance_dimension_id
8095: and pbd.dimension_level = 'GRP'
8096: and p_def_bal_id = pba.defined_balance_id
8097: and exists (select /*+ ORDERED */ ''
8098: from pay_assignment_actions paa,
8099: pay_run_results prr,
8100: pay_run_result_values prrv,
8101: pay_balance_feeds_f pbf
8102: where paa.payroll_action_id = p_pact_id

Line 8127: from pay_assignment_actions paa,

8123: and p_def_bal_id is null
8124: and pdb.balance_type_id in
8125: (select /*+ USE_NL(paa,prr,prrv,pbf) ORDERED */
8126: distinct pbf.balance_type_id
8127: from pay_assignment_actions paa,
8128: pay_run_results prr,
8129: pay_run_result_values prrv,
8130: pay_balance_feeds_f pbf
8131: where paa.payroll_action_id = p_pact_id

Line 8168: from pay_assignment_actions paa,

8164: and pbv.balance_load_date > p_eff_date)
8165: and pdb.balance_type_id in
8166: (select /*+ USE_NL(paa,prr,prrv,pbf) ORDERED */
8167: distinct pbf.balance_type_id
8168: from pay_assignment_actions paa,
8169: pay_run_results prr,
8170: pay_run_result_values prrv,
8171: pay_balance_feeds_f pbf
8172: where paa.payroll_action_id = p_pact_id

Line 8184: from pay_assignment_actions paa,

8180: select paa.assignment_action_id,
8181: ppa.effective_date,
8182: paa.assignment_id,
8183: paa.action_sequence
8184: from pay_assignment_actions paa,
8185: pay_payroll_actions ppa
8186: where ppa.payroll_action_id = paa.payroll_action_id
8187: and ppa.payroll_action_id = p_pact_id
8188: and rownum = 1;

Line 8223: from pay_assignment_actions paa,

8219: null) organization_id
8220: , prr.time_definition_id
8221: , nvl(prr.end_date, ptp.end_date) balance_date
8222: , prr.local_unit_id local_unit_id
8223: from pay_assignment_actions paa,
8224: pay_payroll_actions ppa,
8225: per_time_periods ptp,
8226: pay_run_results prr
8227: where paa.payroll_action_id = p_pact_id

Line 8611: from pay_assignment_actions paa,

8607: null) balance_date
8608: , decode(p_lu_needed,
8609: 'Y', prr.local_unit_id,
8610: null) local_unit_id
8611: from pay_assignment_actions paa,
8612: pay_payroll_actions ppa,
8613: per_time_periods ptp,
8614: pay_run_results prr
8615: where paa.assignment_action_id = asgact

Line 9025: from pay_assignment_actions paa,

9021: select paa.assignment_action_id,
9022: ppa.effective_date,
9023: paa.assignment_id,
9024: paa.action_sequence
9025: from pay_assignment_actions paa,
9026: pay_payroll_actions ppa
9027: where ppa.payroll_action_id = paa.payroll_action_id
9028: and paa.assignment_action_id = asgact;
9029: --

Line 9062: from pay_assignment_actions paa,

9058: null) organization_id
9059: , prr.time_definition_id
9060: , nvl(prr.end_date, ptp.end_date) balance_date
9061: , prr.local_unit_id
9062: from pay_assignment_actions paa,
9063: pay_payroll_actions ppa,
9064: per_time_periods ptp,
9065: pay_run_results prr
9066: where paa.assignment_action_id = asgact

Line 9077: pay_assignment_actions paa,

9073: --
9074: cursor get_bg (aaid number) is
9075: select pbg.business_group_id, pbg.legislation_code
9076: from pay_payroll_actions ppa,
9077: pay_assignment_actions paa,
9078: per_business_groups_perf pbg
9079: where ppa.payroll_action_id = paa.payroll_action_id
9080: and paa.assignment_action_id = aaid
9081: and pbg.business_group_id = ppa.business_group_id;

Line 9116: pay_assignment_actions paa

9112: into l_bg_id,
9113: l_leg_code
9114: from per_business_groups_perf pbg,
9115: pay_payroll_actions ppa,
9116: pay_assignment_actions paa
9117: where paa.assignment_action_id = p_asgact_id
9118: and ppa.payroll_action_id = paa.payroll_action_id
9119: and ppa.business_group_id = pbg.business_group_id;
9120: --

Line 9412: pay_assignment_actions paa,

9408: is
9409: select pdb.defined_balance_id
9410: from pay_defined_balances pdb,
9411: pay_balance_dimensions pbd,
9412: pay_assignment_actions paa,
9413: pay_payroll_actions ppa,
9414: per_business_groups_perf pbg
9415: where pbd.dimension_level = 'ASG'
9416: and pdb.save_run_balance = 'Y'

Line 9435: from pay_assignment_actions paa,

9431: cursor crs_invalid (p_asg_act_id number)
9432: is
9433: select /*+ ORDERED */
9434: pdb.defined_balance_id
9435: from pay_assignment_actions paa,
9436: pay_payroll_actions ppa,
9437: per_business_groups_perf pbg,
9438: pay_balance_validation pbv,
9439: pay_defined_balances pdb,

Line 9497: pay_assignment_actions paa

9493: into save_run_bals
9494: from pay_legislation_rules plr,
9495: per_business_groups_perf pbg,
9496: pay_payroll_actions ppa,
9497: pay_assignment_actions paa
9498: where ppa.payroll_action_id = paa.payroll_action_id
9499: and paa.assignment_action_id = p_asgact_id
9500: and ppa.business_group_id = pbg.business_group_id
9501: and pbg.legislation_code = plr.legislation_code

Line 9610: from pay_assignment_actions paa,

9606: null) organization_id
9607: , prr.time_definition_id
9608: , nvl(prr.end_date, ptp.end_date) balance_date
9609: , prr.local_unit_id
9610: from pay_assignment_actions paa,
9611: pay_run_results prr,
9612: pay_payroll_actions ppa,
9613: per_time_periods ptp
9614: where ppa.payroll_action_id = p_pact_id

Line 9625: from pay_assignment_actions paa,

9621: --
9622: cursor get_aa (p_pact_id in number) is
9623: select paa.assignment_action_id,
9624: ppa.effective_date
9625: from pay_assignment_actions paa,
9626: pay_payroll_actions ppa
9627: where ppa.payroll_action_id = p_pact_id
9628: and ppa.payroll_action_id = paa.payroll_action_id
9629: and rownum = 1;

Line 10316: from pay_assignment_actions paa,

10312: decode(p_org_needed,
10313: 'Y', pay_balance_pkg.find_context('ORGANIZATION_ID', prr.run_result_id),
10314: null) organization_id,
10315: ppa.effective_date
10316: from pay_assignment_actions paa,
10317: pay_run_results prr,
10318: pay_payroll_actions ppa
10319: where paa.assignment_action_id = revassactid
10320: and ppa.payroll_action_id = paa.payroll_action_id

Line 10367: from pay_assignment_actions paa,

10363: l_eff_date,
10364: l_pactid,
10365: l_act_type,
10366: l_bus_grp
10367: from pay_assignment_actions paa,
10368: pay_payroll_actions ppa
10369: where paa.assignment_action_id = p_asg_action
10370: and ppa.payroll_action_id = paa.payroll_action_id;
10371: --

Line 10536: pay_assignment_actions paa

10532: if leg_code = 'US' then
10533: select hoi.org_information5
10534: into l_tax_group
10535: from hr_organization_information hoi,
10536: pay_assignment_actions paa
10537: where UPPER(hoi.org_information_context) = 'FEDERAL TAX RULES'
10538: and hoi.organization_id = paa.tax_unit_id
10539: and paa.assignment_action_id = p_asg_action
10540: and hoi.org_information5 is not null;

Line 10545: pay_assignment_actions paa

10541: else
10542: select hoi.org_information4
10543: into l_tax_group
10544: from hr_organization_information hoi,
10545: pay_assignment_actions paa
10546: where UPPER(hoi.org_information_context) = 'CANADA EMPLOYER IDENTIFICATION'
10547: and hoi.organization_id = paa.tax_unit_id
10548: and paa.assignment_action_id = p_asg_action
10549: and hoi.org_information4 is not null;