DBA Data[Home] [Help]

APPS.PAY_PAYSLIP_UTIL dependencies on HR_ORGANIZATION_INFORMATION

Line 62: from hr_organization_information

58: IS
59:
60: cursor get_legi_cd(cp_business_group_id number) is
61: select org_information9
62: from hr_organization_information
63: where organization_id = cp_business_group_id
64: and org_information_context = 'Business Group Information';
65:
66: lv_legislation_code varchar2(30) := NULL;

Line 114: from hr_organization_information hoi

110:
111: cursor c_get_payslip_date_from(cp_business_group_id number) is
112: select hoi.org_information10
113: ,fnd_date.canonical_to_date(hoi.org_information11)
114: from hr_organization_information hoi
115: where hoi.organization_id = cp_business_group_id
116: and hoi.org_information_context like 'HR_SELF_SERVICE_BG_PREFERENCE'
117: and hoi.org_information1 = 'PAYSLIP';
118: