DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on BEN_CWB_PERSON_RATES

Line 1327: g_CWB_Awrd_Elig_Flag ben_Cwb_person_rates.ELIG_FLAG%Type ;

1323: g_cwb_LE_Dt date ;
1324: g_cwb_effective_date date ;
1325: --- cwb person rates
1326:
1327: g_CWB_Awrd_Elig_Flag ben_Cwb_person_rates.ELIG_FLAG%Type ;
1328: g_CWB_Awrd_Elig_Salary_Value ben_Cwb_person_rates.ELIG_SAL_VAL%Type ;
1329: g_CWB_Awrd_Group_Option_Name ben_opt_f.name%Type ;
1330: g_CWB_Awrd_Group_Plan_Name ben_pl_f.name%Type ;
1331: g_CWB_Awrd_Plan_Name ben_pl_f.name%Type ;

Line 1328: g_CWB_Awrd_Elig_Salary_Value ben_Cwb_person_rates.ELIG_SAL_VAL%Type ;

1324: g_cwb_effective_date date ;
1325: --- cwb person rates
1326:
1327: g_CWB_Awrd_Elig_Flag ben_Cwb_person_rates.ELIG_FLAG%Type ;
1328: g_CWB_Awrd_Elig_Salary_Value ben_Cwb_person_rates.ELIG_SAL_VAL%Type ;
1329: g_CWB_Awrd_Group_Option_Name ben_opt_f.name%Type ;
1330: g_CWB_Awrd_Group_Plan_Name ben_pl_f.name%Type ;
1331: g_CWB_Awrd_Plan_Name ben_pl_f.name%Type ;
1332: g_CWB_Awrd_Option_Name ben_opt_f.name%Type ;

Line 1333: g_CWB_Awrd_Misc_Value1 ben_Cwb_person_rates.MISC1_VAL%Type ;

1329: g_CWB_Awrd_Group_Option_Name ben_opt_f.name%Type ;
1330: g_CWB_Awrd_Group_Plan_Name ben_pl_f.name%Type ;
1331: g_CWB_Awrd_Plan_Name ben_pl_f.name%Type ;
1332: g_CWB_Awrd_Option_Name ben_opt_f.name%Type ;
1333: g_CWB_Awrd_Misc_Value1 ben_Cwb_person_rates.MISC1_VAL%Type ;
1334: g_CWB_Awrd_Misc_Value2 ben_Cwb_person_rates.MISC2_VAL%Type ;
1335: g_CWB_Awrd_Misc_Value3 ben_Cwb_person_rates.MISC3_VAL%Type ;
1336: g_CWB_Awrd_Other_Comp_Value ben_Cwb_person_rates.OTH_COMP_VAL%Type ;
1337: g_CWB_Awrd_Recorded_Value ben_Cwb_person_rates.REC_VAL%Type ;

Line 1334: g_CWB_Awrd_Misc_Value2 ben_Cwb_person_rates.MISC2_VAL%Type ;

1330: g_CWB_Awrd_Group_Plan_Name ben_pl_f.name%Type ;
1331: g_CWB_Awrd_Plan_Name ben_pl_f.name%Type ;
1332: g_CWB_Awrd_Option_Name ben_opt_f.name%Type ;
1333: g_CWB_Awrd_Misc_Value1 ben_Cwb_person_rates.MISC1_VAL%Type ;
1334: g_CWB_Awrd_Misc_Value2 ben_Cwb_person_rates.MISC2_VAL%Type ;
1335: g_CWB_Awrd_Misc_Value3 ben_Cwb_person_rates.MISC3_VAL%Type ;
1336: g_CWB_Awrd_Other_Comp_Value ben_Cwb_person_rates.OTH_COMP_VAL%Type ;
1337: g_CWB_Awrd_Recorded_Value ben_Cwb_person_rates.REC_VAL%Type ;
1338: g_CWB_Awrd_Stated_Salary_Value ben_Cwb_person_rates.STAT_SAL_VAL%Type ;

Line 1335: g_CWB_Awrd_Misc_Value3 ben_Cwb_person_rates.MISC3_VAL%Type ;

1331: g_CWB_Awrd_Plan_Name ben_pl_f.name%Type ;
1332: g_CWB_Awrd_Option_Name ben_opt_f.name%Type ;
1333: g_CWB_Awrd_Misc_Value1 ben_Cwb_person_rates.MISC1_VAL%Type ;
1334: g_CWB_Awrd_Misc_Value2 ben_Cwb_person_rates.MISC2_VAL%Type ;
1335: g_CWB_Awrd_Misc_Value3 ben_Cwb_person_rates.MISC3_VAL%Type ;
1336: g_CWB_Awrd_Other_Comp_Value ben_Cwb_person_rates.OTH_COMP_VAL%Type ;
1337: g_CWB_Awrd_Recorded_Value ben_Cwb_person_rates.REC_VAL%Type ;
1338: g_CWB_Awrd_Stated_Salary_Value ben_Cwb_person_rates.STAT_SAL_VAL%Type ;
1339: g_CWB_Awrd_Total_Comp_Value ben_Cwb_person_rates.TOT_COMP_VAL%Type ;

Line 1336: g_CWB_Awrd_Other_Comp_Value ben_Cwb_person_rates.OTH_COMP_VAL%Type ;

1332: g_CWB_Awrd_Option_Name ben_opt_f.name%Type ;
1333: g_CWB_Awrd_Misc_Value1 ben_Cwb_person_rates.MISC1_VAL%Type ;
1334: g_CWB_Awrd_Misc_Value2 ben_Cwb_person_rates.MISC2_VAL%Type ;
1335: g_CWB_Awrd_Misc_Value3 ben_Cwb_person_rates.MISC3_VAL%Type ;
1336: g_CWB_Awrd_Other_Comp_Value ben_Cwb_person_rates.OTH_COMP_VAL%Type ;
1337: g_CWB_Awrd_Recorded_Value ben_Cwb_person_rates.REC_VAL%Type ;
1338: g_CWB_Awrd_Stated_Salary_Value ben_Cwb_person_rates.STAT_SAL_VAL%Type ;
1339: g_CWB_Awrd_Total_Comp_Value ben_Cwb_person_rates.TOT_COMP_VAL%Type ;
1340: g_CWB_Awrd_WS_Maximum_Value ben_Cwb_person_rates.WS_MN_VAL%Type ;

Line 1337: g_CWB_Awrd_Recorded_Value ben_Cwb_person_rates.REC_VAL%Type ;

1333: g_CWB_Awrd_Misc_Value1 ben_Cwb_person_rates.MISC1_VAL%Type ;
1334: g_CWB_Awrd_Misc_Value2 ben_Cwb_person_rates.MISC2_VAL%Type ;
1335: g_CWB_Awrd_Misc_Value3 ben_Cwb_person_rates.MISC3_VAL%Type ;
1336: g_CWB_Awrd_Other_Comp_Value ben_Cwb_person_rates.OTH_COMP_VAL%Type ;
1337: g_CWB_Awrd_Recorded_Value ben_Cwb_person_rates.REC_VAL%Type ;
1338: g_CWB_Awrd_Stated_Salary_Value ben_Cwb_person_rates.STAT_SAL_VAL%Type ;
1339: g_CWB_Awrd_Total_Comp_Value ben_Cwb_person_rates.TOT_COMP_VAL%Type ;
1340: g_CWB_Awrd_WS_Maximum_Value ben_Cwb_person_rates.WS_MN_VAL%Type ;
1341: g_CWB_Awrd_WS_Minimum_Value ben_Cwb_person_rates.WS_MX_VAL%Type ;

Line 1338: g_CWB_Awrd_Stated_Salary_Value ben_Cwb_person_rates.STAT_SAL_VAL%Type ;

1334: g_CWB_Awrd_Misc_Value2 ben_Cwb_person_rates.MISC2_VAL%Type ;
1335: g_CWB_Awrd_Misc_Value3 ben_Cwb_person_rates.MISC3_VAL%Type ;
1336: g_CWB_Awrd_Other_Comp_Value ben_Cwb_person_rates.OTH_COMP_VAL%Type ;
1337: g_CWB_Awrd_Recorded_Value ben_Cwb_person_rates.REC_VAL%Type ;
1338: g_CWB_Awrd_Stated_Salary_Value ben_Cwb_person_rates.STAT_SAL_VAL%Type ;
1339: g_CWB_Awrd_Total_Comp_Value ben_Cwb_person_rates.TOT_COMP_VAL%Type ;
1340: g_CWB_Awrd_WS_Maximum_Value ben_Cwb_person_rates.WS_MN_VAL%Type ;
1341: g_CWB_Awrd_WS_Minimum_Value ben_Cwb_person_rates.WS_MX_VAL%Type ;
1342: g_CWB_Awrd_WS_Value ben_Cwb_person_rates.WS_VAL%Type ;

Line 1339: g_CWB_Awrd_Total_Comp_Value ben_Cwb_person_rates.TOT_COMP_VAL%Type ;

1335: g_CWB_Awrd_Misc_Value3 ben_Cwb_person_rates.MISC3_VAL%Type ;
1336: g_CWB_Awrd_Other_Comp_Value ben_Cwb_person_rates.OTH_COMP_VAL%Type ;
1337: g_CWB_Awrd_Recorded_Value ben_Cwb_person_rates.REC_VAL%Type ;
1338: g_CWB_Awrd_Stated_Salary_Value ben_Cwb_person_rates.STAT_SAL_VAL%Type ;
1339: g_CWB_Awrd_Total_Comp_Value ben_Cwb_person_rates.TOT_COMP_VAL%Type ;
1340: g_CWB_Awrd_WS_Maximum_Value ben_Cwb_person_rates.WS_MN_VAL%Type ;
1341: g_CWB_Awrd_WS_Minimum_Value ben_Cwb_person_rates.WS_MX_VAL%Type ;
1342: g_CWB_Awrd_WS_Value ben_Cwb_person_rates.WS_VAL%Type ;
1343:

Line 1340: g_CWB_Awrd_WS_Maximum_Value ben_Cwb_person_rates.WS_MN_VAL%Type ;

1336: g_CWB_Awrd_Other_Comp_Value ben_Cwb_person_rates.OTH_COMP_VAL%Type ;
1337: g_CWB_Awrd_Recorded_Value ben_Cwb_person_rates.REC_VAL%Type ;
1338: g_CWB_Awrd_Stated_Salary_Value ben_Cwb_person_rates.STAT_SAL_VAL%Type ;
1339: g_CWB_Awrd_Total_Comp_Value ben_Cwb_person_rates.TOT_COMP_VAL%Type ;
1340: g_CWB_Awrd_WS_Maximum_Value ben_Cwb_person_rates.WS_MN_VAL%Type ;
1341: g_CWB_Awrd_WS_Minimum_Value ben_Cwb_person_rates.WS_MX_VAL%Type ;
1342: g_CWB_Awrd_WS_Value ben_Cwb_person_rates.WS_VAL%Type ;
1343:
1344: --- subheader

Line 1341: g_CWB_Awrd_WS_Minimum_Value ben_Cwb_person_rates.WS_MX_VAL%Type ;

1337: g_CWB_Awrd_Recorded_Value ben_Cwb_person_rates.REC_VAL%Type ;
1338: g_CWB_Awrd_Stated_Salary_Value ben_Cwb_person_rates.STAT_SAL_VAL%Type ;
1339: g_CWB_Awrd_Total_Comp_Value ben_Cwb_person_rates.TOT_COMP_VAL%Type ;
1340: g_CWB_Awrd_WS_Maximum_Value ben_Cwb_person_rates.WS_MN_VAL%Type ;
1341: g_CWB_Awrd_WS_Minimum_Value ben_Cwb_person_rates.WS_MX_VAL%Type ;
1342: g_CWB_Awrd_WS_Value ben_Cwb_person_rates.WS_VAL%Type ;
1343:
1344: --- subheader
1345: g_group_elmt_value1 ben_ext_rslt_dtl.group_val_01%type ;

Line 1342: g_CWB_Awrd_WS_Value ben_Cwb_person_rates.WS_VAL%Type ;

1338: g_CWB_Awrd_Stated_Salary_Value ben_Cwb_person_rates.STAT_SAL_VAL%Type ;
1339: g_CWB_Awrd_Total_Comp_Value ben_Cwb_person_rates.TOT_COMP_VAL%Type ;
1340: g_CWB_Awrd_WS_Maximum_Value ben_Cwb_person_rates.WS_MN_VAL%Type ;
1341: g_CWB_Awrd_WS_Minimum_Value ben_Cwb_person_rates.WS_MX_VAL%Type ;
1342: g_CWB_Awrd_WS_Value ben_Cwb_person_rates.WS_VAL%Type ;
1343:
1344: --- subheader
1345: g_group_elmt_value1 ben_ext_rslt_dtl.group_val_01%type ;
1346: g_group_elmt_value2 ben_ext_rslt_dtl.group_val_01%type ;