APPS.PN_VAR_RENT_PKG dependencies on PN_VAR_DEDUCTIONS_ALL

Line 3147: FROM PN_VAR_DEDUCTIONS_ALL

3143: l_counter NUMBER := 0;
3144:
3145: CURSOR c1 is
3146: SELECT deduction_id
3147: FROM PN_VAR_DEDUCTIONS_ALL
3148: WHERE line_item_id = p_line_item_id;
3149:
3150: BEGIN
3151:

Line 4182: FROM pn_var_deductions_ALL

4178: SELECT 1
4179: INTO l_deduct_exist
4180: FROM dual
4181: WHERE EXISTS ( SELECT deduction_id
4182: FROM pn_var_deductions_ALL
4183: WHERE line_item_id = p_line_item_id
4184: );
4185:
4186: RETURN l_deduct_exist;

Line 7873: DELETE pn_var_deductions_all

7869: DELETE pn_var_bkpts_head_all
7870: WHERE bkhd_start_date > p_new_termn_date
7871: AND var_rent_id = p_var_rent_id;
7872:
7873: DELETE pn_var_deductions_all
7874: WHERE start_date > p_new_termn_date
7875: AND period_id IN (SELECT period_id
7876: FROM pn_var_periods_all
7877: WHERE var_rent_id = p_var_rent_id);

Line 8373: UPDATE pn_var_deductions_all

8369: X_LINE_ITEM_ID => rec.line_item_id,
8370: X_END_DATE => p_new_termn_date);
8371: END LOOP;
8372:
8373: UPDATE pn_var_deductions_all
8374: SET end_date = p_new_termn_date
8375: WHERE period_id = p_period_id
8376: AND p_new_termn_date BETWEEN start_date AND end_date;
8377:

Line 8768: DELETE pn_var_deductions_all

8764:
8765: DELETE pn_var_bkpts_head_all
8766: WHERE var_rent_id = p_var_rent_id;
8767:
8768: DELETE pn_var_deductions_all
8769: WHERE period_id IN (SELECT period_id
8770: FROM pn_var_periods_all
8771: WHERE var_rent_id = p_var_rent_id);
8772: