DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_RPT dependencies on PAY_JP_ISDF_CALC_DCT_V2

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;