APPS.PAY_JP_ISDF_RPT dependencies on PAY_JP_ISDF_CALC_DCT_V

Line 496: from pay_jp_isdf_calc_dct_v pjicd

492: decode(pjicd.sp_other_income_calc, 0,null,pjicd.sp_other_income_calc) sp_other_income_calc,
493: decode(pjicd.sp_income_calc, 0,null,pjicd.sp_income_calc) sp_income_calc,
494: decode(pjicd.spouse_income, 0,null,pjicd.spouse_income) spouse_income,
495: decode(pjicd.spouse_deduction, 0,null,pjicd.spouse_deduction) spouse_deduction
496: from pay_jp_isdf_calc_dct_v pjicd
497: where pjicd.assignment_action_id=p_mag_asg_action_id
498: and pjicd.status <> 'D';
499: --
500: isdf_calc_c cur_isdf_calc%ROWTYPE;

Line 506: from pay_jp_isdf_calc_dct_v2 pjicd1

502: cursor cur_isdf_calc_new(p_mag_asg_action_id NUMBER)
503: is
504: select decode(pjicd1.care_med_new_ins_prem, 0,null,pjicd1.care_med_new_ins_prem) care_med_new_ins_prem,
505: decode(pjicd1.care_med_new_ins_calc_prem, 0,null,pjicd1.care_med_new_ins_calc_prem) care_med_new_ins_calc_prem
506: from pay_jp_isdf_calc_dct_v2 pjicd1
507: where pjicd1.assignment_action_id=p_mag_asg_action_id
508: and pjicd1.status <> 'D';
509: --
510: isdf_calc_new_c cur_isdf_calc_new%ROWTYPE;