APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on HR_GENERAL

Line 1783: nvl(pet.effective_start_date,hr_general.start_of_time)

1779: per.include_or_exclude = 'I' AND
1780: per.element_type_id=pet.element_type_id AND
1781: pet.multiple_entries_allowed_flag='Y' AND
1782: p_effective_date between
1783: nvl(pet.effective_start_date,hr_general.start_of_time)
1784: and
1785: nvl(pet.effective_end_date,hr_general.end_of_time) AND
1786: piv.element_type_id=pet.element_type_id AND
1787: p_effective_date between

Line 1785: nvl(pet.effective_end_date,hr_general.end_of_time) AND

1781: pet.multiple_entries_allowed_flag='Y' AND
1782: p_effective_date between
1783: nvl(pet.effective_start_date,hr_general.start_of_time)
1784: and
1785: nvl(pet.effective_end_date,hr_general.end_of_time) AND
1786: piv.element_type_id=pet.element_type_id AND
1787: p_effective_date between
1788: nvl(piv.effective_start_date,hr_general.start_of_time)
1789: and

Line 1788: nvl(piv.effective_start_date,hr_general.start_of_time)

1784: and
1785: nvl(pet.effective_end_date,hr_general.end_of_time) AND
1786: piv.element_type_id=pet.element_type_id AND
1787: p_effective_date between
1788: nvl(piv.effective_start_date,hr_general.start_of_time)
1789: and
1790: nvl(piv.effective_end_date ,hr_general.end_of_time) AND
1791: pat.input_value_id=piv.input_value_id AND
1792: p_effective_date between

Line 1790: nvl(piv.effective_end_date ,hr_general.end_of_time) AND

1786: piv.element_type_id=pet.element_type_id AND
1787: p_effective_date between
1788: nvl(piv.effective_start_date,hr_general.start_of_time)
1789: and
1790: nvl(piv.effective_end_date ,hr_general.end_of_time) AND
1791: pat.input_value_id=piv.input_value_id AND
1792: p_effective_date between
1793: nvl(pat.date_effective,hr_general.start_of_time)
1794: and

Line 1793: nvl(pat.date_effective,hr_general.start_of_time)

1789: and
1790: nvl(piv.effective_end_date ,hr_general.end_of_time) AND
1791: pat.input_value_id=piv.input_value_id AND
1792: p_effective_date between
1793: nvl(pat.date_effective,hr_general.start_of_time)
1794: and
1795: nvl(pat.date_end ,hr_general.end_of_time);
1796:
1797:

Line 1795: nvl(pat.date_end ,hr_general.end_of_time);

1791: pat.input_value_id=piv.input_value_id AND
1792: p_effective_date between
1793: nvl(pat.date_effective,hr_general.start_of_time)
1794: and
1795: nvl(pat.date_end ,hr_general.end_of_time);
1796:
1797:
1798: -- change end
1799:

Line 2286: ,p_date_from => hr_general.start_of_time

2282: hxc_alias_values_api.create_alias_value
2283: (p_alias_value_id => l_av_id
2284: ,p_alias_value_name => nvl(ele_rec.reporting_name,
2285: ele_rec.element_name)
2286: ,p_date_from => hr_general.start_of_time
2287: ,p_date_to => NULL
2288: ,p_alias_definition_id => l_an_en_id
2289: ,p_enabled_flag => 'Y'
2290: ,p_attribute_category => l_an_context

Line 2299: ,p_date_from => hr_general.start_of_time

2295: l_new_en_repname:=l_cnt_repname ||' ~ ' || nvl(ele_rec.reporting_name,ele_rec.element_name);
2296: hxc_alias_values_api.create_alias_value
2297: (p_alias_value_id => l_av_id
2298: ,p_alias_value_name => l_new_en_repname
2299: ,p_date_from => hr_general.start_of_time
2300: ,p_date_to => NULL
2301: ,p_alias_definition_id => l_an_en_id
2302: ,p_enabled_flag => 'Y'
2303: ,p_attribute_category => l_an_context

Line 2328: ,p_date_from => hr_general.start_of_time

2324: hxc_alias_values_api.create_alias_value
2325: (p_alias_value_id => l_av_id
2326: ,p_alias_value_name => nvl(ele_rec.reporting_name,
2327: ele_rec.element_name)
2328: ,p_date_from => hr_general.start_of_time
2329: ,p_date_to => NULL
2330: ,p_alias_definition_id => l_an_dis_id
2331: ,p_enabled_flag => 'N'
2332: ,p_attribute_category => l_an_context

Line 2341: ,p_date_from => hr_general.start_of_time

2337: l_new_dis_repname:=l_cnt_repname ||' ~ ' || nvl(ele_rec.reporting_name,ele_rec.element_name);
2338: hxc_alias_values_api.create_alias_value
2339: (p_alias_value_id => l_av_id
2340: ,p_alias_value_name => l_new_dis_repname
2341: ,p_date_from => hr_general.start_of_time
2342: ,p_date_to => NULL
2343: ,p_alias_definition_id => l_an_dis_id
2344: ,p_enabled_flag => 'N'
2345: ,p_attribute_category => l_an_context