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_RENT_PKG dependencies on GL_PERIODS

Line 941: FROM gl_periods

937: l_partial_period VARCHAR2(1) := 'N';
938:
939: CURSOR cal_periods IS
940: SELECT MIN(start_date) start_date, MAX(end_date) end_date
941: FROM gl_periods
942: WHERE period_set_name = p_period_set_name
943: AND start_date <= p_vr_term_date
944: AND period_type = p_period_type
945: and start_date > p_vr_comm_date1

Line 952: FROM gl_periods

948: ORDER BY start_date;
949:
950: CURSOR group_date_mon IS
951: SELECT MIN(start_date) start_date, MAX(END_date) END_date
952: FROM gl_periods
953: WHERE period_set_name = p_period_set_name
954: AND start_date <= p_vr_term_date
955: AND end_date >= p_vr_comm_date
956: AND period_type = p_period_type

Line 963: FROM gl_periods

959: ORDER BY start_date,end_date;
960:
961: CURSOR group_date_qtr IS
962: SELECT MIN(start_date) start_date, MAX(end_date) end_date
963: FROM gl_periods
964: WHERE period_set_name = p_period_set_name
965: AND start_date <= p_vr_term_date
966: AND end_date >= p_vr_comm_date
967: AND quarter_num IN(1,2,3,4)

Line 975: FROM gl_periods g1, gl_periods g2

971:
972: CURSOR group_date_sa IS
973: SELECT MIN(g1.start_date) start_date
974: ,MAX(g2.end_date) end_date
975: FROM gl_periods g1, gl_periods g2
976: WHERE g1.period_set_name(+) = p_period_set_name
977: AND g2.period_set_name = p_period_set_name
978: AND g1.start_date(+) <= p_vr_term_date
979: AND g2.end_date >= p_vr_comm_date

Line 991: FROM gl_periods g1, gl_periods g2

987: GROUP BY g2.period_year
988: UNION
989: SELECT MIN(g1.start_date) start_date
990: ,MAX(g2.end_date) end_date
991: FROM gl_periods g1, gl_periods g2
992: WHERE g1.period_set_name(+) = p_period_set_name
993: AND g2.period_set_name = p_period_set_name
994: AND g1.start_date(+) <= p_vr_term_date
995: AND g2.end_date >= p_vr_comm_date

Line 1010: FROM gl_periods

1006: CURSOR group_date_ann IS
1007: --Fix for bug#13398393
1008: --SELECT MIN(start_date) start_date,MAX(end_date) end_date
1009: SELECT MIN(year_start_date) start_date,MAX(end_date) end_date
1010: FROM gl_periods
1011: WHERE period_set_name = p_period_set_name
1012: AND start_date <= p_vr_term_date
1013: AND end_date >= p_vr_comm_date
1014: AND period_type = p_period_type

Line 1144: FROM gl_periods

1140: -- Get dates from associated GL Calendar
1141:
1142: SELECT MIN(start_date), MAX(end_date)
1143: INTO p_cal_start_date, p_cal_end_date
1144: FROM gl_periods
1145: WHERE period_set_name = p_period_set_name
1146: AND period_type = p_period_type;
1147:
1148: ----------------------------------

Line 1155: FROM gl_periods

1151: IF (p_comm_date IS NOT NULL) THEN
1152:
1153: SELECT MIN(start_date), MAX(end_date)
1154: INTO p_cal_start_date, p_cal_end_date
1155: FROM gl_periods
1156: WHERE period_set_name = p_period_set_name
1157: AND period_type = p_period_type
1158: AND start_date >= p_comm_date
1159: AND end_date >= p_comm_date

Line 6492: FROM gl_periods

6488: x_return_message OUT NOCOPY VARCHAR2)
6489: IS
6490: CURSOR group_date_mon(p_vr_comm_date DATE, p_vr_term_date DATE) IS
6491: SELECT min(start_date) start_date, max(end_date) end_date
6492: FROM gl_periods
6493: WHERE period_set_name = p_pn_var_rent_dates_rec.gl_period_set_name
6494: AND start_date <= p_vr_term_date
6495: AND end_date >= p_vr_comm_date
6496: AND period_type = p_pn_var_rent_dates_rec.period_type

Line 6503: FROM gl_periods

6499: ORDER BY start_date,end_date;
6500:
6501: CURSOR group_date_qtr(p_vr_comm_date DATE, p_vr_term_date DATE)IS
6502: SELECT min(start_date) start_date, max(end_date) end_date
6503: FROM gl_periods
6504: WHERE period_set_name = p_pn_var_rent_dates_rec.gl_period_set_name
6505: AND start_date <= p_vr_term_date
6506: AND end_date >= p_vr_comm_date
6507: AND quarter_num IN(1,2,3,4)

Line 6515: FROM gl_periods g1, gl_periods g2

6511:
6512: CURSOR group_date_sa (p_vr_comm_date DATE, p_vr_term_date DATE) IS
6513: SELECT min(g1.start_date) start_date
6514: ,max(g2.end_date) end_date
6515: FROM gl_periods g1, gl_periods g2
6516: WHERE g1.period_set_name(+) = p_pn_var_rent_dates_rec.gl_period_set_name
6517: AND g2.period_set_name = p_pn_var_rent_dates_rec.gl_period_set_name
6518: AND g1.start_date(+) <= p_vr_term_date
6519: AND g2.end_date >= p_vr_comm_date

Line 6531: FROM gl_periods g1, gl_periods g2

6527: GROUP BY g2.period_year
6528: UNION
6529: SELECT min(g1.start_date) start_date
6530: ,max(g2.end_date) end_date
6531: FROM gl_periods g1, gl_periods g2
6532: WHERE g1.period_set_name(+) = p_pn_var_rent_dates_rec.gl_period_set_name
6533: AND g2.period_set_name = p_pn_var_rent_dates_rec.gl_period_set_name
6534: AND g1.start_date(+) <= p_vr_term_date
6535: AND g2.end_date >= p_vr_comm_date

Line 6548: FROM gl_periods

6544: order by 1;
6545:
6546: CURSOR group_date_ann (p_vr_comm_date DATE, p_vr_term_date DATE) IS
6547: SELECT min(start_date) start_date,max(end_date) end_date
6548: FROM gl_periods
6549: WHERE period_set_name = p_pn_var_rent_dates_rec.gl_period_set_name
6550: AND start_date <= p_vr_term_date
6551: AND end_date >= p_vr_comm_date
6552: AND period_type = p_pn_var_rent_dates_rec.period_type

Line 7127: FROM gl_periods

7123: p_end_date DATE) IS
7124: SELECT MIN(start_date) start_date,
7125: MAX(end_date) end_date ,
7126: period_year
7127: FROM gl_periods
7128: WHERE period_set_name = p_period_set_name
7129: AND period_type = p_period_type
7130: AND period_year >= TO_NUMBER(TO_CHAR(TO_DATE(p_end_date,'DD/MM/RRRR'),'RRRR'))
7131: AND period_year <= TO_NUMBER(TO_CHAR(TO_DATE(p_extension_end_date,'DD/MM/RRRR'),'RRRR'))

Line 7193: FROM gl_periods

7189: l_inv_end_date DATE ;
7190:
7191: CURSOR group_date_mon(p_vr_comm_date DATE, p_vr_term_date DATE) IS
7192: SELECT min(start_date) start_date, max(end_date) end_date
7193: FROM gl_periods
7194: WHERE period_set_name = p_pn_var_rent_dates_rec.gl_period_set_name
7195: AND start_date <= p_vr_term_date
7196: AND end_date >= p_vr_comm_date
7197: AND period_type = p_pn_var_rent_dates_rec.period_type

Line 7204: FROM gl_periods

7200: ORDER BY start_date,end_date;
7201:
7202: CURSOR group_date_qtr(p_vr_comm_date DATE, p_vr_term_date DATE)IS
7203: SELECT min(start_date) start_date, max(end_date) end_date
7204: FROM gl_periods
7205: WHERE period_set_name = p_pn_var_rent_dates_rec.gl_period_set_name
7206: AND start_date <= p_vr_term_date
7207: AND end_date >= p_vr_comm_date
7208: AND quarter_num IN(1,2,3,4)

Line 7216: FROM gl_periods g1, gl_periods g2

7212:
7213: CURSOR group_date_sa (p_vr_comm_date DATE, p_vr_term_date DATE) IS
7214: SELECT min(g1.start_date) start_date
7215: ,max(g2.end_date) end_date
7216: FROM gl_periods g1, gl_periods g2
7217: WHERE g1.period_set_name(+) = p_pn_var_rent_dates_rec.gl_period_set_name
7218: AND g2.period_set_name = p_pn_var_rent_dates_rec.gl_period_set_name
7219: AND g1.start_date(+) <= p_vr_term_date
7220: AND g2.end_date >= p_vr_comm_date

Line 7232: FROM gl_periods g1, gl_periods g2

7228: GROUP BY g2.period_year
7229: UNION
7230: SELECT min(g1.start_date) start_date
7231: ,max(g2.end_date) end_date
7232: FROM gl_periods g1, gl_periods g2
7233: WHERE g1.period_set_name(+) = p_pn_var_rent_dates_rec.gl_period_set_name
7234: AND g2.period_set_name = p_pn_var_rent_dates_rec.gl_period_set_name
7235: AND g1.start_date(+) <= p_vr_term_date
7236: AND g2.end_date >= p_vr_comm_date

Line 7249: FROM gl_periods

7245: order by 1;
7246:
7247: CURSOR group_date_ann (p_vr_comm_date DATE, p_vr_term_date DATE) IS
7248: SELECT min(start_date) start_date,max(end_date) end_date
7249: FROM gl_periods
7250: WHERE period_set_name = p_pn_var_rent_dates_rec.gl_period_set_name
7251: AND start_date <= p_vr_term_date
7252: AND end_date >= p_vr_comm_date
7253: AND period_type = p_pn_var_rent_dates_rec.period_type