VIEW: APPS.PAY_JP_LABOR_INS_V

Source

View Text - Preformatted

SELECT ppt.salary_category, to_char(ppa.effective_date,'YYYYMM'), ppa.business_group_id, paa.assignment_id, ppt.ui_organization_id, ppt.ui_category, sum(ppt.ui_sal_amt), ppt.wai_organization_id, ppt.wai_category, sum(ppt.wai_sal_amt) from pay_jp_pre_tax ppt, pay_assignment_actions paa, pay_payroll_actions ppa where ppa.action_type in ('R','Q','B','I') and paa.payroll_action_id=ppa.payroll_action_id and ppa.action_status='C' and ppt.assignment_action_id=paa.assignment_action_id and ppt.action_status='C' and ppt.salary_category in ('SALARY','BONUS','SP_BONUS') and not exists( select NULL from pay_payroll_actions ppa2, pay_assignment_actions paa2, pay_action_interlocks pai where pai.locked_action_id=paa.assignment_action_id and paa2.assignment_action_id=pai.locking_action_id and ppa2.payroll_action_id=paa2.payroll_action_id and ppa2.action_type='V') group by ppt.salary_category, to_char(ppa.effective_date,'YYYYMM'), ppa.business_group_id, paa.assignment_id, ppt.ui_organization_id, ppt.ui_category, ppt.wai_organization_id, ppt.wai_category

View Text - HTML Formatted

SELECT PPT.SALARY_CATEGORY
, TO_CHAR(PPA.EFFECTIVE_DATE
, 'YYYYMM')
, PPA.BUSINESS_GROUP_ID
, PAA.ASSIGNMENT_ID
, PPT.UI_ORGANIZATION_ID
, PPT.UI_CATEGORY
, SUM(PPT.UI_SAL_AMT)
, PPT.WAI_ORGANIZATION_ID
, PPT.WAI_CATEGORY
, SUM(PPT.WAI_SAL_AMT)
FROM PAY_JP_PRE_TAX PPT
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
WHERE PPA.ACTION_TYPE IN ('R'
, 'Q'
, 'B'
, 'I')
AND PAA.PAYROLL_ACTION_ID=PPA.PAYROLL_ACTION_ID
AND PPA.ACTION_STATUS='C'
AND PPT.ASSIGNMENT_ACTION_ID=PAA.ASSIGNMENT_ACTION_ID
AND PPT.ACTION_STATUS='C'
AND PPT.SALARY_CATEGORY IN ('SALARY'
, 'BONUS'
, 'SP_BONUS')
AND NOT EXISTS( SELECT NULL
FROM PAY_PAYROLL_ACTIONS PPA2
, PAY_ASSIGNMENT_ACTIONS PAA2
, PAY_ACTION_INTERLOCKS PAI
WHERE PAI.LOCKED_ACTION_ID=PAA.ASSIGNMENT_ACTION_ID
AND PAA2.ASSIGNMENT_ACTION_ID=PAI.LOCKING_ACTION_ID
AND PPA2.PAYROLL_ACTION_ID=PAA2.PAYROLL_ACTION_ID
AND PPA2.ACTION_TYPE='V') GROUP BY PPT.SALARY_CATEGORY
, TO_CHAR(PPA.EFFECTIVE_DATE
, 'YYYYMM')
, PPA.BUSINESS_GROUP_ID
, PAA.ASSIGNMENT_ID
, PPT.UI_ORGANIZATION_ID
, PPT.UI_CATEGORY
, PPT.WAI_ORGANIZATION_ID
, PPT.WAI_CATEGORY