APPS.PSB_HR_POPULATE_DATA_PVT dependencies on PER_JOBS

Line 836: from per_jobs

832: where business_group_id = p_business_group_id;
833:
834: Cursor C_Pos_Job is
835: Select name
836: from per_jobs
837: where job_id = p_job_id;
838:
839: Cursor C_Pos_Org is
840: Select name

Line 996: ' From Per_jobs,per_job_definitions '||

992:
993: v_cursorid := dbms_sql.open_cursor;
994: if (l_definition_structure = 'Job Flexfield') then
995: l_sql_stmt := 'Select '||l_application_column_name||
996: ' From Per_jobs,per_job_definitions '||
997: ' Where per_jobs.job_id = '||p_job_id||
998: ' and per_jobs.job_definition_id = '||
999: ' per_job_definitions.job_definition_id';
1000:

Line 997: ' Where per_jobs.job_id = '||p_job_id||

993: v_cursorid := dbms_sql.open_cursor;
994: if (l_definition_structure = 'Job Flexfield') then
995: l_sql_stmt := 'Select '||l_application_column_name||
996: ' From Per_jobs,per_job_definitions '||
997: ' Where per_jobs.job_id = '||p_job_id||
998: ' and per_jobs.job_definition_id = '||
999: ' per_job_definitions.job_definition_id';
1000:
1001: dbms_sql.parse(v_cursorid,l_sql_stmt,dbms_sql.v7);

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

994: if (l_definition_structure = 'Job Flexfield') then
995: l_sql_stmt := 'Select '||l_application_column_name||
996: ' From Per_jobs,per_job_definitions '||
997: ' Where per_jobs.job_id = '||p_job_id||
998: ' and per_jobs.job_definition_id = '||
999: ' per_job_definitions.job_definition_id';
1000:
1001: dbms_sql.parse(v_cursorid,l_sql_stmt,dbms_sql.v7);
1002: dbms_sql.define_column(v_cursorid,1,v_segment,80);