eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_GSP_UTILITY dependencies on PER_GRADES

Line 88: per_grades pg

84: ben_pl_f bp,
85: BEN_PL_TYP_F bpt,
86: ben_plip_f bplip,
87: per_grade_spines_f pgs,
88: per_grades pg
89: where
90: bp.pl_typ_id = bpt.pl_typ_id
91: and bpt.OPT_TYP_CD = 'GSP'
92: and bp.mapping_table_name = 'PER_GRADES'

Line 92: and bp.mapping_table_name = 'PER_GRADES'

88: per_grades pg
89: where
90: bp.pl_typ_id = bpt.pl_typ_id
91: and bpt.OPT_TYP_CD = 'GSP'
92: and bp.mapping_table_name = 'PER_GRADES'
93: and bp.pl_id = bplip.pl_id
94: and bplip.pgm_id = bpgm.pgm_id
95: and pgs.grade_id = bp.mapping_table_pk_id
96: and pgs.parent_spine_id = p_parent_spine_id

Line 100: l_gname per_grades.name%type;

96: and pgs.parent_spine_id = p_parent_spine_id
97: and pg.grade_id = pgs.grade_id;
98: --
99:
100: l_gname per_grades.name%type;
101: l_pgm_name ben_pgm_f.name%type;
102:
103: l_proc varchar2(72) := g_package||'chk_ps_for_upd_del';
104:

Line 144: per_grades pg,

140: ben_pl_f bp,
141: BEN_PL_TYP_F bpt,
142: ben_plip_f bplip,
143: per_grade_spines_f pgs,
144: per_grades pg,
145: pay_rates pr,
146: per_parent_spines pps
147: where
148: bp.pl_typ_id = bpt.pl_typ_id

Line 150: and bp.mapping_table_name = 'PER_GRADES'

146: per_parent_spines pps
147: where
148: bp.pl_typ_id = bpt.pl_typ_id
149: and bpt.OPT_TYP_CD = 'GSP'
150: and bp.mapping_table_name = 'PER_GRADES'
151: and bp.pl_id = bplip.pl_id
152: and bplip.pgm_id = bpgm.pgm_id
153: and pgs.grade_id = bp.mapping_table_pk_id
154: and pr.rate_id = p_rate_id

Line 161: l_gname per_grades.name%type;

157: and pr.rate_type = 'SP'
158: and pr.name = pps.name
159: and pps.parent_spine_id = pgs.parent_spine_id;
160: --
161: l_gname per_grades.name%type;
162: l_pgm_name ben_pgm_f.name%type;
163: l_proc varchar2(72) := g_package||'chk_rate_for_upd_del';
164: --
165: begin

Line 1466: p_name IN per_grades.name%TYPE,

1462: --
1463:
1464: PROCEDURE CHK_GRD_DETAILS
1465: (
1466: p_name IN per_grades.name%TYPE,
1467: p_short_name IN per_grades.short_name%TYPE,
1468: p_business_group_id IN per_grades.business_group_id%TYPE,
1469: p_grade_id IN per_grades.grade_id%TYPE default NULL,
1470: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE default NULL,

Line 1467: p_short_name IN per_grades.short_name%TYPE,

1463:
1464: PROCEDURE CHK_GRD_DETAILS
1465: (
1466: p_name IN per_grades.name%TYPE,
1467: p_short_name IN per_grades.short_name%TYPE,
1468: p_business_group_id IN per_grades.business_group_id%TYPE,
1469: p_grade_id IN per_grades.grade_id%TYPE default NULL,
1470: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE default NULL,
1471: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,

Line 1468: p_business_group_id IN per_grades.business_group_id%TYPE,

1464: PROCEDURE CHK_GRD_DETAILS
1465: (
1466: p_name IN per_grades.name%TYPE,
1467: p_short_name IN per_grades.short_name%TYPE,
1468: p_business_group_id IN per_grades.business_group_id%TYPE,
1469: p_grade_id IN per_grades.grade_id%TYPE default NULL,
1470: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE default NULL,
1471: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,
1472: p_status OUT NOCOPY VARCHAR

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

1465: (
1466: p_name IN per_grades.name%TYPE,
1467: p_short_name IN per_grades.short_name%TYPE,
1468: p_business_group_id IN per_grades.business_group_id%TYPE,
1469: p_grade_id IN per_grades.grade_id%TYPE default NULL,
1470: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE default NULL,
1471: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,
1472: p_status OUT NOCOPY VARCHAR
1473: )

Line 1479: From Per_Grades

1475:
1476: CURSOR csr_grade_name
1477: IS
1478: Select null
1479: From Per_Grades
1480: Where name = p_name
1481: And business_group_id = p_business_group_id
1482: And grade_id <> nvl(p_grade_id,-1)
1483: Union ALL

Line 1497: From per_grades

1493:
1494: CURSOR csr_grade_short_name
1495: IS
1496: Select null
1497: From per_grades
1498: Where short_name = p_short_name
1499: And business_group_id = p_business_group_id
1500: And grade_id <> nvl(p_grade_id,-1)
1501: Union ALL

Line 1511: l_grade_name per_grades.name%TYPE;

1507: And result_type_cd = 'DISPLAY'
1508: And copy_entity_result_id <> nvl(p_copy_entity_result_id,-1)
1509: And copy_entity_txn_id=p_copy_entity_txn_id;
1510:
1511: l_grade_name per_grades.name%TYPE;
1512: l_short_name per_grades.short_name%TYPE;
1513: l_proc varchar2(72) := g_package||'CHK_GRD_DETAILS';
1514:
1515: BEGIN

Line 1512: l_short_name per_grades.short_name%TYPE;

1508: And copy_entity_result_id <> nvl(p_copy_entity_result_id,-1)
1509: And copy_entity_txn_id=p_copy_entity_txn_id;
1510:
1511: l_grade_name per_grades.name%TYPE;
1512: l_short_name per_grades.short_name%TYPE;
1513: l_proc varchar2(72) := g_package||'CHK_GRD_DETAILS';
1514:
1515: BEGIN
1516: if g_debug then

Line 3253: and Pl.MAPPING_TABLE_NAME = 'PER_GRADES'

3249: From Ben_Pl_f Pl,
3250: Ben_Plip_F Plip,
3251: Ben_Pgm_F Pgm
3252: Where Pl.MAPPING_TABLE_PK_ID = l_grade_Id
3253: and Pl.MAPPING_TABLE_NAME = 'PER_GRADES'
3254: and P_Effective_Date
3255: Between Pl.Effective_Start_Date
3256: and Nvl(Pl.Effective_End_Date,hr_general.end_of_time)
3257: and Plip.Pl_Id = Pl.Pl_Id

Line 5217: and mapping_table_name = 'PER_GRADES';

5213: is
5214: select pl_id
5215: from ben_pl_f
5216: where mapping_table_pk_id = p_grade_id
5217: and mapping_table_name = 'PER_GRADES';
5218: Cursor Csr_Pgm_id (p_pl_id IN NUMBER)
5219: is
5220: select pgm_id
5221: from ben_plip_f