APPS.PAY_FR_DADS_EMP_PKG dependencies on HRUSERDT

Line 1486: l_pen_cat_val := hruserdt.get_table_value (

1482: End IF;
1483: elsif l_old_value <> csr_35_rec.pen_cat THEN
1484: -- the stored value has changed - record this in the history
1485: Begin
1486: l_pen_cat_val := hruserdt.get_table_value (
1487: g_param_business_group_id,
1488: 'FR_APEC_AGIRC',
1489: 'AGIRC' ,
1490: csr_35_rec.pen_cat,

Line 1701: l_cipdz_value := hruserdt.get_table_value (g_param_business_group_id,

1697: For csr_asg_cat_rec in csr_asg_cat (c_end_date, l_param_start_date) Loop
1698: Exit when csr_asg_cat%notfound;
1699: IF csr_asg_cat_rec.category IS NOT NULL THEN
1700: BEGIN
1701: l_cipdz_value := hruserdt.get_table_value (g_param_business_group_id,
1702: 'FR_CIPDZ',
1703: 'CIPDZ' ,
1704: csr_asg_cat_rec.category,
1705: csr_asg_cat_rec.asg_end_date);

Line 2218: l_work_acc_rate := hruserdt.get_table_value (g_param_business_group_id,

2214: If l_work_risk_code = '99999' then
2215: l_work_acc_rate := l_work_risk_code;
2216: --Bug 3756137
2217: elsif l_work_risk_code Is not NULl then
2218: l_work_acc_rate := hruserdt.get_table_value (g_param_business_group_id,
2219: 'FR_WORK_ACCIDENT_RATES',
2220: 'RATE' ,
2221: l_work_risk_code,
2222: l_effective_date);

Line 2605: l_act_typ_val := hruserdt.get_table_value (g_param_business_group_id,

2601: hr_utility.set_location('S41 l_employment_cat:'||l_employment_cat,113);
2602: -- If ((l_employment_cat is not null) and (l_employment_cat <> '06')) Then
2603: If ((l_employment_cat is not null) and (l_contract_type_1 <> 'SEASONAL')) Then
2604: Begin
2605: l_act_typ_val := hruserdt.get_table_value (g_param_business_group_id,
2606: 'FR_CIPDZ',
2607: 'CIPDZ' ,
2608: l_employment_cat,
2609: l_effective_date);

Line 2717: l_pen_agirc_val := hruserdt.get_table_value (g_param_business_group_id,

2713: End Loop;
2714:
2715:
2716: Begin
2717: l_pen_agirc_val := hruserdt.get_table_value (g_param_business_group_id,
2718: 'FR_APEC_AGIRC',
2719: 'AGIRC' ,
2720: l_pension_info,
2721: l_effective_date);