APPS.PAY_GENERIC_UPGRADE dependencies on PAY_PAYROLL_ACTIONS

Line 282: l_bus_grp_id pay_payroll_actions.business_group_id%type;

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

Line 296: pay_payroll_actions pact

292:
293: select rf.report_type,rf.report_format_mapping_id
294: into l_report_type,l_rep_id
295: from pay_report_format_mappings_f rf,
296: pay_payroll_actions pact
297: where pact.payroll_action_id=pactid
298: and rf.report_type =pact.report_type
299: and rf.report_qualifier=pact.report_qualifier
300: and rf.report_category=pact.report_category

Line 310: from pay_report_groups rg,pay_payroll_actions ppa

306: then
307:
308: select 'B',rg.thread_level
309: into l_upg_level, l_thread_level
310: from pay_report_groups rg,pay_payroll_actions ppa
311: where rg.report_format_mapping_id=l_rep_id
312: and pay_core_utils.get_parameter('REP_GROUP', ppa.legislative_parameters)=rg.short_name
313: and ppa.payroll_action_id=pactid;
314:

Line 324: from pay_payroll_actions ppa,

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

Line 346: pay_payroll_actions pa1

342: --
343: sqlstr := 'select distinct asg.person_id
344: from
345: per_all_assignments_f asg,
346: pay_payroll_actions pa1
347: where pa1.payroll_action_id = :payroll_action_id
348: and asg.business_group_id = pa1.business_group_id
349: order by asg.person_id';
350: --

Line 356: pay_payroll_actions pa1,

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

Line 370: pay_payroll_actions pa1

366: --
367: sqlstr := 'select distinct asg.person_id
368: from
369: per_all_assignments_f asg,
370: pay_payroll_actions pa1
371: where pa1.payroll_action_id = :payroll_action_id
372: order by asg.person_id';
373: --
374: else

Line 389: pay_payroll_actions pa1

385: --
386: sqlstr := 'select distinct pet.element_type_id
387: from
388: pay_element_types_f pet,
389: pay_payroll_actions pa1
390: where pa1.payroll_action_id = :payroll_action_id
391: and pet.business_group_id = pa1.business_group_id
392: order by pet.element_type_id';
393: --

Line 399: pay_payroll_actions pa1,

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

Line 414: pay_payroll_actions pa1

410: --
411: sqlstr := 'select distinct pet.element_type_id
412: from
413: pay_element_types_f pet,
414: pay_payroll_actions pa1
415: where pa1.payroll_action_id = :payroll_action_id
416: order by pet.element_type_id';
417: --
418: else

Line 552: pay_payroll_actions ppa

548: ) is
549: select /*+ INDEX(ppf PER_PEOPLE_F_PK)*/
550: distinct ppf.person_id
551: from per_all_people_f ppf,
552: pay_payroll_actions ppa
553: where ppa.payroll_action_id = cp_pactid
554: and ppa.business_group_id = ppf.business_group_id
555: and ppf.person_id between cp_stperson and cp_endperson;
556: --

Line 564: pay_payroll_actions ppa

560: ) is
561: select distinct paf.assignment_id
562: from
563: per_all_assignments_f paf,
564: pay_payroll_actions ppa
565: where ppa.payroll_action_id = cp_pactid
566: and ppa.business_group_id = paf.business_group_id
567: and paf.person_id between cp_stperson and cp_endperson;
568: --

Line 576: pay_payroll_actions ppa

572: ) is
573: select distinct pet.element_type_id
574: from
575: pay_element_types_f pet,
576: pay_payroll_actions ppa
577: where ppa.payroll_action_id = cp_pactid
578: and ppa.business_group_id = pet.business_group_id
579: and pet.element_type_id between cp_stetid and cp_endetid;
580: --

Line 588: pay_payroll_actions ppa,

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

Line 604: pay_payroll_actions ppa,

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

Line 620: pay_payroll_actions ppa,

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

Line 672: pay_payroll_actions pact

668:
669: select rf.report_type,rf.report_format_mapping_id
670: into l_report_type,l_rep_id
671: from pay_report_format_mappings_f rf,
672: pay_payroll_actions pact
673: where pact.payroll_action_id=p_pactid
674: and rf.report_type =pact.report_type
675: and rf.report_qualifier=pact.report_qualifier
676: and rf.report_category=pact.report_category

Line 688: from pay_report_groups rg,pay_payroll_actions ppa

684: rg.qualifying_procedure
685: into l_upg_level,
686: l_thread_level,
687: l_qual_proc
688: from pay_report_groups rg,pay_payroll_actions ppa
689: where rg.report_format_mapping_id=l_rep_id
690: and pay_core_utils.get_parameter('REP_GROUP', ppa.legislative_parameters)=rg.short_name
691: and ppa.payroll_action_id=p_pactid;
692:

Line 698: from pay_payroll_actions ppa

694: else
695: select pay_core_utils.get_parameter('UPG_DEF_NAME',
696: ppa.legislative_parameters)
697: into l_upg_def_nm
698: from pay_payroll_actions ppa
699: where payroll_action_id = p_pactid;
700: --
701: select upgrade_level,
702: threading_level,

Line 873: from pay_payroll_actions ppa,

869: ppa.legislative_parameters),
870: ptoa.object_id
871: into l_upg_def_nm,
872: object_id
873: from pay_payroll_actions ppa,
874: pay_temp_object_actions ptoa
875: where ppa.payroll_action_id = ptoa.payroll_action_id
876: and ptoa.object_action_id = p_assactid;
877: --

Line 914: l_bus_grp_id pay_payroll_actions.business_group_id%type;

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

Line 916: l_report_type pay_payroll_actions.report_type%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: --
920:

Line 933: from pay_payroll_actions ppa,

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