DBA Data[Home] [Help]

APPS.GHR_CPDF_STATRPT dependencies on PER_ASSIGNMENTS_F

Line 76: g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;

72:
73: g_ghr_cpdf_temp GHR_CPDF_TEMP%ROWTYPE;
74: g_agency VARCHAR2(04);
75: g_report_date DATE;
76: g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
77: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
78: g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
79: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
80: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;

Line 77: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;

73: g_ghr_cpdf_temp GHR_CPDF_TEMP%ROWTYPE;
74: g_agency VARCHAR2(04);
75: g_report_date DATE;
76: g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
77: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
78: g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
79: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
80: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;
81: g_location_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;

Line 78: g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;

74: g_agency VARCHAR2(04);
75: g_report_date DATE;
76: g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
77: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
78: g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
79: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
80: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;
81: g_location_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;
82: g_appointment_date PER_PEOPLE_V.HIRE_DATE%TYPE;

Line 79: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;

75: g_report_date DATE;
76: g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
77: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
78: g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
79: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
80: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;
81: g_location_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;
82: g_appointment_date PER_PEOPLE_V.HIRE_DATE%TYPE;
83: --Begin Bug# 4168162

Line 80: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;

76: g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
77: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
78: g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
79: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
80: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;
81: g_location_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;
82: g_appointment_date PER_PEOPLE_V.HIRE_DATE%TYPE;
83: --Begin Bug# 4168162
84: g_message_name ghr_process_log.message_name%type;

Line 81: g_location_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;

77: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
78: g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
79: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
80: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;
81: g_location_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;
82: g_appointment_date PER_PEOPLE_V.HIRE_DATE%TYPE;
83: --Begin Bug# 4168162
84: g_message_name ghr_process_log.message_name%type;
85: --End Bug# 4168162