574: --
575: -- Declare cursors and local variables
576: --
577:
578: l_business_group_id per_business_groups.business_group_id%TYPE;
579: l_legislation_code per_business_groups.legislation_code%TYPE;
580: l_leg_code pay_user_column_instances_f.legislation_code%TYPE;
581: l_income_reduction ff_globals_f.global_value%type;
582: l_effective_date date;
575: -- Declare cursors and local variables
576: --
577:
578: l_business_group_id per_business_groups.business_group_id%TYPE;
579: l_legislation_code per_business_groups.legislation_code%TYPE;
580: l_leg_code pay_user_column_instances_f.legislation_code%TYPE;
581: l_income_reduction ff_globals_f.global_value%type;
582: l_effective_date date;
583: l_effective_start_date date;
589: cursor csr_get_derived_details is
590: select bus.business_group_id
591: , bus.legislation_code
592: from per_all_assignments_f paf
593: , per_business_groups_perf bus
594: where paf.assignment_id = p_assignment_id
595: and l_effective_date between paf.effective_start_date
596: and paf.effective_end_date
597: and bus.business_group_id = paf.business_group_id;
669: --
670: -- Declare cursors and local variables
671: --
672:
673: l_business_group_id per_business_groups.business_group_id%TYPE;
674: l_legislation_code per_business_groups.legislation_code%TYPE;
675: l_leg_code pay_user_column_instances_f.legislation_code%TYPE;
676: l_effective_date date;
677: l_effective_start_date date;
670: -- Declare cursors and local variables
671: --
672:
673: l_business_group_id per_business_groups.business_group_id%TYPE;
674: l_legislation_code per_business_groups.legislation_code%TYPE;
675: l_leg_code pay_user_column_instances_f.legislation_code%TYPE;
676: l_effective_date date;
677: l_effective_start_date date;
678: l_effective_end_date date;
683: cursor csr_get_derived_details is
684: select bus.business_group_id
685: , bus.legislation_code
686: from per_all_assignments_f paf
687: , per_business_groups_perf bus
688: where paf.assignment_id = p_assignment_id
689: and l_effective_date between paf.effective_start_date
690: and paf.effective_end_date
691: and bus.business_group_id = paf.business_group_id;
784: --
785: -- Declare cursors and local variables
786: --
787:
788: l_business_group_id per_business_groups.business_group_id%TYPE;
789: l_legislation_code per_business_groups.legislation_code%TYPE;
790: l_leg_code pay_user_column_instances_f.legislation_code%TYPE;
791: l_effective_date date;
792: l_effective_start_date date;
785: -- Declare cursors and local variables
786: --
787:
788: l_business_group_id per_business_groups.business_group_id%TYPE;
789: l_legislation_code per_business_groups.legislation_code%TYPE;
790: l_leg_code pay_user_column_instances_f.legislation_code%TYPE;
791: l_effective_date date;
792: l_effective_start_date date;
793: l_effective_end_date date;
798: cursor csr_get_derived_details is
799: select bus.business_group_id
800: , bus.legislation_code
801: from per_all_assignments_f paf
802: , per_business_groups_perf bus
803: where paf.assignment_id = p_assignment_id
804: and l_effective_date between paf.effective_start_date
805: and paf.effective_end_date
806: and bus.business_group_id = paf.business_group_id;
882: --
883: -- Declare cursors and local variables
884: --
885:
886: l_business_group_id per_business_groups.business_group_id%TYPE;
887: l_legislation_code per_business_groups.legislation_code%TYPE;
888: l_leg_code pay_user_column_instances_f.legislation_code%TYPE;
889: l_effective_date date;
890: l_effective_start_date date;
883: -- Declare cursors and local variables
884: --
885:
886: l_business_group_id per_business_groups.business_group_id%TYPE;
887: l_legislation_code per_business_groups.legislation_code%TYPE;
888: l_leg_code pay_user_column_instances_f.legislation_code%TYPE;
889: l_effective_date date;
890: l_effective_start_date date;
891: l_effective_end_date date;
896: cursor csr_get_derived_details is
897: select bus.business_group_id
898: , bus.legislation_code
899: from per_all_people_f papf
900: , per_business_groups_perf bus
901: where papf.person_id = p_person_id
902: and l_effective_date between papf.effective_start_date
903: and papf.effective_end_date
904: and bus.business_group_id = papf.business_group_id;