APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on PER_GRADES

Line 1101: -- To fetch grade name from PER_GRADES

1097: SELECT name
1098: FROM PAY_RATES
1099: WHERE rate_id = l_rate_id;
1100:
1101: -- To fetch grade name from PER_GRADES
1102: -- (Bug Number 3159157)
1103: Cursor C_grade is
1104: SELECT name
1105: FROM PER_GRADES

Line 1105: FROM PER_GRADES

1101: -- To fetch grade name from PER_GRADES
1102: -- (Bug Number 3159157)
1103: Cursor C_grade is
1104: SELECT name
1105: FROM PER_GRADES
1106: WHERE grade_id = l_grade_id;
1107:
1108: --
1109: Cursor C_rate_paybasis is

Line 1195: FROM PER_GRADES pg,PER_GRADE_DEFINITIONS_KFV pgv

1191:
1192: if (l_grade_id_flex_num is not null) then
1193: v_gcursorid := DBMS_SQL.OPEN_CURSOR;
1194: l_grade_stmt := 'SELECT pg.grade_id,pgv.concatenated_segments
1195: FROM PER_GRADES pg,PER_GRADE_DEFINITIONS_KFV pgv
1196: WHERE pg.grade_id = '||':ld_grade_id'||
1197: ' AND pg.business_group_id = '||p_business_group_id||
1198: ' AND pg.grade_definition_id = pgv.grade_definition_id'||
1199: ' AND pgv.id_flex_num = '||l_grade_id_flex_num;

Line 1317: -- To get grade name from Per_Grades

1313: DBMS_SQL.COLUMN_VALUE(v_gcursorid,2,l_grade_name);
1314:
1315: End Loop; */
1316:
1317: -- To get grade name from Per_Grades
1318: For C_grade_rec in C_grade
1319: Loop
1320: l_grade_name := C_grade_rec.name;
1321: End Loop;

Line 1409: -- To get grade name from Per_Grades

1405: l_pay_basis := C_paybasis_rec.pay_basis;
1406: l_element_type_id := C_paybasis_rec.element_type_id;
1407: End Loop;
1408:
1409: -- To get grade name from Per_Grades
1410: /*DBMS_SQL.BIND_VARIABLE(v_gcursorid,':ld_grade_id',l_grade_id);
1411:
1412: v_gdummy := DBMS_SQL.EXECUTE(v_gcursorid);
1413:

Line 4942: ' From Per_grades,per_grade_definitions '||

4938: stmt_flag := 'T';
4939: end if;
4940: if ((l_attribute_id <> prev_attribute_id) or (prev_attribute_id = -1)) then
4941: l_sql_stmt := 'Select '||l_application_column_name||
4942: ' From Per_grades,per_grade_definitions '||
4943: ' Where per_grades.grade_id = '||':lc_grade_id'||
4944: ' and per_grades.grade_definition_id = '||
4945: ' per_grade_definitions.grade_definition_id';
4946: dbms_sql.parse(v_cursorid,l_sql_stmt,dbms_sql.v7);

Line 4943: ' Where per_grades.grade_id = '||':lc_grade_id'||

4939: end if;
4940: if ((l_attribute_id <> prev_attribute_id) or (prev_attribute_id = -1)) then
4941: l_sql_stmt := 'Select '||l_application_column_name||
4942: ' From Per_grades,per_grade_definitions '||
4943: ' Where per_grades.grade_id = '||':lc_grade_id'||
4944: ' and per_grades.grade_definition_id = '||
4945: ' per_grade_definitions.grade_definition_id';
4946: dbms_sql.parse(v_cursorid,l_sql_stmt,dbms_sql.v7);
4947: dbms_sql.define_column(v_cursorid,1,v_segment,80);

Line 4944: ' and per_grades.grade_definition_id = '||

4940: if ((l_attribute_id <> prev_attribute_id) or (prev_attribute_id = -1)) then
4941: l_sql_stmt := 'Select '||l_application_column_name||
4942: ' From Per_grades,per_grade_definitions '||
4943: ' Where per_grades.grade_id = '||':lc_grade_id'||
4944: ' and per_grades.grade_definition_id = '||
4945: ' per_grade_definitions.grade_definition_id';
4946: dbms_sql.parse(v_cursorid,l_sql_stmt,dbms_sql.v7);
4947: dbms_sql.define_column(v_cursorid,1,v_segment,80);
4948: if (stmt_flag = 'T') then