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 209: from per_business_groups_perf

205: )
206: )
207: )
208: and not exists (select 1
209: from per_business_groups_perf
210: where legislation_code = p_legislation
211: and business_group_id <> p_business_group
212: );
213: cursor get_upg_def_glo (p_business_group in number)

Line 220: from per_business_groups_perf

216: from pay_upgrade_definitions pud
217: where pud.upgrade_level = 'G'
218: and nvl(pud.legislatively_enabled, 'N') = 'N'
219: and not exists (select 1
220: from per_business_groups_perf
221: where business_group_id <> p_business_group
222: );
223: begin
224: --

Line 283: l_leg_code per_business_groups.legislation_code%type;

279: l_upg_def_nm pay_upgrade_definitions.short_name%type;
280: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
281: l_upg_level pay_upgrade_definitions.upgrade_level%type;
282: l_bus_grp_id pay_payroll_actions.business_group_id%type;
283: l_leg_code per_business_groups.legislation_code%type;
284: l_thread_level pay_upgrade_definitions.threading_level%type;
285: l_report_type pay_report_format_mappings_f.report_type%type;
286: l_rep_id pay_report_format_mappings_f.report_format_mapping_id%type;
287: --

Line 325: per_business_groups_perf pbg

321: into l_upg_def_nm,
322: l_bus_grp_id,
323: l_leg_code
324: from pay_payroll_actions ppa,
325: per_business_groups_perf pbg
326: where ppa.payroll_action_id = pactid
327: and pbg.business_group_id = ppa.business_group_id;
328: --
329: select upgrade_level,

Line 357: per_business_groups_perf pbg1,

353: sqlstr := 'select distinct asg.person_id
354: from
355: per_all_assignments_f asg,
356: pay_payroll_actions pa1,
357: per_business_groups_perf pbg1,
358: per_business_groups_perf pbg
359: where pa1.payroll_action_id = :payroll_action_id
360: and pbg.business_group_id = pa1.business_group_id
361: and pbg1.legislation_code = pbg.legislation_code

Line 358: per_business_groups_perf pbg

354: from
355: per_all_assignments_f asg,
356: pay_payroll_actions pa1,
357: per_business_groups_perf pbg1,
358: per_business_groups_perf pbg
359: where pa1.payroll_action_id = :payroll_action_id
360: and pbg.business_group_id = pa1.business_group_id
361: and pbg1.legislation_code = pbg.legislation_code
362: and asg.business_group_id = pbg1.business_group_id

Line 400: per_business_groups_perf pbg1,

396: sqlstr := 'select distinct pet.element_type_id
397: from
398: pay_element_types_f pet,
399: pay_payroll_actions pa1,
400: per_business_groups_perf pbg1,
401: per_business_groups_perf pbg
402: where pa1.payroll_action_id = :payroll_action_id
403: and pbg.business_group_id = pa1.business_group_id
404: and pbg1.legislation_code = pbg.legislation_code

Line 401: per_business_groups_perf pbg

397: from
398: pay_element_types_f pet,
399: pay_payroll_actions pa1,
400: per_business_groups_perf pbg1,
401: per_business_groups_perf pbg
402: where pa1.payroll_action_id = :payroll_action_id
403: and pbg.business_group_id = pa1.business_group_id
404: and pbg1.legislation_code = pbg.legislation_code
405: and (pet.business_group_id = pbg1.business_group_id

Line 589: per_business_groups_perf pbg,

585: select /*+ INDEX(ppf PER_PEOPLE_F_PK)*/
586: distinct ppf.person_id
587: from per_all_people_f ppf,
588: pay_payroll_actions ppa,
589: per_business_groups_perf pbg,
590: per_business_groups_perf pbg1
591: where ppa.payroll_action_id = cp_pactid
592: and ppa.business_group_id = pbg.business_group_id
593: and pbg.legislation_code = pbg1.legislation_code

Line 590: per_business_groups_perf pbg1

586: distinct ppf.person_id
587: from per_all_people_f ppf,
588: pay_payroll_actions ppa,
589: per_business_groups_perf pbg,
590: per_business_groups_perf pbg1
591: where ppa.payroll_action_id = cp_pactid
592: and ppa.business_group_id = pbg.business_group_id
593: and pbg.legislation_code = pbg1.legislation_code
594: and pbg1.business_group_id = ppf.business_group_id

Line 605: per_business_groups_perf pbg,

601: select distinct paf.assignment_id
602: from
603: per_all_assignments_f paf,
604: pay_payroll_actions ppa,
605: per_business_groups_perf pbg,
606: per_business_groups_perf pbg1
607: where ppa.payroll_action_id = cp_pactid
608: and ppa.business_group_id = pbg.business_group_id
609: and pbg.legislation_code = pbg1.legislation_code

Line 606: per_business_groups_perf pbg1

602: from
603: per_all_assignments_f paf,
604: pay_payroll_actions ppa,
605: per_business_groups_perf pbg,
606: per_business_groups_perf pbg1
607: where ppa.payroll_action_id = cp_pactid
608: and ppa.business_group_id = pbg.business_group_id
609: and pbg.legislation_code = pbg1.legislation_code
610: and pbg1.business_group_id = paf.business_group_id

Line 621: per_business_groups_perf pbg,

617: select distinct pet.element_type_id
618: from
619: pay_element_types_f pet,
620: pay_payroll_actions ppa,
621: per_business_groups_perf pbg,
622: per_business_groups_perf pbg1
623: where ppa.payroll_action_id = cp_pactid
624: and ppa.business_group_id = pbg.business_group_id
625: and pbg.legislation_code = pbg1.legislation_code

Line 622: per_business_groups_perf pbg1

618: from
619: pay_element_types_f pet,
620: pay_payroll_actions ppa,
621: per_business_groups_perf pbg,
622: per_business_groups_perf pbg1
623: where ppa.payroll_action_id = cp_pactid
624: and ppa.business_group_id = pbg.business_group_id
625: and pbg.legislation_code = pbg1.legislation_code
626: and ( pbg1.business_group_id = pet.business_group_id

Line 915: l_leg_code per_business_groups.legislation_code%type;

911: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
912: l_upg_def_nm pay_upgrade_definitions.short_name%type;
913: l_upg_level pay_upgrade_definitions.upgrade_level%type;
914: l_bus_grp_id pay_payroll_actions.business_group_id%type;
915: l_leg_code per_business_groups.legislation_code%type;
916: l_report_type pay_payroll_actions.report_type%type;
917: --
918: begin
919: --

Line 934: per_business_groups_perf pbg

930: l_bus_grp_id,
931: l_leg_code,
932: l_report_type
933: from pay_payroll_actions ppa,
934: per_business_groups_perf pbg
935: where ppa.payroll_action_id = pactid
936: and pbg.business_group_id = ppa.business_group_id;
937: --
938: if l_report_type='GENERIC_REPORT'