APPS.PQH_GSP_UTILITY dependencies on PER_GRADES

Line 1347: p_name IN per_grades.name%TYPE,

1343: --
1344:
1345: PROCEDURE CHK_GRD_DETAILS
1346: (
1347: p_name IN per_grades.name%TYPE,
1348: p_short_name IN per_grades.short_name%TYPE,
1349: p_business_group_id IN per_grades.business_group_id%TYPE,
1350: p_grade_id IN per_grades.grade_id%TYPE default NULL,
1351: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE default NULL,

Line 1348: p_short_name IN per_grades.short_name%TYPE,

1344:
1345: PROCEDURE CHK_GRD_DETAILS
1346: (
1347: p_name IN per_grades.name%TYPE,
1348: p_short_name IN per_grades.short_name%TYPE,
1349: p_business_group_id IN per_grades.business_group_id%TYPE,
1350: p_grade_id IN per_grades.grade_id%TYPE default NULL,
1351: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE default NULL,
1352: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,

Line 1349: p_business_group_id IN per_grades.business_group_id%TYPE,

1345: PROCEDURE CHK_GRD_DETAILS
1346: (
1347: p_name IN per_grades.name%TYPE,
1348: p_short_name IN per_grades.short_name%TYPE,
1349: p_business_group_id IN per_grades.business_group_id%TYPE,
1350: p_grade_id IN per_grades.grade_id%TYPE default NULL,
1351: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE default NULL,
1352: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,
1353: p_status OUT NOCOPY VARCHAR

Line 1350: p_grade_id IN per_grades.grade_id%TYPE default NULL,

1346: (
1347: p_name IN per_grades.name%TYPE,
1348: p_short_name IN per_grades.short_name%TYPE,
1349: p_business_group_id IN per_grades.business_group_id%TYPE,
1350: p_grade_id IN per_grades.grade_id%TYPE default NULL,
1351: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE default NULL,
1352: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,
1353: p_status OUT NOCOPY VARCHAR
1354: )

Line 1360: From Per_Grades

1356:
1357: CURSOR csr_grade_name
1358: IS
1359: Select null
1360: From Per_Grades
1361: Where name = p_name
1362: And business_group_id = p_business_group_id
1363: And grade_id <> nvl(p_grade_id,-1)
1364: Union ALL

Line 1378: From per_grades

1374:
1375: CURSOR csr_grade_short_name
1376: IS
1377: Select null
1378: From per_grades
1379: Where short_name = p_short_name
1380: And business_group_id = p_business_group_id
1381: And grade_id <> nvl(p_grade_id,-1)
1382: Union ALL

Line 1392: l_grade_name per_grades.name%TYPE;

1388: And result_type_cd = 'DISPLAY'
1389: And copy_entity_result_id <> nvl(p_copy_entity_result_id,-1)
1390: And copy_entity_txn_id=p_copy_entity_txn_id;
1391:
1392: l_grade_name per_grades.name%TYPE;
1393: l_short_name per_grades.short_name%TYPE;
1394: l_proc varchar2(72) := g_package||'CHK_GRD_DETAILS';
1395:
1396: BEGIN

Line 1393: l_short_name per_grades.short_name%TYPE;

1389: And copy_entity_result_id <> nvl(p_copy_entity_result_id,-1)
1390: And copy_entity_txn_id=p_copy_entity_txn_id;
1391:
1392: l_grade_name per_grades.name%TYPE;
1393: l_short_name per_grades.short_name%TYPE;
1394: l_proc varchar2(72) := g_package||'CHK_GRD_DETAILS';
1395:
1396: BEGIN
1397: if g_debug then

Line 3134: and Pl.MAPPING_TABLE_NAME = 'PER_GRADES'

3130: From Ben_Pl_f Pl,
3131: Ben_Plip_F Plip,
3132: Ben_Pgm_F Pgm
3133: Where Pl.MAPPING_TABLE_PK_ID = l_grade_Id
3134: and Pl.MAPPING_TABLE_NAME = 'PER_GRADES'
3135: and P_Effective_Date
3136: Between Pl.Effective_Start_Date
3137: and Nvl(Pl.Effective_End_Date,hr_general.end_of_time)
3138: and Plip.Pl_Id = Pl.Pl_Id

Line 5098: and mapping_table_name = 'PER_GRADES';

5094: is
5095: select pl_id
5096: from ben_pl_f
5097: where mapping_table_pk_id = p_grade_id
5098: and mapping_table_name = 'PER_GRADES';
5099: Cursor Csr_Pgm_id (p_pl_id IN NUMBER)
5100: is
5101: select pgm_id
5102: from ben_plip_f