eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 2183: pn_var_grp_dates_all grp

2179: ,grp.group_date
2180: ,grp.invoice_date
2181: ,grp.proration_factor
2182: FROM
2183: pn_var_grp_dates_all grp
2184: WHERE
2185: grp.period_id = p_prd_id
2186: ORDER BY
2187: grp.grp_start_date;

Line 2199: pn_var_grp_dates_all grp

2195: ,grp.group_date
2196: ,grp.invoice_date
2197: ,grp.proration_factor
2198: FROM
2199: pn_var_grp_dates_all grp
2200: ,pn_var_periods_all prd
2201: WHERE
2202: prd.period_id = p_prd_id AND
2203: grp.period_id = prd.period_id AND

Line 2942: pn_var_grp_dates_all grp

2938: SELECT
2939: grp.grp_start_date
2940: ,grp.grp_end_date
2941: FROM
2942: pn_var_grp_dates_all grp
2943: WHERE
2944: grp.grp_date_id = p_grp_id;
2945:
2946: l_grp_start_date DATE;

Line 3081: pn_var_grp_dates_all grp

3077: SELECT
3078: grp.grp_start_date
3079: ,grp.grp_end_date
3080: FROM
3081: pn_var_grp_dates_all grp
3082: WHERE
3083: grp.grp_date_id = p_grp_id;
3084:
3085: l_grp_start_date DATE;

Line 3952: pn_var_grp_dates_all grp

3948: SELECT
3949: grp.grp_start_date
3950: ,grp.grp_end_date
3951: FROM
3952: pn_var_grp_dates_all grp
3953: WHERE
3954: grp.grp_date_id = p_grp_id;
3955:
3956: l_grp_start_date DATE;

Line 4089: pn_var_grp_dates_all grp

4085: SELECT
4086: grp.grp_start_date
4087: ,grp.grp_end_date
4088: FROM
4089: pn_var_grp_dates_all grp
4090: WHERE
4091: grp.grp_date_id = p_grp_id;
4092:
4093: l_grp_start_date DATE;

Line 4526: pn_var_grp_dates_all grp

4522: SELECT
4523: grp.grp_start_date
4524: ,grp.grp_end_date
4525: FROM
4526: pn_var_grp_dates_all grp
4527: WHERE
4528: grp.grp_date_id = p_grp_id;
4529:
4530: l_grp_start_date DATE;

Line 4663: pn_var_grp_dates_all grp

4659: SELECT
4660: grp.grp_start_date
4661: ,grp.grp_end_date
4662: FROM
4663: pn_var_grp_dates_all grp
4664: WHERE
4665: grp.grp_date_id = p_grp_id;
4666:
4667: l_grp_start_date DATE;