APPS.PAY_NL_WW_ADJUSTMENTS dependencies on HR_GENERAL

Line 24: AND c_date between fnd_date.canonical_to_date(hoi.org_information1) AND nvl(fnd_date.canonical_to_date(hoi.org_information2),hr_general.end_of_time);

20: WHERE
21: Hoi.Organization_id = c_si_provider
22: AND hoi.org_information_context = 'NL_SIT'
23: AND hoi.org_information4 = c_si_type
24: AND c_date between fnd_date.canonical_to_date(hoi.org_information1) AND nvl(fnd_date.canonical_to_date(hoi.org_information2),hr_general.end_of_time);
25:
26:
27: l_basis_calc_rule csr_basis_calc_rule%ROWTYPE;
28:

Line 61: AND c_date between fnd_date.canonical_to_date(hoi.org_information1) AND NVL(fnd_date.canonical_to_date(hoi.org_information2),hr_general.end_of_time);

57: WHERE
58: Hoi.Organization_id = c_si_provider
59: AND hoi.org_information_context = 'NL_SIT'
60: AND hoi.org_information4 = c_si_type
61: AND c_date between fnd_date.canonical_to_date(hoi.org_information1) AND NVL(fnd_date.canonical_to_date(hoi.org_information2),hr_general.end_of_time);
62:
63:
64: l_gross_net csr_gross_net%ROWTYPE;
65:

Line 107: AND c_date_earned BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND nvl(fnd_date.canonical_to_date(hoi.org_information2),hr_general.end_of_time);

103: WHERE
104: hoi.org_information4 = c_si_type
105: AND hoi.organization_id = to_number(c_si_provider)
106: AND hoi.org_information_context = 'NL_SIT'
107: AND c_date_earned BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND nvl(fnd_date.canonical_to_date(hoi.org_information2),hr_general.end_of_time);
108: l_cont_perc csr_get_cont_perc%ROWTYPE;
109:
110: l_delete VARCHAR2(15) := 'Y';
111: BEGIN