APPS.PN_VAR_TRX_PKG dependencies on PN_VAR_GRP_DATES_ALL

Line 1073: pn_var_grp_dates_all grp

1069: CURSOR grp_pro_factor_sum_c(p_prd_id IN NUMBER) IS
1070: SELECT
1071: SUM(grp.proration_factor) proration_factor_sum
1072: FROM
1073: pn_var_grp_dates_all grp
1074: WHERE
1075: prd.period_id = p_prd_id
1076: GROUP BY
1077: grp.period_id;

Line 1085: pn_var_grp_dates_all grp

1081: CURSOR grp_pro_factor_sum_c(p_prd_id IN NUMBER) IS
1082: SELECT
1083: SUM(grp.proration_factor) proration_factor_sum
1084: FROM
1085: pn_var_grp_dates_all grp
1086: ,pn_var_periods_all prd
1087: WHERE
1088: prd.period_id = p_prd_id AND
1089: grp.period_id = prd.period_id AND

Line 1129: ,pn_var_grp_dates_all grp

1125: ,grp.proration_factor AS grp_prorat_factor
1126: ,hdr.proration_factor AS calc_prd_prorat_factor
1127: FROM
1128: pn_var_trx_headers_all hdr
1129: ,pn_var_grp_dates_all grp
1130: WHERE
1131: hdr.var_rent_id = p_vr_id AND
1132: hdr.period_id = p_prd_id /*AND
1133: hdr.calc_prd_start_date = p_prd_st_dt*/ AND

Line 1147: ,pn_var_grp_dates_all grp

1143: ,grp.proration_factor AS grp_prorat_factor
1144: ,hdr.proration_factor AS calc_prd_prorat_factor
1145: FROM
1146: pn_var_trx_headers_all hdr
1147: ,pn_var_grp_dates_all grp
1148: WHERE
1149: hdr.var_rent_id = p_vr_id AND
1150: hdr.period_id = p_prd_id /*AND
1151: hdr.calc_prd_end_date = p_prd_end_dt*/ AND

Line 2272: pn_var_grp_dates_all grp

2268: ,grp.group_date
2269: ,grp.invoice_date
2270: ,grp.proration_factor
2271: FROM
2272: pn_var_grp_dates_all grp
2273: WHERE
2274: grp.period_id = p_prd_id
2275: ORDER BY
2276: grp.grp_start_date;

Line 2288: pn_var_grp_dates_all grp

2284: ,grp.group_date
2285: ,grp.invoice_date
2286: ,grp.proration_factor
2287: FROM
2288: pn_var_grp_dates_all grp
2289: ,pn_var_periods_all prd
2290: WHERE
2291: prd.period_id = p_prd_id AND
2292: grp.period_id = prd.period_id AND

Line 3032: pn_var_grp_dates_all grp

3028: SELECT
3029: grp.grp_start_date
3030: ,grp.grp_end_date
3031: FROM
3032: pn_var_grp_dates_all grp
3033: WHERE
3034: grp.grp_date_id = p_grp_id;
3035:
3036: l_grp_start_date DATE;

Line 3171: pn_var_grp_dates_all grp

3167: SELECT
3168: grp.grp_start_date
3169: ,grp.grp_end_date
3170: FROM
3171: pn_var_grp_dates_all grp
3172: WHERE
3173: grp.grp_date_id = p_grp_id;
3174:
3175: l_grp_start_date DATE;

Line 4042: pn_var_grp_dates_all grp

4038: SELECT
4039: grp.grp_start_date
4040: ,grp.grp_end_date
4041: FROM
4042: pn_var_grp_dates_all grp
4043: WHERE
4044: grp.grp_date_id = p_grp_id;
4045:
4046: l_grp_start_date DATE;

Line 4179: pn_var_grp_dates_all grp

4175: SELECT
4176: grp.grp_start_date
4177: ,grp.grp_end_date
4178: FROM
4179: pn_var_grp_dates_all grp
4180: WHERE
4181: grp.grp_date_id = p_grp_id;
4182:
4183: l_grp_start_date DATE;

Line 4616: pn_var_grp_dates_all grp

4612: SELECT
4613: grp.grp_start_date
4614: ,grp.grp_end_date
4615: FROM
4616: pn_var_grp_dates_all grp
4617: WHERE
4618: grp.grp_date_id = p_grp_id;
4619:
4620: l_grp_start_date DATE;

Line 4753: pn_var_grp_dates_all grp

4749: SELECT
4750: grp.grp_start_date
4751: ,grp.grp_end_date
4752: FROM
4753: pn_var_grp_dates_all grp
4754: WHERE
4755: grp.grp_date_id = p_grp_id;
4756:
4757: l_grp_start_date DATE;