APPS.GHR_API dependencies on PER_JOBS

Line 645: from per_jobs job, per_job_definitions jdf

641:
642: --
643: cursor c_job_seg1 (p_job_id number) is
644: select jdf.segment1
645: from per_jobs job, per_job_definitions jdf
646: where job.job_definition_id = jdf.job_definition_id
647: and job.job_id = p_job_id;
648: --
649: cursor c_job_seg2 (p_job_id number) is

Line 651: from per_jobs job, per_job_definitions jdf

647: and job.job_id = p_job_id;
648: --
649: cursor c_job_seg2 (p_job_id number) is
650: select jdf.segment2
651: from per_jobs job, per_job_definitions jdf
652: where job.job_definition_id = jdf.job_definition_id
653: and job.job_id = p_job_id;
654: --
655: cursor c_job_seg3 (p_job_id number) is

Line 657: from per_jobs job, per_job_definitions jdf

653: and job.job_id = p_job_id;
654: --
655: cursor c_job_seg3 (p_job_id number) is
656: select jdf.segment3
657: from per_jobs job, per_job_definitions jdf
658: where job.job_definition_id = jdf.job_definition_id
659: and job.job_id = p_job_id;
660: --
661: cursor c_job_seg4 (p_job_id number) is

Line 663: from per_jobs job, per_job_definitions jdf

659: and job.job_id = p_job_id;
660: --
661: cursor c_job_seg4 (p_job_id number) is
662: select jdf.segment4
663: from per_jobs job, per_job_definitions jdf
664: where job.job_definition_id = jdf.job_definition_id
665: and job.job_id = p_job_id;
666: --
667: cursor c_job_seg5 (p_job_id number) is

Line 669: from per_jobs job, per_job_definitions jdf

665: and job.job_id = p_job_id;
666: --
667: cursor c_job_seg5 (p_job_id number) is
668: select jdf.segment5
669: from per_jobs job, per_job_definitions jdf
670: where job.job_definition_id = jdf.job_definition_id
671: and job.job_id = p_job_id;
672: --
673: cursor c_job_seg6 (p_job_id number) is

Line 675: from per_jobs job, per_job_definitions jdf

671: and job.job_id = p_job_id;
672: --
673: cursor c_job_seg6 (p_job_id number) is
674: select jdf.segment6
675: from per_jobs job, per_job_definitions jdf
676: where job.job_definition_id = jdf.job_definition_id
677: and job.job_id = p_job_id;
678: --
679: cursor c_job_seg7 (p_job_id number) is

Line 681: from per_jobs job, per_job_definitions jdf

677: and job.job_id = p_job_id;
678: --
679: cursor c_job_seg7 (p_job_id number) is
680: select jdf.segment7
681: from per_jobs job, per_job_definitions jdf
682: where job.job_definition_id = jdf.job_definition_id
683: and job.job_id = p_job_id;
684: --
685: cursor c_job_seg8 (p_job_id number) is

Line 687: from per_jobs job, per_job_definitions jdf

683: and job.job_id = p_job_id;
684: --
685: cursor c_job_seg8 (p_job_id number) is
686: select jdf.segment8
687: from per_jobs job, per_job_definitions jdf
688: where job.job_definition_id = jdf.job_definition_id
689: and job.job_id = p_job_id;
690: --
691: cursor c_job_seg9 (p_job_id number) is

Line 693: from per_jobs job, per_job_definitions jdf

689: and job.job_id = p_job_id;
690: --
691: cursor c_job_seg9 (p_job_id number) is
692: select jdf.segment9
693: from per_jobs job, per_job_definitions jdf
694: where job.job_definition_id = jdf.job_definition_id
695: and job.job_id = p_job_id;
696: --
697: cursor c_job_seg10 (p_job_id number) is

Line 699: from per_jobs job, per_job_definitions jdf

695: and job.job_id = p_job_id;
696: --
697: cursor c_job_seg10 (p_job_id number) is
698: select jdf.segment10
699: from per_jobs job, per_job_definitions jdf
700: where job.job_definition_id = jdf.job_definition_id
701: and job.job_id = p_job_id;
702: --
703: cursor c_job_seg11 (p_job_id number) is

Line 705: from per_jobs job, per_job_definitions jdf

701: and job.job_id = p_job_id;
702: --
703: cursor c_job_seg11 (p_job_id number) is
704: select jdf.segment11
705: from per_jobs job, per_job_definitions jdf
706: where job.job_definition_id = jdf.job_definition_id
707: and job.job_id = p_job_id;
708: --
709: cursor c_job_seg12 (p_job_id number) is

Line 711: from per_jobs job, per_job_definitions jdf

707: and job.job_id = p_job_id;
708: --
709: cursor c_job_seg12 (p_job_id number) is
710: select jdf.segment12
711: from per_jobs job, per_job_definitions jdf
712: where job.job_definition_id = jdf.job_definition_id
713: and job.job_id = p_job_id;
714: --
715: cursor c_job_seg13 (p_job_id number) is

Line 717: from per_jobs job, per_job_definitions jdf

713: and job.job_id = p_job_id;
714: --
715: cursor c_job_seg13 (p_job_id number) is
716: select jdf.segment13
717: from per_jobs job, per_job_definitions jdf
718: where job.job_definition_id = jdf.job_definition_id
719: and job.job_id = p_job_id;
720: --
721: cursor c_job_seg14 (p_job_id number) is

Line 723: from per_jobs job, per_job_definitions jdf

719: and job.job_id = p_job_id;
720: --
721: cursor c_job_seg14 (p_job_id number) is
722: select jdf.segment14
723: from per_jobs job, per_job_definitions jdf
724: where job.job_definition_id = jdf.job_definition_id
725: and job.job_id = p_job_id;
726: --
727: cursor c_job_seg15 (p_job_id number) is

Line 729: from per_jobs job, per_job_definitions jdf

725: and job.job_id = p_job_id;
726: --
727: cursor c_job_seg15 (p_job_id number) is
728: select jdf.segment15
729: from per_jobs job, per_job_definitions jdf
730: where job.job_definition_id = jdf.job_definition_id
731: and job.job_id = p_job_id;
732: --
733: cursor c_job_seg16 (p_job_id number) is

Line 735: from per_jobs job, per_job_definitions jdf

731: and job.job_id = p_job_id;
732: --
733: cursor c_job_seg16 (p_job_id number) is
734: select jdf.segment16
735: from per_jobs job, per_job_definitions jdf
736: where job.job_definition_id = jdf.job_definition_id
737: and job.job_id = p_job_id;
738: --
739: cursor c_job_seg17 (p_job_id number) is

Line 741: from per_jobs job, per_job_definitions jdf

737: and job.job_id = p_job_id;
738: --
739: cursor c_job_seg17 (p_job_id number) is
740: select jdf.segment17
741: from per_jobs job, per_job_definitions jdf
742: where job.job_definition_id = jdf.job_definition_id
743: and job.job_id = p_job_id;
744: --
745: cursor c_job_seg18 (p_job_id number) is

Line 747: from per_jobs job, per_job_definitions jdf

743: and job.job_id = p_job_id;
744: --
745: cursor c_job_seg18 (p_job_id number) is
746: select jdf.segment18
747: from per_jobs job, per_job_definitions jdf
748: where job.job_definition_id = jdf.job_definition_id
749: and job.job_id = p_job_id;
750: --
751: cursor c_job_seg19 (p_job_id number) is

Line 753: from per_jobs job, per_job_definitions jdf

749: and job.job_id = p_job_id;
750: --
751: cursor c_job_seg19 (p_job_id number) is
752: select jdf.segment19
753: from per_jobs job, per_job_definitions jdf
754: where job.job_definition_id = jdf.job_definition_id
755: and job.job_id = p_job_id;
756: --
757: cursor c_job_seg20 (p_job_id number) is

Line 759: from per_jobs job, per_job_definitions jdf

755: and job.job_id = p_job_id;
756: --
757: cursor c_job_seg20 (p_job_id number) is
758: select jdf.segment20
759: from per_jobs job, per_job_definitions jdf
760: where job.job_definition_id = jdf.job_definition_id
761: and job.job_id = p_job_id;
762: --
763: cursor c_job_seg21 (p_job_id number) is

Line 765: from per_jobs job, per_job_definitions jdf

761: and job.job_id = p_job_id;
762: --
763: cursor c_job_seg21 (p_job_id number) is
764: select jdf.segment21
765: from per_jobs job, per_job_definitions jdf
766: where job.job_definition_id = jdf.job_definition_id
767: and job.job_id = p_job_id;
768: --
769: cursor c_job_seg22 (p_job_id number) is

Line 771: from per_jobs job, per_job_definitions jdf

767: and job.job_id = p_job_id;
768: --
769: cursor c_job_seg22 (p_job_id number) is
770: select jdf.segment22
771: from per_jobs job, per_job_definitions jdf
772: where job.job_definition_id = jdf.job_definition_id
773: and job.job_id = p_job_id;
774: --
775: cursor c_job_seg23 (p_job_id number) is

Line 777: from per_jobs job, per_job_definitions jdf

773: and job.job_id = p_job_id;
774: --
775: cursor c_job_seg23 (p_job_id number) is
776: select jdf.segment23
777: from per_jobs job, per_job_definitions jdf
778: where job.job_definition_id = jdf.job_definition_id
779: and job.job_id = p_job_id;
780: --
781: cursor c_job_seg24 (p_job_id number) is

Line 783: from per_jobs job, per_job_definitions jdf

779: and job.job_id = p_job_id;
780: --
781: cursor c_job_seg24 (p_job_id number) is
782: select jdf.segment24
783: from per_jobs job, per_job_definitions jdf
784: where job.job_definition_id = jdf.job_definition_id
785: and job.job_id = p_job_id;
786: --
787: cursor c_job_seg25 (p_job_id number) is

Line 789: from per_jobs job, per_job_definitions jdf

785: and job.job_id = p_job_id;
786: --
787: cursor c_job_seg25 (p_job_id number) is
788: select jdf.segment25
789: from per_jobs job, per_job_definitions jdf
790: where job.job_definition_id = jdf.job_definition_id
791: and job.job_id = p_job_id;
792: --
793: cursor c_job_seg26 (p_job_id number) is

Line 795: from per_jobs job, per_job_definitions jdf

791: and job.job_id = p_job_id;
792: --
793: cursor c_job_seg26 (p_job_id number) is
794: select jdf.segment26
795: from per_jobs job, per_job_definitions jdf
796: where job.job_definition_id = jdf.job_definition_id
797: and job.job_id = p_job_id;
798: --
799: cursor c_job_seg27 (p_job_id number) is

Line 801: from per_jobs job, per_job_definitions jdf

797: and job.job_id = p_job_id;
798: --
799: cursor c_job_seg27 (p_job_id number) is
800: select jdf.segment27
801: from per_jobs job, per_job_definitions jdf
802: where job.job_definition_id = jdf.job_definition_id
803: and job.job_id = p_job_id;
804: --
805: cursor c_job_seg28 (p_job_id number) is

Line 807: from per_jobs job, per_job_definitions jdf

803: and job.job_id = p_job_id;
804: --
805: cursor c_job_seg28 (p_job_id number) is
806: select jdf.segment28
807: from per_jobs job, per_job_definitions jdf
808: where job.job_definition_id = jdf.job_definition_id
809: and job.job_id = p_job_id;
810: --
811: cursor c_job_seg29 (p_job_id number) is

Line 813: from per_jobs job, per_job_definitions jdf

809: and job.job_id = p_job_id;
810: --
811: cursor c_job_seg29 (p_job_id number) is
812: select jdf.segment29
813: from per_jobs job, per_job_definitions jdf
814: where job.job_definition_id = jdf.job_definition_id
815: and job.job_id = p_job_id;
816: --
817: cursor c_job_seg30 (p_job_id number) is

Line 819: from per_jobs job, per_job_definitions jdf

815: and job.job_id = p_job_id;
816: --
817: cursor c_job_seg30 (p_job_id number) is
818: select jdf.segment30
819: from per_jobs job, per_job_definitions jdf
820: where job.job_definition_id = jdf.job_definition_id
821: and job.job_id = p_job_id;
822:
823: --

Line 843: || ' from per_jobs job, per_job_definitions jdf'

839: || ' and pos.position_id = ' || p_id;
840: elsif p_code = 'JOB' then
841: l_select_string
842: := 'select jdf.' || p_information
843: || ' from per_jobs job, per_job_definitions jdf'
844: || ' where job.job_definition_id = jdf.job_definition_id'
845: || ' and job.job_id = ' || p_id;
846: else -- Invalid p_code
847: null;

Line 2476: l_job_id per_jobs.job_id%type;

2472: --
2473: l_proc varchar2(72) := g_package||'get_job_occupational_series';
2474: l_effective_date date;
2475: l_business_group_id per_all_positions.business_group_id%type;
2476: l_job_id per_jobs.job_id%type;
2477: l_segment_rec org_info_rec_type;
2478: l_segment per_position_definitions.segment1%type;
2479: l_asg_job_by_per_id_found boolean := FALSE;
2480: l_asg_job_by_asg_id_found boolean := FALSE;

Line 2559: (p_job_id in per_jobs.job_id%type

2555: -- |---------------------< get_job_occ_series_job >---------------------------|
2556: -- ---------------------------------------------------------------------------
2557: --
2558: function get_job_occ_series_job
2559: (p_job_id in per_jobs.job_id%type
2560: ,p_business_group_id in per_all_positions.business_group_id%type
2561: ) return varchar2 IS
2562: --
2563: l_proc varchar2(72) := g_package||'get_job_occ_series_job';

Line 2656: l_job_id per_jobs.job_id%type;

2652: --
2653: l_proc varchar2(72) := g_package||'sf52_from_by_assignment';
2654: l_organization_id hr_organization_units.organization_id%type;
2655: l_position_id per_all_positions.position_id%type;
2656: l_job_id per_jobs.job_id%type;
2657: l_grade_id per_grades.grade_id%type;
2658: l_location_id hr_locations.location_id%type;
2659: l_total_salary number;
2660: l_basic_pay number;