50: -- dbms_output.put_line('HR_PERSON_FLEX_LOGIC.GetABV - 20');
51:
52: if l_inputs(i).name = 'DATE_EARNED' then
53:
54: l_inputs(i).value := FND_Date.Date_To_Canonical (p_effective_date);
55:
56: -- dbms_output.put_line('HR_PERSON_FLEX_LOGIC.GetABV - 25');
57:
58: elsif l_inputs(i).name = 'ASSIGNMENT_ID' then
244:
245: -- dbms_output.put_line('Function GetAsgWorkerType - 30');
246:
247: if l_inputs(i).name = 'DATE_EARNED' then
248: l_inputs(i).value := FND_Date.Date_To_Canonical (p_effective_date);
249:
250: -- dbms_output.put_line('Function GetAsgWorkerType - 35');
251:
252: elsif
840: from hr_organization_information
841: where organization_id = P_ORGANIZATION_ID
842: and org_information_context = 'Organization Name Alias'
843: and P_REPORT_DATE between
844: nvl(fnd_date.canonical_to_date(org_information3),hr_api.g_sot)
845: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot);
846:
847: cursor c_org_name is
848: select name
841: where organization_id = P_ORGANIZATION_ID
842: and org_information_context = 'Organization Name Alias'
843: and P_REPORT_DATE between
844: nvl(fnd_date.canonical_to_date(org_information3),hr_api.g_sot)
845: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot);
846:
847: cursor c_org_name is
848: select name
849: from hr_organization_units