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 PER_BUSINESS_GROUPS

Line 66: g_legislation_code per_business_groups_perf.legislation_code%type;

62: );
63: --
64: type t_context_map_tab is table of t_context_map_rec index by binary_integer;
65: --
66: g_legislation_code per_business_groups_perf.legislation_code%type;
67: g_context_mapping t_context_map_tab;
68: --
69: g_trace_count number := 0;
70: -- globals used in run_balance_row_status

Line 295: ,legislation_code per_business_groups.legislation_code%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
296: ,effective_date date
297: );
298: --
299: -- Cache parameters for new_defined_balance

Line 4640: l_business_group_id per_business_groups.business_group_id%type;

4636: p_balance_value out nocopy number,
4637: p_found out nocopy boolean)
4638: is
4639: --
4640: l_business_group_id per_business_groups.business_group_id%type;
4641: l_status pay_upgrade_status.status%type;
4642: begin
4643: --
4644: select ppa.business_group_id

Line 6529: per_business_groups_perf pbg

6525: ppa.effective_date
6526: ,pbg.legislation_code
6527: ,ppa.business_group_id
6528: from
6529: per_business_groups_perf pbg
6530: ,pay_payroll_actions ppa
6531: where
6532: pbg.business_group_id = ppa.business_group_id
6533: and ppa.payroll_action_id = p_payroll_action_id

Line 7104: per_business_groups_perf pbg

7100: --
7101: cursor get_bg (pactid number) is
7102: select pbg.business_group_id, pbg.legislation_code
7103: from pay_payroll_actions ppa,
7104: per_business_groups_perf pbg
7105: where payroll_action_id = pactid
7106: and pbg.business_group_id = ppa.business_group_id;
7107: --
7108: l_output_list t_detailed_bal_out_tab;

Line 7130: per_business_groups_perf pbg,

7126: begin
7127: select plr.rule_mode
7128: into g_save_run_bals
7129: from pay_legislation_rules plr,
7130: per_business_groups_perf pbg,
7131: pay_payroll_actions ppa
7132: where ppa.payroll_action_id = p_payroll_action_id
7133: and ppa.business_group_id = pbg.business_group_id
7134: and pbg.legislation_code = plr.legislation_code

Line 8106: per_business_groups_perf pbg

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;
8110: --

Line 8839: per_business_groups_perf pbg

8835: --
8836: cursor get_bg (p_pact_id number) is
8837: select pbg.business_group_id, pbg.legislation_code
8838: from pay_payroll_actions ppa,
8839: per_business_groups_perf pbg
8840: where ppa.payroll_action_id = p_pact_id
8841: and pbg.business_group_id = ppa.business_group_id;
8842: --
8843: l_defbal_rec t_def_bal_rec;

Line 8861: l_bg_id per_business_groups.business_group_id%type;

8857: l_output_list t_detailed_bal_out_tab;
8858: l_inp_val_name pay_input_values_f.name%type;
8859: l_found boolean;
8860: l_next_free number;
8861: l_bg_id per_business_groups.business_group_id%type;
8862: l_leg_code per_business_groups.legislation_code%type;
8863: l_eff_date date;
8864:
8865: /*Bug 9315998*/

Line 8862: l_leg_code per_business_groups.legislation_code%type;

8858: l_inp_val_name pay_input_values_f.name%type;
8859: l_found boolean;
8860: l_next_free number;
8861: l_bg_id per_business_groups.business_group_id%type;
8862: l_leg_code per_business_groups.legislation_code%type;
8863: l_eff_date date;
8864:
8865: /*Bug 9315998*/
8866: Type typ_crs_balatt_2_grp is table of crs_balatt_2%rowtype index by binary_integer;

Line 8882: from per_business_groups_perf pbg,

8878: ppa.effective_date
8879: into l_bg_id,
8880: l_leg_code,
8881: l_eff_date
8882: from per_business_groups_perf pbg,
8883: pay_payroll_actions ppa
8884: where ppa.payroll_action_id = p_pact_id
8885: and ppa.business_group_id = pbg.business_group_id;
8886: --

Line 9745: per_business_groups_perf pbg

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;
9749: --

Line 9768: l_bg_id per_business_groups.business_group_id%type;

9764: l_output_list t_detailed_bal_out_tab;
9765: l_inp_val_name pay_input_values_f.name%type;
9766: l_found boolean;
9767: l_next_free number;
9768: l_bg_id per_business_groups.business_group_id%type;
9769: l_leg_code per_business_groups.legislation_code%type;
9770:
9771: /*Bug 9315998*/
9772: Type typ_crs_balatt_2_asg is table of crs_balatt_2%rowtype index by binary_integer;

Line 9769: l_leg_code per_business_groups.legislation_code%type;

9765: l_inp_val_name pay_input_values_f.name%type;
9766: l_found boolean;
9767: l_next_free number;
9768: l_bg_id per_business_groups.business_group_id%type;
9769: l_leg_code per_business_groups.legislation_code%type;
9770:
9771: /*Bug 9315998*/
9772: Type typ_crs_balatt_2_asg is table of crs_balatt_2%rowtype index by binary_integer;
9773: lt_tab_crs_balatt_2_asg typ_crs_balatt_2_asg;

Line 9787: from per_business_groups_perf pbg,

9783: select pbg.business_group_id,
9784: pbg.legislation_code
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

Line 10121: per_business_groups_perf pbg

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'
10124: and pdb.balance_dimension_id = pbd.balance_dimension_id
10125: and paa.assignment_action_id = p_asg_act_id

Line 10144: per_business_groups_perf pbg,

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,
10147: pay_balance_dimensions pbd
10148: where pbd.dimension_level = 'ASG'

Line 10202: per_business_groups_perf pbg,

10198: begin
10199: select plr.rule_mode
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

Line 10341: per_business_groups_perf pbg

10337: --
10338: cursor get_bg (pactid number) is
10339: select pbg.business_group_id, pbg.legislation_code
10340: from pay_payroll_actions ppa,
10341: per_business_groups_perf pbg
10342: where payroll_action_id = pactid
10343: and pbg.business_group_id = ppa.business_group_id;
10344: --
10345: l_si_needed_chr varchar2(10);

Line 10585: per_business_groups_perf pbg

10581: select pdb.defined_balance_id
10582: from pay_defined_balances pdb,
10583: pay_balance_dimensions pbd,
10584: pay_payroll_actions ppa,
10585: per_business_groups_perf pbg
10586: where pbd.dimension_level = 'GRP'
10587: and pdb.save_run_balance = 'Y'
10588: and pdb.balance_dimension_id = pbd.balance_dimension_id
10589: and ppa.payroll_action_id = p_pact_id

Line 10606: per_business_groups_perf pbg,

10602: is
10603: select /*+ ORDERED */
10604: pdb.defined_balance_id
10605: from pay_payroll_actions ppa,
10606: per_business_groups_perf pbg,
10607: pay_balance_validation pbv,
10608: pay_defined_balances pdb,
10609: pay_balance_dimensions pbd
10610: where pbd.dimension_level = 'GRP'

Line 10662: per_business_groups_perf pbg,

10658: begin
10659: select plr.rule_mode
10660: into save_run_bals
10661: from pay_legislation_rules plr,
10662: per_business_groups_perf pbg,
10663: pay_payroll_actions ppa
10664: where ppa.payroll_action_id = p_pact_id
10665: and ppa.business_group_id = pbg.business_group_id
10666: and pbg.legislation_code = plr.legislation_code

Line 10769: from per_business_groups_perf

10765: --
10766: cursor get_leg_code(p_bg_id number)
10767: is
10768: select legislation_code
10769: from per_business_groups_perf
10770: where business_group_id = p_bg_id;
10771: --
10772: cursor enabled_bg(p_bg_id in number
10773: ,p_leg_code in varchar2

Line 10777: from per_business_groups_perf pbg

10773: ,p_leg_code in varchar2
10774: ,p_dim_level in varchar2)
10775: is
10776: select pbg.business_group_id
10777: from per_business_groups_perf pbg
10778: , pay_legislation_rules plr
10779: where pbg.legislation_code = plr.legislation_code
10780: and plr.legislation_code = nvl(p_leg_code, plr.legislation_code)
10781: and pbg.business_group_id = nvl(p_bg_id, pbg.business_group_id)

Line 10809: l_leg_code per_business_groups_perf.legislation_code%type;

10805: and pac.classification_name = 'SEQUENCED'
10806: and ppa.business_group_id = p_business_group_id;
10807: --
10808: l_dim_level pay_balance_dimensions.dimension_level%type;
10809: l_leg_code per_business_groups_perf.legislation_code%type;
10810: l_bg_id per_business_groups_perf.business_group_id%type;
10811: l_bal_load_date pay_balance_validation.balance_load_date%type;
10812: l_rr_exists number;
10813: --

Line 10810: l_bg_id per_business_groups_perf.business_group_id%type;

10806: and ppa.business_group_id = p_business_group_id;
10807: --
10808: l_dim_level pay_balance_dimensions.dimension_level%type;
10809: l_leg_code per_business_groups_perf.legislation_code%type;
10810: l_bg_id per_business_groups_perf.business_group_id%type;
10811: l_bal_load_date pay_balance_validation.balance_load_date%type;
10812: l_rr_exists number;
10813: --
10814: BEGIN

Line 11065: l_bus_grp per_business_groups_perf.business_group_id%type;

11061: l_iv_found boolean;
11062: l_num_found boolean;
11063: l_value pay_action_parameters.parameter_value%type;
11064: l_tax_group hr_organization_information.org_information5%type;
11065: l_bus_grp per_business_groups_perf.business_group_id%type;
11066: leg_code per_business_groups_perf.legislation_code%type;
11067: l_found boolean;
11068: cxt_id number;
11069:

Line 11066: leg_code per_business_groups_perf.legislation_code%type;

11062: l_num_found boolean;
11063: l_value pay_action_parameters.parameter_value%type;
11064: l_tax_group hr_organization_information.org_information5%type;
11065: l_bus_grp per_business_groups_perf.business_group_id%type;
11066: leg_code per_business_groups_perf.legislation_code%type;
11067: l_found boolean;
11068: cxt_id number;
11069:
11070: udca hrassact.context_details;

Line 11151: per_business_groups_perf pbg

11147: begin
11148: select rule_mode, pbg.legislation_code
11149: into l_rule_mode, leg_code
11150: from pay_legislation_rules plr,
11151: per_business_groups_perf pbg
11152: where plr.legislation_code = pbg.legislation_code
11153: and rule_type = 'BAL_ADJ_LAT_BAL'
11154: and pbg.business_group_id = l_bus_grp;
11155: