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_BEN_VALIDATIONS dependencies on HR_GENERAL

Line 30: And nvl(Pl.effective_end_date,hr_general.end_of_time);

26: From Ben_PL_F pl
27: Where pl.Pl_Id = p_pl_id
28: And pl.Business_Group_id = p_Business_Group_Id
29: And p_effective_date BETWEEN Pl.effective_start_date
30: And nvl(Pl.effective_end_date,hr_general.end_of_time);
31:
32: Cursor csr_pl_type (l_pl_Typ_Id IN Number)
33: IS
34: Select OPT_TYP_CD

Line 39: And nvl(effective_end_date,hr_general.end_of_time);

35: From BEN_PL_TYP_F Type
36: Where Pl_Typ_Id = l_pl_Typ_Id
37: And Business_Group_id = p_Business_Group_Id
38: And p_effective_date BETWEEN effective_start_date
39: And nvl(effective_end_date,hr_general.end_of_time);
40:
41: Begin
42:
43: if g_debug then

Line 94: And nvl(Plip.effective_end_date,hr_general.end_of_time);

90: From Ben_PLIP_F plip
91: Where plip.Plip_Id = p_plip_id
92: And plip.Business_Group_id = p_Business_Group_Id
93: And p_effective_date BETWEEN Plip.effective_start_date
94: And nvl(Plip.effective_end_date,hr_general.end_of_time);
95:
96:
97: Begin
98: if g_debug then

Line 176: And nvl(PLIP.Effective_End_Date, hr_general.end_of_time)

172: AND PLIP.PL_ID =PL.PL_ID
173: AND PL.MAPPING_TABLE_NAME = 'PER_GRADES'
174: AND PL.BUSINESS_GROUP_ID = p_business_group_id
175: AND p_effective_date BETWEEN PLIP.EFFECTIVE_START_DATE
176: And nvl(PLIP.Effective_End_Date, hr_general.end_of_time)
177: AND p_effective_date BETWEEN PL.EFFECTIVE_START_DATE
178: And nvl(PL.Effective_End_Date, hr_general.end_of_time);
179:
180: Cursor csr_emp_placemnets (l_grade_id IN NUMBER)

Line 178: And nvl(PL.Effective_End_Date, hr_general.end_of_time);

174: AND PL.BUSINESS_GROUP_ID = p_business_group_id
175: AND p_effective_date BETWEEN PLIP.EFFECTIVE_START_DATE
176: And nvl(PLIP.Effective_End_Date, hr_general.end_of_time)
177: AND p_effective_date BETWEEN PL.EFFECTIVE_START_DATE
178: And nvl(PL.Effective_End_Date, hr_general.end_of_time);
179:
180: Cursor csr_emp_placemnets (l_grade_id IN NUMBER)
181: IS
182: Select NULL

Line 186: AND nvl(Assgt.effective_end_date,hr_general.end_of_time)

182: Select NULL
183: From Per_All_Assignments_F Assgt
184: Where Grade_Id = l_grade_id
185: AND p_Effective_Date BETWEEN Assgt.effective_start_date
186: AND nvl(Assgt.effective_end_date,hr_general.end_of_time)
187: AND Assgt.business_group_id = p_Business_Group_Id;
188:
189:
190: Begin

Line 265: And nvl(Effective_End_Date, hr_general.end_of_time)

261: From BEN_PL_TYP_OPT_TYP_F
262: Where OPT_ID = p_opt_id
263: AND BUSINESS_GROUP_ID = p_business_group_id
264: AND p_effective_date BETWEEN EFFECTIVE_START_DATE
265: And nvl(Effective_End_Date, hr_general.end_of_time)
266: And PL_TYP_OPT_TYP_CD = 'GSP';
267:
268: Begin
269: if g_debug then

Line 319: And nvl(Effective_End_Date, hr_general.end_of_time);

315: Where OIPL_ID = p_oipl_id
316: And OIPL_STAT_CD = 'A'
317: AND BUSINESS_GROUP_ID = p_business_group_id
318: AND p_effective_date BETWEEN EFFECTIVE_START_DATE
319: And nvl(Effective_End_Date, hr_general.end_of_time);
320:
321: Begin
322: if g_debug then
323: hr_utility.set_location('Entering'||l_proc,10);

Line 386: And nvl(spine.Effective_End_Date, hr_general.end_of_time)

382: And spine.GRADE_SPINE_ID = step.GRADE_SPINE_ID
383: And step.SPINAL_POINT_ID = point.SPINAL_POINT_ID
384: And spine.Grade_Id = p_Grade_Id
385: AND p_effective_date BETWEEN spine.EFFECTIVE_START_DATE
386: And nvl(spine.Effective_End_Date, hr_general.end_of_time)
387: AND p_effective_date BETWEEN step.EFFECTIVE_START_DATE
388: And nvl(step.Effective_End_Date, hr_general.end_of_time);
389:
390: Begin

Line 388: And nvl(step.Effective_End_Date, hr_general.end_of_time);

384: And spine.Grade_Id = p_Grade_Id
385: AND p_effective_date BETWEEN spine.EFFECTIVE_START_DATE
386: And nvl(spine.Effective_End_Date, hr_general.end_of_time)
387: AND p_effective_date BETWEEN step.EFFECTIVE_START_DATE
388: And nvl(step.Effective_End_Date, hr_general.end_of_time);
389:
390: Begin
391: if g_debug then
392: hr_utility.set_location('Entering'||l_proc,10);

Line 453: And nvl(oipl.Effective_End_Date, hr_general.end_of_time)

449: And oipl.opt_id = opt.opt_id
450: and opt.MAPPING_TABLE_NAME= 'PER_SPINAL_POINTS'
451: And pl.MAPPING_TABLE_NAME = 'PER_GRADES'
452: AND p_effective_date BETWEEN oipl.EFFECTIVE_START_DATE
453: And nvl(oipl.Effective_End_Date, hr_general.end_of_time)
454: AND p_effective_date BETWEEN PL.EFFECTIVE_START_DATE
455: And nvl(PL.Effective_End_Date, hr_general.end_of_time);
456:
457: cursor csr_point_placement(l_step_id IN Number) is

Line 455: And nvl(PL.Effective_End_Date, hr_general.end_of_time);

451: And pl.MAPPING_TABLE_NAME = 'PER_GRADES'
452: AND p_effective_date BETWEEN oipl.EFFECTIVE_START_DATE
453: And nvl(oipl.Effective_End_Date, hr_general.end_of_time)
454: AND p_effective_date BETWEEN PL.EFFECTIVE_START_DATE
455: And nvl(PL.Effective_End_Date, hr_general.end_of_time);
456:
457: cursor csr_point_placement(l_step_id IN Number) is
458: select Effective_Start_date, Effective_End_Date
459: from per_spinal_point_placements_f

Line 463: and nvl(effective_end_date,hr_general.end_of_time);

459: from per_spinal_point_placements_f
460: where step_id = l_step_id
461: And Business_Group_Id= p_business_group_id
462: and p_effective_date between effective_start_date
463: and nvl(effective_end_date,hr_general.end_of_time);
464: --
465: cursor csr_emp_assign (l_step_id IN Number) is
466: select Effective_Start_Date, Effective_End_Date
467: from per_all_assignments_f

Line 471: and nvl(effective_end_date,hr_general.end_of_time);

467: from per_all_assignments_f
468: where special_ceiling_step_id = l_step_id
469: And Business_Group_Id= p_business_group_id
470: and p_effective_date between effective_start_date
471: and nvl(effective_end_date,hr_general.end_of_time);
472:
473: Begin
474: if g_debug then
475: hr_utility.set_location('Entering'||l_proc,5);

Line 580: And nvl(Effective_End_Date, hr_general.end_of_time)

576: From Ben_Pgm_F
577: Where Pgm_id = p_Pgm_Id
578: And business_group_id = p_business_group_id
579: And p_effective_date Between Effective_Start_Date
580: And nvl(Effective_End_Date, hr_general.end_of_time)
581: And PGM_TYP_CD = 'GSP'
582: And PGM_STAT_CD = 'A';
583:
584:

Line 636: And nvl(Effective_End_Date, hr_general.end_of_time)

632: From Ben_Pgm_F
633: Where Pgm_id = p_Pgm_Id
634: And business_group_id = p_business_group_id
635: And p_effective_date Between Effective_Start_Date
636: And nvl(Effective_End_Date, hr_general.end_of_time)
637: And PGM_STAT_CD = 'A';
638:
639: Cursor csr_emp_placemnets
640: IS

Line 645: AND nvl(Assgt.effective_end_date,hr_general.end_of_time)

641: Select NULL
642: From Per_All_Assignments_F Assgt
643: Where Grade_Ladder_Pgm_Id = p_Pgm_Id
644: AND p_Effective_Date BETWEEN Assgt.effective_start_date
645: AND nvl(Assgt.effective_end_date,hr_general.end_of_time)
646: AND Assgt.business_group_id = p_Business_Group_Id;
647:
648: Begin
649: if g_debug then

Line 719: AND nvl(pgm.effective_end_date,hr_general.end_of_time)

715: And PGM.PGM_STAT_CD = 'A'
716: AND PLIP.PLIP_STAT_CD = 'A'
717: AND PL.PL_STAT_CD ='A'
718: AND p_Effective_Date BETWEEN pgm.effective_start_date
719: AND nvl(pgm.effective_end_date,hr_general.end_of_time)
720: AND p_Effective_Date BETWEEN plip.effective_start_date
721: AND nvl(plip.effective_end_date,hr_general.end_of_time)
722: AND p_Effective_Date BETWEEN pl.effective_start_date
723: AND nvl(pl.effective_end_date,hr_general.end_of_time);

Line 721: AND nvl(plip.effective_end_date,hr_general.end_of_time)

717: AND PL.PL_STAT_CD ='A'
718: AND p_Effective_Date BETWEEN pgm.effective_start_date
719: AND nvl(pgm.effective_end_date,hr_general.end_of_time)
720: AND p_Effective_Date BETWEEN plip.effective_start_date
721: AND nvl(plip.effective_end_date,hr_general.end_of_time)
722: AND p_Effective_Date BETWEEN pl.effective_start_date
723: AND nvl(pl.effective_end_date,hr_general.end_of_time);
724:
725:

Line 723: AND nvl(pl.effective_end_date,hr_general.end_of_time);

719: AND nvl(pgm.effective_end_date,hr_general.end_of_time)
720: AND p_Effective_Date BETWEEN plip.effective_start_date
721: AND nvl(plip.effective_end_date,hr_general.end_of_time)
722: AND p_Effective_Date BETWEEN pl.effective_start_date
723: AND nvl(pl.effective_end_date,hr_general.end_of_time);
724:
725:
726: Begin
727: if g_debug then

Line 780: and nvl(Pl.effective_end_date,hr_general.end_of_time)

776: And pl.PL_STAT_CD = 'A'
777: And plip.PLIP_STAT_CD = 'A'
778: And pgm.PGM_STAT_CD = 'A'
779: And p_effective_date BETWEEN Pl.effective_start_date
780: and nvl(Pl.effective_end_date,hr_general.end_of_time)
781: And p_effective_date BETWEEN Plip.effective_start_date
782: and nvl(Plip.effective_end_date,hr_general.end_of_time)
783: And p_effective_date BETWEEN Pgm.effective_start_date
784: and nvl(Pgm.effective_end_date,hr_general.end_of_time);

Line 782: and nvl(Plip.effective_end_date,hr_general.end_of_time)

778: And pgm.PGM_STAT_CD = 'A'
779: And p_effective_date BETWEEN Pl.effective_start_date
780: and nvl(Pl.effective_end_date,hr_general.end_of_time)
781: And p_effective_date BETWEEN Plip.effective_start_date
782: and nvl(Plip.effective_end_date,hr_general.end_of_time)
783: And p_effective_date BETWEEN Pgm.effective_start_date
784: and nvl(Pgm.effective_end_date,hr_general.end_of_time);
785:
786: Begin

Line 784: and nvl(Pgm.effective_end_date,hr_general.end_of_time);

780: and nvl(Pl.effective_end_date,hr_general.end_of_time)
781: And p_effective_date BETWEEN Plip.effective_start_date
782: and nvl(Plip.effective_end_date,hr_general.end_of_time)
783: And p_effective_date BETWEEN Pgm.effective_start_date
784: and nvl(Pgm.effective_end_date,hr_general.end_of_time);
785:
786: Begin
787: if g_debug then
788: hr_utility.set_location('Entering'||l_proc,5);

Line 847: AND nvl(opt.effective_end_date,hr_general.end_of_time)

843: AND pl.MAPPING_TABLE_PK_ID IS NOT NULL
844: And oipl.OIPL_STAT_CD = 'A'
845: AND pl.PL_STAT_CD = 'A'
846: AND p_effective_date BETWEEN opt.effective_start_date
847: AND nvl(opt.effective_end_date,hr_general.end_of_time)
848: AND p_effective_date BETWEEN oipl.effective_start_date
849: AND nvl(oipl.effective_end_date,hr_general.end_of_time)
850: AND p_effective_date BETWEEN pl.effective_start_date
851: AND nvl(pl.effective_end_date,hr_general.end_of_time);

Line 849: AND nvl(oipl.effective_end_date,hr_general.end_of_time)

845: AND pl.PL_STAT_CD = 'A'
846: AND p_effective_date BETWEEN opt.effective_start_date
847: AND nvl(opt.effective_end_date,hr_general.end_of_time)
848: AND p_effective_date BETWEEN oipl.effective_start_date
849: AND nvl(oipl.effective_end_date,hr_general.end_of_time)
850: AND p_effective_date BETWEEN pl.effective_start_date
851: AND nvl(pl.effective_end_date,hr_general.end_of_time);
852:
853: Begin

Line 851: AND nvl(pl.effective_end_date,hr_general.end_of_time);

847: AND nvl(opt.effective_end_date,hr_general.end_of_time)
848: AND p_effective_date BETWEEN oipl.effective_start_date
849: AND nvl(oipl.effective_end_date,hr_general.end_of_time)
850: AND p_effective_date BETWEEN pl.effective_start_date
851: AND nvl(pl.effective_end_date,hr_general.end_of_time);
852:
853: Begin
854: if g_debug then
855: hr_utility.set_location('Entering'||l_proc,5);

Line 919: AND nvl(opt.effective_end_date,hr_general.end_of_time)

915: AND opt.Business_group_id = p_Business_Group_Id
916: AND opt.opt_id = oipl.opt_id
917: And oipl.OIPL_STAT_CD = 'A'
918: AND p_effective_date BETWEEN opt.effective_start_date
919: AND nvl(opt.effective_end_date,hr_general.end_of_time)
920: AND p_effective_date BETWEEN oipl.effective_start_date
921: AND nvl(oipl.effective_end_date,hr_general.end_of_time);
922:
923:

Line 921: AND nvl(oipl.effective_end_date,hr_general.end_of_time);

917: And oipl.OIPL_STAT_CD = 'A'
918: AND p_effective_date BETWEEN opt.effective_start_date
919: AND nvl(opt.effective_end_date,hr_general.end_of_time)
920: AND p_effective_date BETWEEN oipl.effective_start_date
921: AND nvl(oipl.effective_end_date,hr_general.end_of_time);
922:
923:
924: Begin
925: if g_debug then

Line 1285: p_business_group_id in Number Default hr_general.GET_BUSINESS_GROUP_ID,

1281: --
1282: procedure pgm_validations(p_pgm_id in Number,
1283: p_dml_operation in Varchar2,
1284: p_effective_date in Date,
1285: p_business_group_id in Number Default hr_general.GET_BUSINESS_GROUP_ID,
1286: p_short_name in Varchar2 Default NULL,
1287: p_short_code in Varchar2 Default NULL,
1288: p_Dflt_Pgm_Flag in Varchar2 Default 'N',
1289: p_Pgm_Typ_Cd in Varchar2 Default NULL,

Line 1457: And nvl(effective_end_date,hr_general.end_of_time);

1453: From BEN_PL_TYP_F Type
1454: Where Pl_Typ_Id = l_plan_Typ_Id
1455: And Business_Group_id = p_business_group_id
1456: And p_effective_date BETWEEN effective_start_date
1457: And nvl(effective_end_date,hr_general.end_of_time);
1458:
1459:
1460: Cursor csr_plip_id
1461: IS

Line 1467: And nvl(Effective_End_Date, hr_general.end_of_time)

1463: From BEN_PLIP_F
1464: Where Pl_Id = p_pl_Id
1465: And business_group_id = p_business_group_id
1466: And p_effective_date Between Effective_Start_Date
1467: And nvl(Effective_End_Date, hr_general.end_of_time)
1468: And PLIP_STAT_CD = 'A';
1469:
1470:
1471: Begin

Line 1614: p_Business_Group_Id In Number Default hr_general.GET_BUSINESS_GROUP_ID,

1610: ---------------------------pl_validations-----------------------------
1611: --
1612: procedure pl_validations(p_pl_id In number,
1613: p_effective_date In date,
1614: p_Business_Group_Id In Number Default hr_general.GET_BUSINESS_GROUP_ID,
1615: p_dml_operation In varchar2,
1616: p_pl_Typ_Id In Number Default NULL,
1617: p_Mapping_Table_PK_ID In Number Default NULL,
1618: p_pl_stat_cd IN Varchar2 Default 'I')

Line 1807: p_business_group_id In Number Default hr_general.GET_BUSINESS_GROUP_ID,

1803:
1804: procedure plip_validations(p_plip_id In Number,
1805: p_effective_date In Date,
1806: p_dml_operation In Varchar2,
1807: p_business_group_id In Number Default hr_general.GET_BUSINESS_GROUP_ID,
1808: p_Plip_Stat_Cd In Varchar Default 'I')
1809: IS
1810: l_proc Varchar2(72) := g_package||'plip_validations';
1811: l_is_pgm_type_gsp Varchar2(1) := 'N';

Line 1927: AND nvl(effective_end_date,hr_general.end_of_time)

1923: From BEN_OIPL_F
1924: Where opt_id = p_opt_id
1925: AND Business_group_id = p_business_group_id
1926: AND p_effective_date BETWEEN effective_start_date
1927: AND nvl(effective_end_date,hr_general.end_of_time)
1928: And OIPL_STAT_CD = 'A';
1929:
1930: Begin
1931: if g_debug then

Line 2030: p_Business_Group_Id in Number Default hr_general.GET_BUSINESS_GROUP_ID,

2026:
2027: procedure opt_validations(p_opt_id in number,
2028: p_effective_date in date,
2029: p_dml_operation in varchar2,
2030: p_Business_Group_Id in Number Default hr_general.GET_BUSINESS_GROUP_ID,
2031: p_mapping_table_pk_id in Number Default NULL)
2032: IS
2033: l_proc varchar2(72) := g_package||'plip_validations';
2034: begin

Line 2236: p_Business_Group_Id in Number Default hr_general.GET_BUSINESS_GROUP_ID,

2232:
2233: procedure oipl_validations(p_oipl_id in number,
2234: p_dml_operation in varchar2,
2235: p_effective_date in date,
2236: p_Business_Group_Id in Number Default hr_general.GET_BUSINESS_GROUP_ID,
2237: p_oipl_stat_cd in Varchar2 Default 'I')
2238: IS
2239: l_proc varchar2(72) := g_package||'oipl_validations';
2240: begin

Line 2362: AND nvl(effective_end_date,hr_general.end_of_time);

2358: Where PL_ID = p_pl_id
2359: AND PLIP_STAT_CD = 'A'
2360: And Business_Group_Id = p_business_group_id
2361: And p_effective_date BETWEEN effective_start_date
2362: AND nvl(effective_end_date,hr_general.end_of_time);
2363:
2364:
2365: Cursor csr_oipl_id
2366: IS

Line 2372: AND nvl(effective_end_date,hr_general.end_of_time);

2368: From BEN_OIPL_F
2369: Where OPT_ID = p_opt_id
2370: And Business_Group_Id = p_business_group_id
2371: And p_effective_date BETWEEN effective_start_date
2372: AND nvl(effective_end_date,hr_general.end_of_time);
2373:
2374:
2375: Begin
2376: if g_debug then

Line 2524: p_business_group_id IN Number Default hr_general.GET_BUSINESS_GROUP_ID,

2520: --
2521: procedure abr_validations(p_abr_id in number,
2522: p_dml_operation in varchar2,
2523: p_effective_date in date,
2524: p_business_group_id IN Number Default hr_general.GET_BUSINESS_GROUP_ID,
2525: p_pl_id In Number Default NULL,
2526: p_opt_id In Number Default NULL,
2527: p_acty_typ_cd In Varchar2 Default NULL,
2528: p_Acty_Base_RT_Stat_Cd In Varchar2 Default 'I')

Line 2543: AND nvl(effective_end_date,hr_general.end_of_time);

2539: From BEN_ACTY_BASE_RT_F
2540: Where ACTY_BASE_RT_ID = p_abr_id
2541: And Business_Group_Id = p_business_group_id
2542: And p_effective_date BETWEEN effective_start_date
2543: AND nvl(effective_end_date,hr_general.end_of_time);
2544:
2545:
2546: begin
2547: -- validations to be performed in this routine are