DBA Data[Home] [Help]

APPS.PAY_PAYRP940_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 50: HR_ORGANIZATION_INFORMATION

46: CURSOR MY_CURSOR IS
47: SELECT
48: ORG_INFORMATION2
49: FROM
50: HR_ORGANIZATION_INFORMATION
51: WHERE ORGANIZATION_ID = TAX_UNIT_ID
52: AND ORG_INFORMATION_CONTEXT = 'State Tax Rules'
53: AND ORG_INFORMATION1 = STATE_CODE;
54: STATE_ID VARCHAR2(25);

Line 352: HR_ORGANIZATION_INFORMATION

348: SELECT
349: ORG_INFORMATION6,
350: ORG_INFORMATION7
351: FROM
352: HR_ORGANIZATION_INFORMATION
353: WHERE ORGANIZATION_ID = TAX_UNIT_ID
354: AND ORG_INFORMATION_CONTEXT = 'State Tax Rules'
355: AND ORG_INFORMATION1 = STATE_CODE;
356: EXP_RATE_1 VARCHAR2(25);