[Home] [Help]
142: type t_int_rb_rec is record
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,
254: g_low_volume pay_action_parameters.parameter_value%type := 'N';
255: --
256: -- tables for expiry_checking cache
257: --
258: type pay_act_id_tab is table of pay_payroll_actions.payroll_action_id%type
259: index by binary_integer;
260: type expiry_tab is table of NUMBER(38) index by binary_integer;
261: type dim_nm_tab is table of pay_balance_dimensions.dimension_name%type
262: index by binary_integer;
266: t_dim_nm dim_nm_tab;
267: t_expiry expiry_tab;
268: --
269: -- The following globals are used in remove_asg_contrib
270: g_payroll_action pay_payroll_actions.payroll_action_id%type;
271: g_rlb_grp_defbals t_balance_value_tab;
272: g_rlb_asg_defbals t_balance_value_tab;
273: g_grp_maintained_rb t_int_rb_cache;
274: g_grp_rb_ptr_list number_array;
281: g_save_run_bals pay_legislation_rules.rule_mode%type;
282: --
283: -- The following globals are used in get_rb_status
284: g_aa_id NUMBER := NULL;
285: g_retrieval_date pay_payroll_actions.effective_date%type := NULL;
286: g_bus_grp_id pay_payroll_actions.business_group_id%type := NULL;
287: g_payroll_id pay_payroll_actions.payroll_id%type := NULL;
288: g_action_type pay_payroll_actions.action_type%type := NULL;
289: --
282: --
283: -- The following globals are used in get_rb_status
284: g_aa_id NUMBER := NULL;
285: g_retrieval_date pay_payroll_actions.effective_date%type := NULL;
286: g_bus_grp_id pay_payroll_actions.business_group_id%type := NULL;
287: g_payroll_id pay_payroll_actions.payroll_id%type := NULL;
288: g_action_type pay_payroll_actions.action_type%type := NULL;
289: --
290: -- Run result record, used in get_run_result_info.
283: -- The following globals are used in get_rb_status
284: g_aa_id NUMBER := NULL;
285: g_retrieval_date pay_payroll_actions.effective_date%type := NULL;
286: g_bus_grp_id pay_payroll_actions.business_group_id%type := NULL;
287: g_payroll_id pay_payroll_actions.payroll_id%type := NULL;
288: g_action_type pay_payroll_actions.action_type%type := NULL;
289: --
290: -- Run result record, used in get_run_result_info.
291: g_run_result_rec t_run_result_rec;
284: g_aa_id NUMBER := NULL;
285: g_retrieval_date pay_payroll_actions.effective_date%type := NULL;
286: g_bus_grp_id pay_payroll_actions.business_group_id%type := NULL;
287: g_payroll_id pay_payroll_actions.payroll_id%type := NULL;
288: g_action_type pay_payroll_actions.action_type%type := NULL;
289: --
290: -- Run result record, used in get_run_result_info.
291: g_run_result_rec t_run_result_rec;
292: --
496: elsif (p_action_type in ('P', 'U')) then
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
643: elsif (p_action_type in ('P', 'U')) then
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
2940: is
2941: --
2942: l_run_bal_status pay_balance_validation.run_balance_status%type;
2943: l_load_date pay_balance_validation.balance_load_date%type;
2944: l_retrieval_date pay_payroll_actions.effective_date%type;
2945: l_bus_grp_id pay_payroll_actions.business_group_id%type;
2946: l_payroll_id pay_payroll_actions.payroll_id%type;
2947: l_period_type pay_balance_dimensions.period_type%type;
2948: l_start_date_code pay_balance_dimensions.start_date_code%type;
2941: --
2942: l_run_bal_status pay_balance_validation.run_balance_status%type;
2943: l_load_date pay_balance_validation.balance_load_date%type;
2944: l_retrieval_date pay_payroll_actions.effective_date%type;
2945: l_bus_grp_id pay_payroll_actions.business_group_id%type;
2946: l_payroll_id pay_payroll_actions.payroll_id%type;
2947: l_period_type pay_balance_dimensions.period_type%type;
2948: l_start_date_code pay_balance_dimensions.start_date_code%type;
2949: l_action_type pay_payroll_actions.action_type%type;
2942: l_run_bal_status pay_balance_validation.run_balance_status%type;
2943: l_load_date pay_balance_validation.balance_load_date%type;
2944: l_retrieval_date pay_payroll_actions.effective_date%type;
2945: l_bus_grp_id pay_payroll_actions.business_group_id%type;
2946: l_payroll_id pay_payroll_actions.payroll_id%type;
2947: l_period_type pay_balance_dimensions.period_type%type;
2948: l_start_date_code pay_balance_dimensions.start_date_code%type;
2949: l_action_type pay_payroll_actions.action_type%type;
2950: l_start_date date;
2945: l_bus_grp_id pay_payroll_actions.business_group_id%type;
2946: l_payroll_id pay_payroll_actions.payroll_id%type;
2947: l_period_type pay_balance_dimensions.period_type%type;
2948: l_start_date_code pay_balance_dimensions.start_date_code%type;
2949: l_action_type pay_payroll_actions.action_type%type;
2950: l_start_date date;
2951: --
2952: begin
2953: --
2961: into g_retrieval_date,
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:
3165: p_bal_context_str in varchar2 -- list of context values.
3166: ) return number is
3167: p_balance_expired number;
3168: --
3169: l_bal_owner_pay_action pay_payroll_actions.payroll_action_id%type;
3170: l_bal_owner_eff_date pay_payroll_actions.effective_date%type;
3171: l_payroll_action pay_payroll_actions.payroll_action_id%type;
3172: l_effective_date pay_payroll_actions.effective_date%type;
3173: l_jul_effect_date number; -- Julian value of effective date
3166: ) return number is
3167: p_balance_expired number;
3168: --
3169: l_bal_owner_pay_action pay_payroll_actions.payroll_action_id%type;
3170: l_bal_owner_eff_date pay_payroll_actions.effective_date%type;
3171: l_payroll_action pay_payroll_actions.payroll_action_id%type;
3172: l_effective_date pay_payroll_actions.effective_date%type;
3173: l_jul_effect_date number; -- Julian value of effective date
3174: l_expiry_chk_str varchar2(2000); -- used with dynamic pl/sql
3167: p_balance_expired number;
3168: --
3169: l_bal_owner_pay_action pay_payroll_actions.payroll_action_id%type;
3170: l_bal_owner_eff_date pay_payroll_actions.effective_date%type;
3171: l_payroll_action pay_payroll_actions.payroll_action_id%type;
3172: l_effective_date pay_payroll_actions.effective_date%type;
3173: l_jul_effect_date number; -- Julian value of effective date
3174: l_expiry_chk_str varchar2(2000); -- used with dynamic pl/sql
3175: l_expiry_information number;
3168: --
3169: l_bal_owner_pay_action pay_payroll_actions.payroll_action_id%type;
3170: l_bal_owner_eff_date pay_payroll_actions.effective_date%type;
3171: l_payroll_action pay_payroll_actions.payroll_action_id%type;
3172: l_effective_date pay_payroll_actions.effective_date%type;
3173: l_jul_effect_date number; -- Julian value of effective date
3174: l_expiry_chk_str varchar2(2000); -- used with dynamic pl/sql
3175: l_expiry_information number;
3176: sql_cursor integer;
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: --
3208: -- get the actual payroll information for this assignment action:
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: --
3222: -- before building up the sql string to call the expiry checking pl/sql
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
3551: and ASSIGN.assignment_id = ACT.assignment_id
3798: end if;
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
3831: end if;
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
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
4000: and ASSIGN.assignment_id = ACT.assignment_id
4105: end if;
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
4139: end if;
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
4345: begin
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: --
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: --
5526: begin
5582: end;
5583: --
5584: -- get the next value for payroll action id
5585: --
5586: select pay_payroll_actions_s.nextval
5587: into l_pay_action_id
5588: from dual;
5589: --
5590: -- insert a temporary row into pay_payroll_actions
5586: select pay_payroll_actions_s.nextval
5587: into l_pay_action_id
5588: from dual;
5589: --
5590: -- insert a temporary row into pay_payroll_actions
5591: --
5592: if g_debug then
5593: hr_utility.set_location ('pay_balance_pkg.get_value', 20);
5594: end if;
5591: --
5592: if g_debug then
5593: hr_utility.set_location ('pay_balance_pkg.get_value', 20);
5594: end if;
5595: insert into pay_payroll_actions
5596: (payroll_action_id,
5597: action_type,
5598: business_group_id,
5599: consolidation_set_id,
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
5678: AND ppa.effective_date <= c_effective_date
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))
5690: FROM pay_assignment_actions paa,
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
5695: paf1.assignment_id = c_assignment_id
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;
5743: l_found boolean;
5782: select ppa.effective_date,
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: --
6074: ,pbg.legislation_code
6075: ,ppa.business_group_id
6076: from
6077: per_business_groups_perf pbg
6078: ,pay_payroll_actions ppa
6079: where
6080: pbg.business_group_id = ppa.business_group_id
6081: and ppa.payroll_action_id = p_payroll_action_id
6082: ;
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
6600: and ppa.payroll_action_id = paa.payroll_action_id
6605: order by 1, 2, 3, 4;
6606: --
6607: cursor get_bg (pactid number) is
6608: select pbg.business_group_id, pbg.legislation_code
6609: from pay_payroll_actions ppa,
6610: per_business_groups_perf pbg
6611: where payroll_action_id = pactid
6612: and pbg.business_group_id = ppa.business_group_id;
6613: --
6633: select plr.rule_mode
6634: into g_save_run_bals
6635: from pay_legislation_rules plr,
6636: per_business_groups_perf pbg,
6637: pay_payroll_actions ppa
6638: where ppa.payroll_action_id = p_payroll_action_id
6639: and ppa.business_group_id = pbg.business_group_id
6640: and pbg.legislation_code = plr.legislation_code
6641: and plr.rule_type = 'SAVE_RUN_BAL';
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: --
6963: if g_debug then
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
7512: and paa.assignment_action_id = prr.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: --
7529: cursor get_bg (aaid number) is
7527: and paa.assignment_action_id = asgact;
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
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
7807: and paa.assignment_action_id = prr.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;
8189: --
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
8228: and paa.assignment_action_id = prr.assignment_action_id
8233: order by 1, 2, 3, 4;
8234: --
8235: cursor get_bg (p_pact_id number) is
8236: select pbg.business_group_id, pbg.legislation_code
8237: from pay_payroll_actions ppa,
8238: per_business_groups_perf pbg
8239: where ppa.payroll_action_id = p_pact_id
8240: and pbg.business_group_id = ppa.business_group_id;
8241: --
8273: into l_bg_id,
8274: l_leg_code,
8275: l_eff_date
8276: from per_business_groups_perf pbg,
8277: pay_payroll_actions ppa
8278: where ppa.payroll_action_id = p_pact_id
8279: and ppa.business_group_id = pbg.business_group_id;
8280: --
8281: l_next_free := 1;
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
8616: and paa.assignment_action_id = prr.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: --
9030: cursor get_contexts_2(asgact in number,
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
9067: and paa.assignment_action_id = prr.assignment_action_id
9072: order by 1, 2, 3, 4;
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
9111: pbg.legislation_code
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;
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'
9417: and pdb.balance_dimension_id = pbd.balance_dimension_id
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,
9440: pay_balance_dimensions pbd
9492: select plr.rule_mode
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
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
9615: and paa.payroll_action_id = ppa.payroll_action_id
9616: and paa.assignment_action_id = prr.assignment_action_id
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;
9630: --
9629: and rownum = 1;
9630: --
9631: cursor get_bg (pactid number) is
9632: select pbg.business_group_id, pbg.legislation_code
9633: from pay_payroll_actions ppa,
9634: per_business_groups_perf pbg
9635: where payroll_action_id = pactid
9636: and pbg.business_group_id = ppa.business_group_id;
9637: --
9859: is
9860: select pdb.defined_balance_id
9861: from pay_defined_balances pdb,
9862: pay_balance_dimensions pbd,
9863: pay_payroll_actions ppa,
9864: per_business_groups_perf pbg
9865: where pbd.dimension_level = 'GRP'
9866: and pdb.save_run_balance = 'Y'
9867: and pdb.balance_dimension_id = pbd.balance_dimension_id
9880: cursor crs_invalid (p_pact_id number)
9881: is
9882: select /*+ ORDERED */
9883: pdb.defined_balance_id
9884: from pay_payroll_actions ppa,
9885: per_business_groups_perf pbg,
9886: pay_balance_validation pbv,
9887: pay_defined_balances pdb,
9888: pay_balance_dimensions pbd
9938: select plr.rule_mode
9939: into save_run_bals
9940: from pay_legislation_rules plr,
9941: per_business_groups_perf pbg,
9942: pay_payroll_actions ppa
9943: where ppa.payroll_action_id = p_pact_id
9944: and ppa.business_group_id = pbg.business_group_id
9945: and pbg.legislation_code = plr.legislation_code
9946: and plr.rule_type = 'SAVE_RUN_BAL';
10077: --
10078: cursor bal_load_date(p_business_group_id number)
10079: is
10080: select nvl((max(ppa.effective_date)+1),fnd_date.canonical_to_date('0001/01/01')) bal_load_date
10081: from pay_payroll_actions ppa
10082: , pay_action_classifications pac
10083: where ppa.action_type = pac.action_type
10084: and pac.classification_name = 'SEQUENCED'
10085: and ppa.business_group_id = p_business_group_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
10321: and paa.assignment_action_id = prr.assignment_action_id;
10322: --
10330: l_inp_val_name pay_input_values_f.name%type;
10331: l_asg_id number;
10332: l_pactid number;
10333: l_eff_date date;
10334: l_act_type pay_payroll_actions.action_type%type;
10335: lat_bal_maintenance boolean;
10336: l_src_iv varchar2(30);
10337: l_src_num varchar2(30);
10338: l_src_num2 varchar2(30);
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: --
10372: create_all_asg_balances(p_asgact_id => p_asg_action,