DBA Data[Home] [Help]

APPS.PAY_CN_RULES dependencies on HR_ORGANIZATION_INFORMATION

Line 104: FROM hr_organization_information

100:
101: CURSOR csr_rc_id (p_bg_id IN NUMBER, p_tax_area IN VARCHAR2, p_effective_date IN DATE)
102: IS
103: SELECT org_information2
104: FROM hr_organization_information
105: WHERE organization_id = p_bg_id
106: AND org_information_context = 'PER_CONT_AREA_RETRO_USAGE_CN'
107: AND org_information1 = p_tax_area
108: AND p_effective_date BETWEEN TO_DATE(org_information3,'YYYY/MM/DD HH24:MI:SS')