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 940: FROM gl_periods

936: l_partial_period VARCHAR2(1) := 'N';
937:
938: CURSOR cal_periods IS
939: SELECT MIN(start_date) start_date, MAX(end_date) end_date
940: FROM gl_periods
941: WHERE period_set_name = p_period_set_name
942: AND start_date <= p_vr_term_date
943: AND period_type = p_period_type
944: AND period_year >= TO_NUMBER(TO_CHAR(TO_DATE(p_vr_comm_date1,'DD/MM/RRRR'),'RRRR'))

Line 950: FROM gl_periods

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

Line 961: FROM gl_periods

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

Line 973: FROM gl_periods g1, gl_periods g2

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

Line 989: FROM gl_periods g1, gl_periods g2

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

Line 1006: FROM gl_periods

1002: ORDER BY 1;
1003:
1004: CURSOR group_date_ann IS
1005: SELECT MIN(start_date) start_date,MAX(end_date) end_date
1006: FROM gl_periods
1007: WHERE period_set_name = p_period_set_name
1008: AND start_date <= p_vr_term_date
1009: AND end_date >= p_vr_comm_date
1010: AND period_type = p_period_type

Line 1140: FROM gl_periods

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

Line 1151: FROM gl_periods

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

Line 6488: FROM gl_periods

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

Line 6499: FROM gl_periods

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

Line 6511: FROM gl_periods g1, gl_periods g2

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

Line 6527: FROM gl_periods g1, gl_periods g2

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

Line 6544: FROM gl_periods

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

Line 7123: FROM gl_periods

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

Line 7189: FROM gl_periods

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

Line 7200: FROM gl_periods

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

Line 7212: FROM gl_periods g1, gl_periods g2

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

Line 7228: FROM gl_periods g1, gl_periods g2

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

Line 7245: FROM gl_periods

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