eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_IWHT_ARCH_PKG dependencies on PAY_JP_PRE_TAX

Line 646: FROM pay_jp_pre_tax PPT,

642: (p_termination_date_from IS NULL AND p_termination_date_to IS NULL)) -- #Bug 9527179
643: AND TRUNC(NVL(PPS.actual_termination_date,p_effective_date)) BETWEEN PPF.effective_start_date AND PPF.effective_end_date
644: AND TRUNC(NVL(PPS.actual_termination_date,p_effective_date)) BETWEEN PAF.effective_start_date AND PAF.effective_end_date
645: AND EXISTS(SELECT 1
646: FROM pay_jp_pre_tax PPT,
647: pay_assignment_actions PAA,
648: pay_payroll_actions PPA
649: WHERE PPA.effective_date BETWEEN gd_ystart_date AND gd_yend_date
650: AND PAA.assignment_id = PAF.assignment_id

Line 699: FROM pay_jp_pre_tax PPT,

695: (p_termination_date_from IS NULL AND p_termination_date_to IS NULL)) -- #Bug 9527179
696: AND TRUNC(NVL(PPS.actual_termination_date,p_effective_date)) BETWEEN PPF.effective_start_date AND PPF.effective_end_date
697: AND TRUNC(NVL(PPS.actual_termination_date,p_effective_date)) BETWEEN PAF.effective_start_date AND PAF.effective_end_date
698: AND EXISTS(SELECT 1
699: FROM pay_jp_pre_tax PPT,
700: pay_assignment_actions PAA,
701: pay_payroll_actions PPA
702: WHERE PPA.effective_date BETWEEN gd_ystart_date AND gd_yend_date
703: AND PAA.assignment_id = PAF.assignment_id

Line 980: FROM pay_jp_pre_tax PPT,

976: AND PADC.address_type(+) = 'JP_C'
977: AND TRUNC(p_effective_date) BETWEEN TRUNC(NVL(PADC.date_from(+),p_effective_date)) AND NVL(PADC.date_to(+),TO_DATE('31/12/4712','DD/MM/YYYY')) --bug #9554515
978: AND PPS.period_of_service_id = NVL(PAF.period_of_service_id,PPS.period_of_service_id) -- #Bug 9569078
979: AND EXISTS(SELECT 1
980: FROM pay_jp_pre_tax PPT,
981: pay_assignment_actions PAA,
982: pay_payroll_actions PPA
983: WHERE PPA.effective_date BETWEEN gd_ystart_date AND gd_yend_date
984: AND PAA.assignment_id = PAF.assignment_id

Line 1038: FROM pay_jp_pre_tax PPT,

1034: SELECT NVL(sum(ppt.taxable_sal_amt + ppt.taxable_mat_amt), 0) termination_money
1035: ,NVL(sum(ppt.itax), 0) withholding_tax
1036: ,NVL(sum(ppt.sp_ltax_shi), 0) muncipal_tax -- Bug 9525922
1037: ,NVL(sum(ppt.sp_ltax_to), 0) prefectural_tax -- Bug 9525922
1038: FROM pay_jp_pre_tax PPT,
1039: pay_assignment_actions PAA,
1040: pay_payroll_actions PPA
1041: WHERE PPA.effective_date BETWEEN gd_ystart_date AND gd_yend_date
1042: AND PPA.business_group_id + 0 = p_business_group_id

Line 1066: FROM pay_jp_pre_tax PPT,

1062: IS
1063: SELECT PAA.assignment_action_id
1064: ,PPA.effective_date
1065: ,PPA.date_earned
1066: FROM pay_jp_pre_tax PPT,
1067: pay_assignment_actions PAA,
1068: pay_payroll_actions PPA
1069: WHERE PPA.effective_date BETWEEN gd_ystart_date AND gd_yend_date
1070: AND PPA.business_group_id + 0 = p_business_group_id