DBA Data[Home] [Help]

APPS.PAY_CN_DEDUCTIONS dependencies on FND_PROFILE

Line 4712: AND hoi.organization_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

4708: SELECT hoi.org_information2
4709: FROM hr_organization_information hoi
4710: WHERE hoi.org_information_context = 'PER_SEVERANCE_PAY_TAX_RULE_CN'
4711: AND hoi.org_information1 = p_tax_area
4712: AND hoi.organization_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
4713: AND p_date_earned BETWEEN to_date(substr(hoi.org_information3,1,10),'YYYY/MM/DD')
4714: AND to_date(NVL(substr(hoi.org_information4,1,10),'4712/12/31'),'YYYY/MM/DD');
4715:
4716: BEGIN

Line 4788: AND hoi.organization_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

4784: SELECT hoi.org_information2
4785: FROM hr_organization_information hoi
4786: WHERE hoi.org_information_context = 'PER_ENN_ANN_TAX_CN'
4787: AND hoi.org_information1 = p_tax_area
4788: AND hoi.organization_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
4789: AND p_date_paid BETWEEN fnd_date.canonical_to_date(hoi.org_information3)
4790: AND nvl(fnd_date.canonical_to_date(hoi.org_information4), to_date( '31/12/4712','DD/MM/YYYY'));
4791:
4792: BEGIN