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_PERF

Line 58: g_legislation_code per_business_groups_perf.legislation_code%type;

54: );
55: --
56: type t_context_map_tab is table of t_context_map_rec index by binary_integer;
57: --
58: g_legislation_code per_business_groups_perf.legislation_code%type;
59: g_context_mapping t_context_map_tab;
60: --
61: -- tables for dimension cache
62: --

Line 6077: per_business_groups_perf pbg

6073: ppa.effective_date
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

Line 6610: per_business_groups_perf pbg

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: --
6614: l_output_list t_detailed_bal_out_tab;

Line 6636: per_business_groups_perf pbg,

6632: begin
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

Line 7533: per_business_groups_perf pbg

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

Line 8238: per_business_groups_perf pbg

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: --
8242: l_defbal_rec t_def_bal_rec;

Line 8276: from per_business_groups_perf pbg,

8272: ppa.effective_date
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: --

Line 9078: per_business_groups_perf pbg

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

Line 9114: from per_business_groups_perf pbg,

9110: select pbg.business_group_id,
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

Line 9414: per_business_groups_perf pbg

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
9418: and paa.assignment_action_id = p_asg_act_id

Line 9437: per_business_groups_perf pbg,

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
9441: where pbd.dimension_level = 'ASG'

Line 9495: per_business_groups_perf pbg,

9491: begin
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

Line 9634: per_business_groups_perf pbg

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: --
9638: l_si_needed_chr varchar2(10);

Line 9864: per_business_groups_perf pbg

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
9868: and ppa.payroll_action_id = p_pact_id

Line 9885: per_business_groups_perf pbg,

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
9889: where pbd.dimension_level = 'GRP'

Line 9941: per_business_groups_perf pbg,

9937: begin
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

Line 10048: from per_business_groups_perf

10044: --
10045: cursor get_leg_code(p_bg_id number)
10046: is
10047: select legislation_code
10048: from per_business_groups_perf
10049: where business_group_id = p_bg_id;
10050: --
10051: cursor enabled_bg(p_bg_id in number
10052: ,p_leg_code in varchar2

Line 10056: from per_business_groups_perf pbg

10052: ,p_leg_code in varchar2
10053: ,p_dim_level in varchar2)
10054: is
10055: select pbg.business_group_id
10056: from per_business_groups_perf pbg
10057: , pay_legislation_rules plr
10058: where pbg.legislation_code = plr.legislation_code
10059: and plr.legislation_code = nvl(p_leg_code, plr.legislation_code)
10060: and pbg.business_group_id = nvl(p_bg_id, pbg.business_group_id)

Line 10088: l_leg_code per_business_groups_perf.legislation_code%type;

10084: and pac.classification_name = 'SEQUENCED'
10085: and ppa.business_group_id = p_business_group_id;
10086: --
10087: l_dim_level pay_balance_dimensions.dimension_level%type;
10088: l_leg_code per_business_groups_perf.legislation_code%type;
10089: l_bg_id per_business_groups_perf.business_group_id%type;
10090: l_bal_load_date pay_balance_validation.balance_load_date%type;
10091: l_rr_exists number;
10092: --

Line 10089: l_bg_id per_business_groups_perf.business_group_id%type;

10085: and ppa.business_group_id = p_business_group_id;
10086: --
10087: l_dim_level pay_balance_dimensions.dimension_level%type;
10088: l_leg_code per_business_groups_perf.legislation_code%type;
10089: l_bg_id per_business_groups_perf.business_group_id%type;
10090: l_bal_load_date pay_balance_validation.balance_load_date%type;
10091: l_rr_exists number;
10092: --
10093: BEGIN

Line 10344: l_bus_grp per_business_groups_perf.business_group_id%type;

10340: l_iv_found boolean;
10341: l_num_found boolean;
10342: l_value pay_action_parameters.parameter_value%type;
10343: l_tax_group hr_organization_information.org_information5%type;
10344: l_bus_grp per_business_groups_perf.business_group_id%type;
10345: leg_code per_business_groups_perf.legislation_code%type;
10346: l_found boolean;
10347: cxt_id number;
10348:

Line 10345: leg_code per_business_groups_perf.legislation_code%type;

10341: l_num_found boolean;
10342: l_value pay_action_parameters.parameter_value%type;
10343: l_tax_group hr_organization_information.org_information5%type;
10344: l_bus_grp per_business_groups_perf.business_group_id%type;
10345: leg_code per_business_groups_perf.legislation_code%type;
10346: l_found boolean;
10347: cxt_id number;
10348:
10349: udca hrassact.context_details;

Line 10428: per_business_groups_perf pbg

10424: begin
10425: select rule_mode, pbg.legislation_code
10426: into l_rule_mode, leg_code
10427: from pay_legislation_rules plr,
10428: per_business_groups_perf pbg
10429: where plr.legislation_code = pbg.legislation_code
10430: and rule_type = 'BAL_ADJ_LAT_BAL'
10431: and pbg.business_group_id = l_bus_grp;
10432: