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 PAY_PAYROLL_ACTIONS

Line 297: l_bus_grp_id pay_payroll_actions.business_group_id%type;

293: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
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;

Line 317: pay_payroll_actions pact

313:
314: select rf.report_type,rf.report_format_mapping_id
315: into l_report_type,l_rep_id
316: from pay_report_format_mappings_f rf,
317: pay_payroll_actions pact
318: where pact.payroll_action_id=pactid
319: and rf.report_type =pact.report_type
320: and rf.report_qualifier=pact.report_qualifier
321: and rf.report_category=pact.report_category

Line 331: from pay_report_groups rg,pay_payroll_actions ppa

327: then
328:
329: select 'B',rg.thread_level,rg.legislation_code
330: into l_upg_level, l_thread_level, l_leg_code
331: from pay_report_groups rg,pay_payroll_actions ppa
332: where rg.report_format_mapping_id=l_rep_id
333: and pay_core_utils.get_parameter('REP_GROUP', ppa.legislative_parameters)=rg.short_name
334: and ppa.payroll_action_id=pactid;
335:

Line 345: from pay_payroll_actions ppa,

341: pbg.legislation_code
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: --

Line 396: pay_payroll_actions pa1

392: if sqlstr is null then
393: sqlstr := 'select distinct asg.person_id
394: from
395: per_all_assignments_f asg,
396: pay_payroll_actions pa1
397: where pa1.payroll_action_id = :payroll_action_id
398: and asg.business_group_id = pa1.business_group_id
399: order by asg.person_id';
400: end if;

Line 407: pay_payroll_actions pa1,

403: --
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

Line 421: pay_payroll_actions pa1

417: --
418: sqlstr := 'select distinct asg.person_id
419: from
420: per_all_assignments_f asg,
421: pay_payroll_actions pa1
422: where pa1.payroll_action_id = :payroll_action_id
423: order by asg.person_id';
424: --
425: else

Line 440: pay_payroll_actions pa1

436: --
437: sqlstr := 'select distinct pet.element_type_id
438: from
439: pay_element_types_f pet,
440: pay_payroll_actions pa1
441: where pa1.payroll_action_id = :payroll_action_id
442: and pet.business_group_id = pa1.business_group_id
443: order by pet.element_type_id';
444: --

Line 450: pay_payroll_actions pa1,

446: --
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

Line 465: pay_payroll_actions pa1

461: --
462: sqlstr := 'select distinct pet.element_type_id
463: from
464: pay_element_types_f pet,
465: pay_payroll_actions pa1
466: where pa1.payroll_action_id = :payroll_action_id
467: order by pet.element_type_id';
468: --
469: else

Line 603: pay_payroll_actions ppa

599: ) is
600: select /*+ INDEX(ppf PER_PEOPLE_F_PK)*/
601: distinct ppf.person_id
602: from per_all_people_f ppf,
603: pay_payroll_actions ppa
604: where ppa.payroll_action_id = cp_pactid
605: and ppa.business_group_id = ppf.business_group_id
606: and ppf.person_id between cp_stperson and cp_endperson;
607: --

Line 615: pay_payroll_actions ppa

611: ) is
612: select distinct paf.assignment_id
613: from
614: per_all_assignments_f paf,
615: pay_payroll_actions ppa
616: where ppa.payroll_action_id = cp_pactid
617: and ppa.business_group_id = paf.business_group_id
618: and paf.person_id between cp_stperson and cp_endperson;
619: --

Line 626: pay_payroll_actions ppa,

622: ) is
623: select distinct paf.assignment_id
624: from
625: per_all_assignments_f paf,
626: pay_payroll_actions ppa,
627: pay_population_ranges ppr
628: where ppr.chunk_number = c_chunk
629: and ppr.payroll_action_id = ppa.payroll_action_id
630: and ppa.payroll_action_id = cp_pactid

Line 641: pay_payroll_actions ppa

637: ) is
638: select distinct pet.element_type_id
639: from
640: pay_element_types_f pet,
641: pay_payroll_actions ppa
642: where ppa.payroll_action_id = cp_pactid
643: and ppa.business_group_id = pet.business_group_id
644: and pet.element_type_id between cp_stetid and cp_endetid;
645: --

Line 653: pay_payroll_actions ppa,

649: ) is
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

Line 669: pay_payroll_actions ppa,

665: ) is
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

Line 685: pay_payroll_actions ppa,

681: ) is
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

Line 741: pay_payroll_actions pact

737:
738: select rf.report_type, rf.report_format, rf.report_qualifier, rf.report_category, rf.report_format_mapping_id
739: into l_report_type, l_report_format, l_report_qualifier, l_report_category, l_rep_id
740: from pay_report_format_mappings_f rf,
741: pay_payroll_actions pact
742: where pact.payroll_action_id=p_pactid
743: and rf.report_type =pact.report_type
744: and rf.report_qualifier=pact.report_qualifier
745: and rf.report_category=pact.report_category

Line 757: from pay_report_groups rg,pay_payroll_actions ppa

753: rg.qualifying_procedure
754: into l_upg_level,
755: l_thread_level,
756: l_qual_proc
757: from pay_report_groups rg,pay_payroll_actions ppa
758: where rg.report_format_mapping_id=l_rep_id
759: and pay_core_utils.get_parameter('REP_GROUP', ppa.legislative_parameters)=rg.short_name
760: and ppa.payroll_action_id=p_pactid;
761:

Line 767: from pay_payroll_actions ppa

763: else
764: select pay_core_utils.get_parameter('UPG_DEF_NAME',
765: ppa.legislative_parameters)
766: into l_upg_def_nm
767: from pay_payroll_actions ppa
768: where payroll_action_id = p_pactid;
769: --
770: select upgrade_level,
771: threading_level,

Line 960: from pay_payroll_actions ppa,

956: ppa.legislative_parameters),
957: ptoa.object_id
958: into l_upg_def_nm,
959: object_id
960: from pay_payroll_actions ppa,
961: pay_temp_object_actions ptoa
962: where ppa.payroll_action_id = ptoa.payroll_action_id
963: and ptoa.object_action_id = p_assactid;
964: --

Line 1001: l_bus_grp_id pay_payroll_actions.business_group_id%type;

997: cnt_incomplete_actions number;
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

Line 1003: l_report_type pay_payroll_actions.report_type%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: --
1007:

Line 1020: from pay_payroll_actions ppa,

1016: l_remove_act,
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: --