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_GENERIC_UPGRADE dependencies on PER_BUSINESS_GROUPS

Line 211: from per_business_groups_perf

207: )
208: )
209: )
210: and not exists (select 1
211: from per_business_groups_perf
212: where legislation_code = p_legislation
213: and business_group_id <> p_business_group
214: )
215: and not exists (select 1 --Bug 7296843

Line 235: from per_business_groups_perf

231: from pay_upgrade_definitions pud
232: where pud.upgrade_level = 'G'
233: and nvl(pud.legislatively_enabled, 'N') = 'N'
234: and not exists (select 1
235: from per_business_groups_perf
236: where business_group_id <> p_business_group
237: );
238: begin
239: --

Line 298: l_leg_code per_business_groups.legislation_code%type;

294: l_upg_def_nm pay_upgrade_definitions.short_name%type;
295: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
296: l_upg_level pay_upgrade_definitions.upgrade_level%type;
297: l_bus_grp_id pay_payroll_actions.business_group_id%type;
298: l_leg_code per_business_groups.legislation_code%type;
299: l_thread_level pay_upgrade_definitions.threading_level%type;
300: l_report_type pay_report_format_mappings_f.report_type%type;
301: l_rep_id pay_report_format_mappings_f.report_format_mapping_id%type;
302: --

Line 346: per_business_groups_perf pbg

342: into l_upg_def_nm,
343: l_bus_grp_id,
344: l_leg_code
345: from pay_payroll_actions ppa,
346: per_business_groups_perf pbg
347: where ppa.payroll_action_id = pactid
348: and pbg.business_group_id = ppa.business_group_id;
349: --
350: select upgrade_level,

Line 408: per_business_groups_perf pbg1,

404: sqlstr := 'select distinct asg.person_id
405: from
406: per_all_assignments_f asg,
407: pay_payroll_actions pa1,
408: per_business_groups_perf pbg1,
409: per_business_groups_perf pbg
410: where pa1.payroll_action_id = :payroll_action_id
411: and pbg.business_group_id = pa1.business_group_id
412: and pbg1.legislation_code = pbg.legislation_code

Line 409: per_business_groups_perf pbg

405: from
406: per_all_assignments_f asg,
407: pay_payroll_actions pa1,
408: per_business_groups_perf pbg1,
409: per_business_groups_perf pbg
410: where pa1.payroll_action_id = :payroll_action_id
411: and pbg.business_group_id = pa1.business_group_id
412: and pbg1.legislation_code = pbg.legislation_code
413: and asg.business_group_id = pbg1.business_group_id

Line 451: per_business_groups_perf pbg1,

447: sqlstr := 'select distinct pet.element_type_id
448: from
449: pay_element_types_f pet,
450: pay_payroll_actions pa1,
451: per_business_groups_perf pbg1,
452: per_business_groups_perf pbg
453: where pa1.payroll_action_id = :payroll_action_id
454: and pbg.business_group_id = pa1.business_group_id
455: and pbg1.legislation_code = pbg.legislation_code

Line 452: per_business_groups_perf pbg

448: from
449: pay_element_types_f pet,
450: pay_payroll_actions pa1,
451: per_business_groups_perf pbg1,
452: per_business_groups_perf pbg
453: where pa1.payroll_action_id = :payroll_action_id
454: and pbg.business_group_id = pa1.business_group_id
455: and pbg1.legislation_code = pbg.legislation_code
456: and (pet.business_group_id = pbg1.business_group_id

Line 654: per_business_groups_perf pbg,

650: select /*+ INDEX(ppf PER_PEOPLE_F_PK)*/
651: distinct ppf.person_id
652: from per_all_people_f ppf,
653: pay_payroll_actions ppa,
654: per_business_groups_perf pbg,
655: per_business_groups_perf pbg1
656: where ppa.payroll_action_id = cp_pactid
657: and ppa.business_group_id = pbg.business_group_id
658: and pbg.legislation_code = pbg1.legislation_code

Line 655: per_business_groups_perf pbg1

651: distinct ppf.person_id
652: from per_all_people_f ppf,
653: pay_payroll_actions ppa,
654: per_business_groups_perf pbg,
655: per_business_groups_perf pbg1
656: where ppa.payroll_action_id = cp_pactid
657: and ppa.business_group_id = pbg.business_group_id
658: and pbg.legislation_code = pbg1.legislation_code
659: and pbg1.business_group_id = ppf.business_group_id

Line 670: per_business_groups_perf pbg,

666: select distinct paf.assignment_id
667: from
668: per_all_assignments_f paf,
669: pay_payroll_actions ppa,
670: per_business_groups_perf pbg,
671: per_business_groups_perf pbg1
672: where ppa.payroll_action_id = cp_pactid
673: and ppa.business_group_id = pbg.business_group_id
674: and pbg.legislation_code = pbg1.legislation_code

Line 671: per_business_groups_perf pbg1

667: from
668: per_all_assignments_f paf,
669: pay_payroll_actions ppa,
670: per_business_groups_perf pbg,
671: per_business_groups_perf pbg1
672: where ppa.payroll_action_id = cp_pactid
673: and ppa.business_group_id = pbg.business_group_id
674: and pbg.legislation_code = pbg1.legislation_code
675: and pbg1.business_group_id = paf.business_group_id

Line 686: per_business_groups_perf pbg,

682: select distinct pet.element_type_id
683: from
684: pay_element_types_f pet,
685: pay_payroll_actions ppa,
686: per_business_groups_perf pbg,
687: per_business_groups_perf pbg1
688: where ppa.payroll_action_id = cp_pactid
689: and ppa.business_group_id = pbg.business_group_id
690: and pbg.legislation_code = pbg1.legislation_code

Line 687: per_business_groups_perf pbg1

683: from
684: pay_element_types_f pet,
685: pay_payroll_actions ppa,
686: per_business_groups_perf pbg,
687: per_business_groups_perf pbg1
688: where ppa.payroll_action_id = cp_pactid
689: and ppa.business_group_id = pbg.business_group_id
690: and pbg.legislation_code = pbg1.legislation_code
691: and ( pbg1.business_group_id = pet.business_group_id

Line 1002: l_leg_code per_business_groups.legislation_code%type;

998: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
999: l_upg_def_nm pay_upgrade_definitions.short_name%type;
1000: l_upg_level pay_upgrade_definitions.upgrade_level%type;
1001: l_bus_grp_id pay_payroll_actions.business_group_id%type;
1002: l_leg_code per_business_groups.legislation_code%type;
1003: l_report_type pay_payroll_actions.report_type%type;
1004: --
1005: begin
1006: --

Line 1021: per_business_groups_perf pbg

1017: l_bus_grp_id,
1018: l_leg_code,
1019: l_report_type
1020: from pay_payroll_actions ppa,
1021: per_business_groups_perf pbg
1022: where ppa.payroll_action_id = pactid
1023: and pbg.business_group_id = ppa.business_group_id;
1024: --
1025: if l_report_type='GENERIC_REPORT'