APPS.OTFR2483 dependencies on HRUSERDT

Line 605: and substr(hruserdt.get_table_value(

601: L_WHERE_INNER1 := null;
602: else
603: L_WHERE_INNER1 := '
604: /* Exclude intermittent and home workers as per 2483 company info */
605: and substr(hruserdt.get_table_value(
606: org_comp.business_group_id,
607: ''FR_CIPDZ'',
608: ''CIPDZ'',
609: nvl(ass.employment_category,''FR''),

Line 619: substr(hruserdt.get_table_value(org_comp.business_group_id,''FR_CIPDZ'',

615: per.order_name,
616: per.employee_number,
617: month.num mth_num,
618: decode(
619: substr(hruserdt.get_table_value(org_comp.business_group_id,''FR_CIPDZ'',
620: ''CIPDZ'',
621: nvl(ass.employment_category,''FR''),
622: month.end_date),1,1)
623: ,''C'',decode(

Line 1966: hruserdt.get_table_value(l_header_rec.bg_id

1962: fetch csr_comp_training_contrib_info into l_training_contrib_rec;
1963: begin
1964: l_er_tp_contrib_rate :=
1965: fnd_number.canonical_to_number(
1966: hruserdt.get_table_value(l_header_rec.bg_id
1967: ,'FR_CONTRIBUTION_RATES'
1968: ,'Value (EUR)'
1969: ,'ER_TRAINING_PLAN_CONTRIBUTION'
1970: ,l_header_rec.date2));

Line 1973: hruserdt.get_table_value(l_header_rec.bg_id

1969: ,'ER_TRAINING_PLAN_CONTRIBUTION'
1970: ,l_header_rec.date2));
1971: l_er_cif_contrib_rate :=
1972: fnd_number.canonical_to_number(
1973: hruserdt.get_table_value(l_header_rec.bg_id
1974: ,'FR_CONTRIBUTION_RATES'
1975: ,'Value (EUR)'
1976: ,'ER_CIF_CONTRIBUTION'
1977: ,l_header_rec.date2));

Line 1980: hruserdt.get_table_value(l_header_rec.bg_id

1976: ,'ER_CIF_CONTRIBUTION'
1977: ,l_header_rec.date2));
1978: l_er_alternance_contrib_rate :=
1979: fnd_number.canonical_to_number(
1980: hruserdt.get_table_value(l_header_rec.bg_id
1981: ,'FR_CONTRIBUTION_RATES'
1982: ,'Value (EUR)'
1983: ,'ER_ALTERNANCE_CONTRIBUTION'
1984: ,l_header_rec.date2));