APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on PER_JOBS

Line 3634: from per_jobs

3630: where lookup_type_meaning = l_definition_table;
3631:
3632: Cursor C_Jobs is
3633: Select job_id, name
3634: from per_jobs
3635: where business_group_id = p_business_group_id;
3636:
3637: l_api_name CONSTANT VARCHAR2(30) := 'Get_Attributes';
3638: l_api_version CONSTANT NUMBER := 1.0;

Line 4123: ' from per_jobs pj, per_job_definitions_kfv pjv '||

4119: -- and so the following cursor helps in storing the job_id value
4120: -- along with the job name as the corresponding attribute_value.
4121:
4122: l_job_stmt := 'Select job_id, concatenated_segments '||
4123: ' from per_jobs pj, per_job_definitions_kfv pjv '||
4124: 'where pj.business_group_id = '||p_business_group_id||
4125: ' and pj.job_definition_id = pjv.job_definition_id and '||
4126: 'pjv.id_flex_num = '||l_job_id_flex_num;
4127:

Line 4133: -- Fetching job name from PER_JOBS (Bug number 3159157)

4129: dbms_sql.define_column(v_jcursorid,1,lr_value_id);
4130: dbms_sql.define_column(v_jcursorid,2,lr_attribute_value,80);
4131: v_jdummy := DBMS_SQL.EXECUTE(v_jcursorid);*/
4132:
4133: -- Fetching job name from PER_JOBS (Bug number 3159157)
4134: For C_job_rec in C_Jobs
4135: Loop
4136: lr_attribute_id := attribute_rec.attribute_id;
4137: lr_attribute_value := C_job_rec.name;

Line 4663: from per_jobs

4659: where person_id = l_person_id ;
4660:
4661: Cursor C_job_name is
4662: Select name
4663: from per_jobs
4664: where job_id = l_job_id;
4665:
4666: /*For Bug No : 2109120 Start*/
4667: CURSOR C_check_FTE(l_pos_id NUMBER) IS

Line 4892: ' From Per_jobs,per_job_definitions '||

4888: stmt_flag := 'T';
4889: end if;
4890: if ((l_attribute_id <> prev_attribute_id) or (prev_attribute_id = -1)) then
4891: l_sql_stmt := 'Select '||l_application_column_name||
4892: ' From Per_jobs,per_job_definitions '||
4893: ' Where per_jobs.job_id = '||':lc_job_id'||
4894: ' and per_jobs.job_definition_id = '||
4895: ' per_job_definitions.job_definition_id';
4896: dbms_sql.parse(v_cursorid,l_sql_stmt,dbms_sql.v7);

Line 4893: ' Where per_jobs.job_id = '||':lc_job_id'||

4889: end if;
4890: if ((l_attribute_id <> prev_attribute_id) or (prev_attribute_id = -1)) then
4891: l_sql_stmt := 'Select '||l_application_column_name||
4892: ' From Per_jobs,per_job_definitions '||
4893: ' Where per_jobs.job_id = '||':lc_job_id'||
4894: ' and per_jobs.job_definition_id = '||
4895: ' per_job_definitions.job_definition_id';
4896: dbms_sql.parse(v_cursorid,l_sql_stmt,dbms_sql.v7);
4897: dbms_sql.define_column(v_cursorid,1,v_segment,80);

Line 4894: ' and per_jobs.job_definition_id = '||

4890: if ((l_attribute_id <> prev_attribute_id) or (prev_attribute_id = -1)) then
4891: l_sql_stmt := 'Select '||l_application_column_name||
4892: ' From Per_jobs,per_job_definitions '||
4893: ' Where per_jobs.job_id = '||':lc_job_id'||
4894: ' and per_jobs.job_definition_id = '||
4895: ' per_job_definitions.job_definition_id';
4896: dbms_sql.parse(v_cursorid,l_sql_stmt,dbms_sql.v7);
4897: dbms_sql.define_column(v_cursorid,1,v_segment,80);
4898:

Line 5632: 'from per_jobs pj,per_job_definitions_kfv pjv '||

5628: end if;
5629:
5630: v_jcursorid := DBMS_SQL.OPEN_CURSOR;
5631: l_job_stmt := 'Select concatenated_segments '||
5632: 'from per_jobs pj,per_job_definitions_kfv pjv '||
5633: 'where pj.job_id = '||':lc_job_id'||
5634: ' and pj.job_definition_id = pjv.job_definition_id '||
5635: ' and pjv.id_flex_num = '||l_id_flex_num;
5636: