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

Line 578: l_business_group_id per_business_groups.business_group_id%TYPE;

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;

Line 579: l_legislation_code per_business_groups.legislation_code%TYPE;

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;

Line 593: , per_business_groups_perf bus

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;

Line 673: l_business_group_id per_business_groups.business_group_id%TYPE;

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;

Line 674: l_legislation_code per_business_groups.legislation_code%TYPE;

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;

Line 687: , per_business_groups_perf bus

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;

Line 788: l_business_group_id per_business_groups.business_group_id%TYPE;

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;

Line 789: l_legislation_code per_business_groups.legislation_code%TYPE;

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;

Line 802: , per_business_groups_perf bus

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;

Line 886: l_business_group_id per_business_groups.business_group_id%TYPE;

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;

Line 887: l_legislation_code per_business_groups.legislation_code%TYPE;

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;

Line 900: , per_business_groups_perf bus

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;