APPS.JAI_ETCS_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 2628: from jai_rgm_org_regns_v jrorv ,HR_ORGANIZATION_INFORMATION hrou

2624: lv_result BOOLEAN;
2625: /* Bug 12597773 -End*/
2626: CURSOR c_pan_number(p_organization_id IN NUMBER) IS
2627: Select ATTRIBUTE_VALUE
2628: from jai_rgm_org_regns_v jrorv ,HR_ORGANIZATION_INFORMATION hrou
2629: where jrorv.attribute_code = jai_constants.pan_no AND
2630: hrou.org_information_context= jai_constants.accounting_information and
2631: hrou.organization_id = p_organization_id and
2632: jrorv.ORGANIZATION_ID = hrou.org_information3 AND