APPS.PQH_GSP_BEN_VALIDATIONS dependencies on BEN_PGM_F

Line 576: From Ben_Pgm_F

572:
573: Cursor csr_pgm_typ
574: IS
575: Select Null
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)

Line 632: From Ben_Pgm_F

628:
629: Cursor csr_pgm_typ
630: IS
631: Select PGM_TYP_CD
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)

Line 705: From BEN_PGM_F PGM,

701:
702: Cursor csr_grades
703: IS
704: Select NULL
705: From BEN_PGM_F PGM,
706: BEN_PLIP_F PLIP,
707: BEN_PL_F PL
708: WHERE PGM.PGM_ID = p_Pgm_Id
709: AND PGM.PGM_TYP_CD = 'GSP'

Line 768: Ben_Pgm_F Pgm

764: IS
765: Select Null
766: From Ben_PL_F pl,
767: Ben_Plip_F plip,
768: Ben_Pgm_F Pgm
769: Where pl.pl_id = p_pl_id
770: And pl.MAPPING_TABLE_NAME = 'PER_GRADES'
771: And pl.MAPPING_TABLE_PK_ID IS NOT NULL
772: And pl.pl_id = plip.pl_id

Line 1007: From Ben_Pgm_F

1003:
1004: Cursor csr_short_name
1005: IS
1006: Select null
1007: From Ben_Pgm_F
1008: Where Pgm_Id <> nvl(p_pgm_id,-1)
1009: And Short_Name = nvl(p_short_name,-1)
1010: And Business_Group_Id = p_business_group_id
1011: And PGM_TYP_CD ='GSP' ;

Line 1017: From Ben_Pgm_F

1013:
1014: Cursor csr_short_code
1015: IS
1016: Select null
1017: From Ben_Pgm_F
1018: Where Pgm_Id <> nvl(p_pgm_id,-1)
1019: And Short_Code = nvl(p_short_code,-1)
1020: And Business_Group_Id = p_business_group_id
1021: And PGM_TYP_CD ='GSP' ;

Line 1026: From ben_pgm_f

1022:
1023:
1024: Cursor csr_default_grdldr IS
1025: Select Null
1026: From ben_pgm_f
1027: Where pgm_id <> nvl(p_pgm_id,-1)
1028: And PGM_TYP_CD ='GSP'
1029: And Dflt_Pgm_Flag = 'Y'
1030: And business_group_id = p_business_group_id

Line 1132: l_pgm_type Ben_Pgm_F.PGM_TYP_CD%Type;

1128:
1129: */
1130: l_proc Varchar2(72) := g_package||'pgm_upd_val';
1131: l_dummy Char(1);
1132: l_pgm_type Ben_Pgm_F.PGM_TYP_CD%Type;
1133: l_pgm_status Ben_Pgm_F.PGM_STAT_CD%Type;
1134: l_pgm_points_flag Ben_Pgm_F.USE_PROG_POINTS_FLAG%Type;
1135: l_rate_period Ben_Pgm_F.ACTY_REF_PERD_CD%Type;
1136: l_currency Ben_Pgm_F.PGM_UOM%Type;

Line 1133: l_pgm_status Ben_Pgm_F.PGM_STAT_CD%Type;

1129: */
1130: l_proc Varchar2(72) := g_package||'pgm_upd_val';
1131: l_dummy Char(1);
1132: l_pgm_type Ben_Pgm_F.PGM_TYP_CD%Type;
1133: l_pgm_status Ben_Pgm_F.PGM_STAT_CD%Type;
1134: l_pgm_points_flag Ben_Pgm_F.USE_PROG_POINTS_FLAG%Type;
1135: l_rate_period Ben_Pgm_F.ACTY_REF_PERD_CD%Type;
1136: l_currency Ben_Pgm_F.PGM_UOM%Type;
1137: l_exists Varchar2(1) := 'N';

Line 1134: l_pgm_points_flag Ben_Pgm_F.USE_PROG_POINTS_FLAG%Type;

1130: l_proc Varchar2(72) := g_package||'pgm_upd_val';
1131: l_dummy Char(1);
1132: l_pgm_type Ben_Pgm_F.PGM_TYP_CD%Type;
1133: l_pgm_status Ben_Pgm_F.PGM_STAT_CD%Type;
1134: l_pgm_points_flag Ben_Pgm_F.USE_PROG_POINTS_FLAG%Type;
1135: l_rate_period Ben_Pgm_F.ACTY_REF_PERD_CD%Type;
1136: l_currency Ben_Pgm_F.PGM_UOM%Type;
1137: l_exists Varchar2(1) := 'N';
1138: l_grd_exists Varchar2(1) := 'N';

Line 1135: l_rate_period Ben_Pgm_F.ACTY_REF_PERD_CD%Type;

1131: l_dummy Char(1);
1132: l_pgm_type Ben_Pgm_F.PGM_TYP_CD%Type;
1133: l_pgm_status Ben_Pgm_F.PGM_STAT_CD%Type;
1134: l_pgm_points_flag Ben_Pgm_F.USE_PROG_POINTS_FLAG%Type;
1135: l_rate_period Ben_Pgm_F.ACTY_REF_PERD_CD%Type;
1136: l_currency Ben_Pgm_F.PGM_UOM%Type;
1137: l_exists Varchar2(1) := 'N';
1138: l_grd_exists Varchar2(1) := 'N';
1139:

Line 1136: l_currency Ben_Pgm_F.PGM_UOM%Type;

1132: l_pgm_type Ben_Pgm_F.PGM_TYP_CD%Type;
1133: l_pgm_status Ben_Pgm_F.PGM_STAT_CD%Type;
1134: l_pgm_points_flag Ben_Pgm_F.USE_PROG_POINTS_FLAG%Type;
1135: l_rate_period Ben_Pgm_F.ACTY_REF_PERD_CD%Type;
1136: l_currency Ben_Pgm_F.PGM_UOM%Type;
1137: l_exists Varchar2(1) := 'N';
1138: l_grd_exists Varchar2(1) := 'N';
1139:
1140: