[Home] [Help]
1265: /*Record structure for Payroll details*/
1266: TYPE payroll_details IS RECORD
1267: (
1268: LEGISLATION_CODE VARCHAR2(30),
1269: COMPANY PAY_EMPLOYEE_ACTION_INFO_V.ORGANIZATION_NAME%TYPE,
1270: JOB_TITLE PAY_EMPLOYEE_ACTION_INFO_V.JOB%TYPE,
1271: PAYMENT_DATE VARCHAR2(10),
1272: ADDRESS VARCHAR2(2000),
1273: TAX_LOCATION PAY_EMPLOYEE_ACTION_INFO_V.LOCATION_NAME%TYPE,
1266: TYPE payroll_details IS RECORD
1267: (
1268: LEGISLATION_CODE VARCHAR2(30),
1269: COMPANY PAY_EMPLOYEE_ACTION_INFO_V.ORGANIZATION_NAME%TYPE,
1270: JOB_TITLE PAY_EMPLOYEE_ACTION_INFO_V.JOB%TYPE,
1271: PAYMENT_DATE VARCHAR2(10),
1272: ADDRESS VARCHAR2(2000),
1273: TAX_LOCATION PAY_EMPLOYEE_ACTION_INFO_V.LOCATION_NAME%TYPE,
1274: PAY_GROUP PAY_EMPLOYEE_ACTION_INFO_V.PAYROLL_NAME%TYPE,
1269: COMPANY PAY_EMPLOYEE_ACTION_INFO_V.ORGANIZATION_NAME%TYPE,
1270: JOB_TITLE PAY_EMPLOYEE_ACTION_INFO_V.JOB%TYPE,
1271: PAYMENT_DATE VARCHAR2(10),
1272: ADDRESS VARCHAR2(2000),
1273: TAX_LOCATION PAY_EMPLOYEE_ACTION_INFO_V.LOCATION_NAME%TYPE,
1274: PAY_GROUP PAY_EMPLOYEE_ACTION_INFO_V.PAYROLL_NAME%TYPE,
1275: CURRENCY_CODE PER_BUSINESS_GROUPS.CURRENCY_CODE%TYPE,
1276: PERIOD_BEGIN VARCHAR2(10),
1277: PERIOD_END VARCHAR2(10),
1270: JOB_TITLE PAY_EMPLOYEE_ACTION_INFO_V.JOB%TYPE,
1271: PAYMENT_DATE VARCHAR2(10),
1272: ADDRESS VARCHAR2(2000),
1273: TAX_LOCATION PAY_EMPLOYEE_ACTION_INFO_V.LOCATION_NAME%TYPE,
1274: PAY_GROUP PAY_EMPLOYEE_ACTION_INFO_V.PAYROLL_NAME%TYPE,
1275: CURRENCY_CODE PER_BUSINESS_GROUPS.CURRENCY_CODE%TYPE,
1276: PERIOD_BEGIN VARCHAR2(10),
1277: PERIOD_END VARCHAR2(10),
1278: TAX_JURISDICTION PAY_US_EMP_W4DTL_ACTION_INFO_V.TAX_JURISDICTION%TYPE,
1276: PERIOD_BEGIN VARCHAR2(10),
1277: PERIOD_END VARCHAR2(10),
1278: TAX_JURISDICTION PAY_US_EMP_W4DTL_ACTION_INFO_V.TAX_JURISDICTION%TYPE,
1279: MARITAL_STATUS PAY_US_EMP_W4DTL_ACTION_INFO_V.STATUS%TYPE,
1280: PAY_FREQUENCY PAY_EMPLOYEE_ACTION_INFO_V.PERIOD_TYPE%TYPE,
1281: RUN_TYPE PAY_RUN_TYPES_F.RUN_TYPE_NAME%TYPE,
1282: FED_EXEMPTIONS PAY_US_EMP_W4DTL_ACTION_INFO_V.EXEMPTIONS%TYPE,
1283: FED_ADDNL_TAX_AMOUNT PAY_US_EMP_W4DTL_ACTION_INFO_V.ADDITIONAL_TAX_AMOUNT%TYPE,
1284: FED_OVERRIDE_TAX_AMOUNT PAY_US_EMP_W4DTL_ACTION_INFO_V.OVERRIDE_TAX_AMOUNT%TYPE,