APPS.PN_APPROVE_VARENT_PKG dependencies on PN_VAR_GRP_DATES_ALL

Line 915: UPDATE pn_var_grp_dates_all

911: WHERE var_rent_inv_id = p_var_rent_inv_id
912: AND true_up_exp_code IS NOT NULL;
913: /* pinky */
914:
915: UPDATE pn_var_grp_dates_all
916: SET forecasted_exp_code = decode(p_rent_type,'FORECASTED','Y',forecasted_exp_code),
917: actual_exp_code = decode(p_rent_type,'ACTUAL','Y',actual_exp_code),
918: variance_exp_code = decode(p_rent_type,'VARIANCE','Y',variance_exp_code),
919: last_update_date = SYSDATE,

Line 935: FROM pn_var_grp_dates_all

931: WHERE period_id = p_period_id
932: AND p_rent_type = 'FORECASTED'
933: AND grp_date_id IN
934: (SELECT grp_date_id
935: FROM pn_var_grp_dates_all
936: WHERE period_id = p_period_id
937: AND invoice_date = p_invoice_date
938: AND var_rent_id = p_var_rent_id);
939:

Line 953: FROM pn_var_grp_dates_all

949: AND vol_hist_status_code = 'APPROVED'
950: AND p_rent_type <> 'FORECASTED'
951: AND grp_date_id IN
952: (SELECT grp_date_id
953: FROM pn_var_grp_dates_all
954: WHERE period_id = p_period_id
955: AND invoice_date = p_invoice_date
956: AND var_rent_id = p_var_rent_id);
957:

Line 971: FROM pn_var_grp_dates_all

967: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
968: WHERE period_id = p_period_id
969: AND grp_date_id IN
970: (SELECT grp_date_id
971: FROM pn_var_grp_dates_all
972: WHERE period_id = p_period_id
973: AND invoice_date = p_invoice_date
974: AND var_rent_id = p_var_rent_id);
975: END IF;

Line 981: UPDATE pn_var_grp_dates_all

977: /* Special handling for period number 1 for FLY or FY agreement */
978: FOR rec IN period_FY_cur(p_period_id,p_var_rent_id)
979: LOOP
980:
981: UPDATE pn_var_grp_dates_all
982: SET forecasted_exp_code = decode(p_rent_type,'FORECASTED','Y',forecasted_exp_code),
983: actual_exp_code = decode(p_rent_type,'ACTUAL','Y',actual_exp_code),
984: variance_exp_code = decode(p_rent_type,'VARIANCE','Y',variance_exp_code),
985: last_update_date = SYSDATE,

Line 1002: FROM pn_var_grp_dates_all

998: AND vol_hist_status_code = 'APPROVED'
999: AND p_rent_type <> 'FORECASTED'
1000: AND grp_date_id IN
1001: (SELECT grp_date_id
1002: FROM pn_var_grp_dates_all
1003: WHERE period_id = p_period_id);
1004:
1005: UPDATE pn_var_deductions_all
1006: SET exported_code = 'Y',

Line 1014: FROM pn_var_grp_dates_all

1010: WHERE period_id = p_period_id
1011: AND p_rent_type <> 'FORECASTED'
1012: AND grp_date_id IN
1013: (SELECT grp_date_id
1014: FROM pn_var_grp_dates_all
1015: WHERE period_id = p_period_id);
1016:
1017:
1018: END LOOP;