APPS.PN_VAR_RENT_PKG dependencies on PN_VAR_DEDUCTIONS_ALL

Line 3151: FROM PN_VAR_DEDUCTIONS_ALL

3147: l_counter NUMBER := 0;
3148:
3149: CURSOR c1 is
3150: SELECT deduction_id
3151: FROM PN_VAR_DEDUCTIONS_ALL
3152: WHERE line_item_id = p_line_item_id;
3153:
3154: BEGIN
3155:

Line 4186: FROM pn_var_deductions_ALL

4182: SELECT 1
4183: INTO l_deduct_exist
4184: FROM dual
4185: WHERE EXISTS ( SELECT deduction_id
4186: FROM pn_var_deductions_ALL
4187: WHERE line_item_id = p_line_item_id
4188: );
4189:
4190: RETURN l_deduct_exist;

Line 7879: DELETE pn_var_deductions_all

7875: DELETE pn_var_bkpts_head_all
7876: WHERE bkhd_start_date > p_new_termn_date
7877: AND var_rent_id = p_var_rent_id;
7878:
7879: DELETE pn_var_deductions_all
7880: WHERE start_date > p_new_termn_date
7881: AND period_id IN (SELECT period_id
7882: FROM pn_var_periods_all
7883: WHERE var_rent_id = p_var_rent_id);

Line 8383: UPDATE pn_var_deductions_all

8379: X_LINE_ITEM_ID => rec.line_item_id,
8380: X_END_DATE => p_new_termn_date);
8381: END LOOP;
8382:
8383: UPDATE pn_var_deductions_all
8384: SET end_date = p_new_termn_date
8385: WHERE period_id = p_period_id
8386: AND p_new_termn_date BETWEEN start_date AND end_date;
8387:

Line 8785: DELETE pn_var_deductions_all

8781:
8782: DELETE pn_var_bkpts_head_all
8783: WHERE var_rent_id = p_var_rent_id;
8784:
8785: DELETE pn_var_deductions_all
8786: WHERE period_id IN (SELECT period_id
8787: FROM pn_var_periods_all
8788: WHERE var_rent_id = p_var_rent_id);
8789: