[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ASSIGNMENT_ACTION_ID,
ASSIGNMENT_ID,
ACTION_SEQUENCE,
EFFECTIVE_DATE,
ITAX_CATEGORY,
ITAX_YEA_CATEGORY,
EMPLOYMENT_CATEGORY,
SALARY_CATEGORY,
BUSINESS_GROUP_ID,
PERSON_ID,
DATE_EARNED
FROM PAY_JP_WIC_ASSACTS_V
WHERE EFFECTIVE_DATE
BETWEEN P_START_DATE AND P_END_DATE
AND BUSINESS_GROUP_ID + 0 = P_BUSINESS_GROUP_ID
AND ITAX_ORGANIZATION_ID = P_ITAX_ORGANIZATION_ID;
SELECT HOI2.ORG_INFORMATION1,
HOI1.ORG_INFORMATION5,
HOI1.ORG_INFORMATION6 || HOI1.ORG_INFORMATION7 || HOI1.ORG_INFORMATION8,
HOI1.ORG_INFORMATION1,
HOI1.ORG_INFORMATION12
INTO CP_TAX_OFFICE_NAME,
CP_EMPLOYER_POSTAL_CODE,
CP_EMPLOYER_ADDRESS,
CP_EMPLOYER_NAME,
CP_EMPLOYER_TELEPHONE_NUMBER
FROM HR_ORGANIZATION_INFORMATION HOI2,
HR_ORGANIZATION_INFORMATION HOI1,
HR_ALL_ORGANIZATION_UNITS HOU
WHERE HOU.ORGANIZATION_ID = P_ITAX_ORGANIZATION_ID
AND HOI1.ORGANIZATION_ID(+) = HOU.ORGANIZATION_ID
AND HOI1.ORG_INFORMATION_CONTEXT(+) = 'JP_TAX_SWOT_INFO'
AND HOI2.ORGANIZATION_ID(+) = HOU.ORGANIZATION_ID
AND HOI2.ORG_INFORMATION_CONTEXT(+) = 'JP_ITAX_WITHHELD_INFO';
SELECT COUNT(PAA.ASSIGNMENT_ACTION_ID),
NVL(SUM(PPT.TAXABLE_SAL_AMT + PPT.TAXABLE_MAT_AMT), 0),
NVL(SUM(PPT.ITAX), 0)
INTO CP_TERM_COUNT,
CP_TERM_TAXABLE_INCOME,
CP_TERM_ITAX
FROM PAY_JP_PRE_TAX PPT,
PAY_ASSIGNMENT_ACTIONS PAA,
PAY_PAYROLL_ACTIONS PPA
WHERE PPA.EFFECTIVE_DATE
BETWEEN P_START_DATE AND P_END_DATE
AND PPA.BUSINESS_GROUP_ID + 0 = P_BUSINESS_GROUP_ID
AND PPA.ACTION_TYPE IN ('R', 'Q', 'B', 'I')
AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PAA.ACTION_STATUS = 'C'
AND PPT.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PPT.ACTION_STATUS = 'C'
AND PPT.SALARY_CATEGORY = 'TERM'
AND PPT.ITAX_ORGANIZATION_ID = P_ITAX_ORGANIZATION_ID
AND NOT EXISTS(
SELECT NULL
FROM PAY_PAYROLL_ACTIONS PPAV,
PAY_ASSIGNMENT_ACTIONS PAAV,
PAY_ACTION_INTERLOCKS PAI
WHERE PAI.LOCKED_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PAAV.ASSIGNMENT_ACTION_ID = PAI.LOCKING_ACTION_ID
AND PPAV.PAYROLL_ACTION_ID = PAAV.PAYROLL_ACTION_ID
AND PPAV.ACTION_TYPE = 'V');
SELECT TO_CHAR(P_DATE, P_DATE_FORMAT, 'NLS_CALENDAR=''JAPANESE IMPERIAL''')
INTO L_DUMMY
FROM DUAL;