DBA Data[Home] [Help]

APPS.PAY_NL_WW_ADJUSTMENTS dependencies on HR_ORGANIZATION_INFORMATION

Line 19: FROM hr_organization_information hoi

15:
16: CURSOR csr_basis_calc_rule(c_si_type VARCHAR2, c_si_provider VARCHAR2, c_date DATE) IS
17:
18: SELECT hoi.org_information5 basis_calc_rule
19: FROM hr_organization_information hoi
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

Line 56: FROM hr_organization_information hoi

52:
53: CURSOR csr_gross_net(c_si_type VARCHAR2, c_si_provider VARCHAR2, c_date DATE) IS
54:
55: SELECT hoi.org_information14 gross_net
56: FROM hr_organization_information hoi
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

Line 102: hr_organization_information hoi

98: fnd_number.canonical_to_number(hoi.org_information17) sr_ee_perc,
99: fnd_number.canonical_to_number(hoi.org_information18) sr_er_perc,
100: hoi.org_information3 si_type_name
101: FROM
102: hr_organization_information hoi
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'