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.IGS_ST_GEN_003 dependencies on IGS_PE_STATISTICS

Line 1195: v_prior_post_grad IGS_PE_STATISTICS.prior_post_grad%TYPE;

1191: -- Derive the school leaver value
1192: -- DEETYA element 925
1193: DECLARE
1194: v_ret_val NUMBER(2) DEFAULT 1;
1195: v_prior_post_grad IGS_PE_STATISTICS.prior_post_grad%TYPE;
1196: v_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE;
1197: v_prior_subdeg_notafe IGS_PE_STATISTICS.prior_subdeg_notafe%TYPE;
1198: v_prior_subdeg_tafe IGS_PE_STATISTICS.prior_subdeg_tafe%TYPE;
1199: v_prior_tafe_award IGS_PE_STATISTICS.prior_tafe_award%TYPE;

Line 1196: v_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE;

1192: -- DEETYA element 925
1193: DECLARE
1194: v_ret_val NUMBER(2) DEFAULT 1;
1195: v_prior_post_grad IGS_PE_STATISTICS.prior_post_grad%TYPE;
1196: v_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE;
1197: v_prior_subdeg_notafe IGS_PE_STATISTICS.prior_subdeg_notafe%TYPE;
1198: v_prior_subdeg_tafe IGS_PE_STATISTICS.prior_subdeg_tafe%TYPE;
1199: v_prior_tafe_award IGS_PE_STATISTICS.prior_tafe_award%TYPE;
1200: v_prior_other_qual IGS_PE_STATISTICS.prior_other_qual%TYPE;

Line 1197: v_prior_subdeg_notafe IGS_PE_STATISTICS.prior_subdeg_notafe%TYPE;

1193: DECLARE
1194: v_ret_val NUMBER(2) DEFAULT 1;
1195: v_prior_post_grad IGS_PE_STATISTICS.prior_post_grad%TYPE;
1196: v_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE;
1197: v_prior_subdeg_notafe IGS_PE_STATISTICS.prior_subdeg_notafe%TYPE;
1198: v_prior_subdeg_tafe IGS_PE_STATISTICS.prior_subdeg_tafe%TYPE;
1199: v_prior_tafe_award IGS_PE_STATISTICS.prior_tafe_award%TYPE;
1200: v_prior_other_qual IGS_PE_STATISTICS.prior_other_qual%TYPE;
1201: v_prior_seced_school IGS_PE_STATISTICS.prior_seced_school%TYPE;

Line 1198: v_prior_subdeg_tafe IGS_PE_STATISTICS.prior_subdeg_tafe%TYPE;

1194: v_ret_val NUMBER(2) DEFAULT 1;
1195: v_prior_post_grad IGS_PE_STATISTICS.prior_post_grad%TYPE;
1196: v_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE;
1197: v_prior_subdeg_notafe IGS_PE_STATISTICS.prior_subdeg_notafe%TYPE;
1198: v_prior_subdeg_tafe IGS_PE_STATISTICS.prior_subdeg_tafe%TYPE;
1199: v_prior_tafe_award IGS_PE_STATISTICS.prior_tafe_award%TYPE;
1200: v_prior_other_qual IGS_PE_STATISTICS.prior_other_qual%TYPE;
1201: v_prior_seced_school IGS_PE_STATISTICS.prior_seced_school%TYPE;
1202: v_prior_seced_tafe IGS_PE_STATISTICS.prior_seced_tafe%TYPE;

Line 1199: v_prior_tafe_award IGS_PE_STATISTICS.prior_tafe_award%TYPE;

1195: v_prior_post_grad IGS_PE_STATISTICS.prior_post_grad%TYPE;
1196: v_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE;
1197: v_prior_subdeg_notafe IGS_PE_STATISTICS.prior_subdeg_notafe%TYPE;
1198: v_prior_subdeg_tafe IGS_PE_STATISTICS.prior_subdeg_tafe%TYPE;
1199: v_prior_tafe_award IGS_PE_STATISTICS.prior_tafe_award%TYPE;
1200: v_prior_other_qual IGS_PE_STATISTICS.prior_other_qual%TYPE;
1201: v_prior_seced_school IGS_PE_STATISTICS.prior_seced_school%TYPE;
1202: v_prior_seced_tafe IGS_PE_STATISTICS.prior_seced_tafe%TYPE;
1203: v_collection_yr VARCHAR2(4);

Line 1200: v_prior_other_qual IGS_PE_STATISTICS.prior_other_qual%TYPE;

1196: v_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE;
1197: v_prior_subdeg_notafe IGS_PE_STATISTICS.prior_subdeg_notafe%TYPE;
1198: v_prior_subdeg_tafe IGS_PE_STATISTICS.prior_subdeg_tafe%TYPE;
1199: v_prior_tafe_award IGS_PE_STATISTICS.prior_tafe_award%TYPE;
1200: v_prior_other_qual IGS_PE_STATISTICS.prior_other_qual%TYPE;
1201: v_prior_seced_school IGS_PE_STATISTICS.prior_seced_school%TYPE;
1202: v_prior_seced_tafe IGS_PE_STATISTICS.prior_seced_tafe%TYPE;
1203: v_collection_yr VARCHAR2(4);
1204: v_collection_yr_less1 VARCHAR2(4);

Line 1201: v_prior_seced_school IGS_PE_STATISTICS.prior_seced_school%TYPE;

1197: v_prior_subdeg_notafe IGS_PE_STATISTICS.prior_subdeg_notafe%TYPE;
1198: v_prior_subdeg_tafe IGS_PE_STATISTICS.prior_subdeg_tafe%TYPE;
1199: v_prior_tafe_award IGS_PE_STATISTICS.prior_tafe_award%TYPE;
1200: v_prior_other_qual IGS_PE_STATISTICS.prior_other_qual%TYPE;
1201: v_prior_seced_school IGS_PE_STATISTICS.prior_seced_school%TYPE;
1202: v_prior_seced_tafe IGS_PE_STATISTICS.prior_seced_tafe%TYPE;
1203: v_collection_yr VARCHAR2(4);
1204: v_collection_yr_less1 VARCHAR2(4);
1205: v_collection_yr_less2 VARCHAR2(4);

Line 1202: v_prior_seced_tafe IGS_PE_STATISTICS.prior_seced_tafe%TYPE;

1198: v_prior_subdeg_tafe IGS_PE_STATISTICS.prior_subdeg_tafe%TYPE;
1199: v_prior_tafe_award IGS_PE_STATISTICS.prior_tafe_award%TYPE;
1200: v_prior_other_qual IGS_PE_STATISTICS.prior_other_qual%TYPE;
1201: v_prior_seced_school IGS_PE_STATISTICS.prior_seced_school%TYPE;
1202: v_prior_seced_tafe IGS_PE_STATISTICS.prior_seced_tafe%TYPE;
1203: v_collection_yr VARCHAR2(4);
1204: v_collection_yr_less1 VARCHAR2(4);
1205: v_collection_yr_less2 VARCHAR2(4);
1206: CURSOR c_ps IS

Line 1215: FROM IGS_PE_STATISTICS ps

1211: ps.prior_tafe_award,
1212: ps.prior_other_qual,
1213: ps.prior_seced_school,
1214: ps.prior_seced_tafe
1215: FROM IGS_PE_STATISTICS ps
1216: WHERE ps.person_id = p_person_id AND
1217: TRUNC(ps.start_dt) <= TRUNC(SYSDATE) AND
1218: (ps.end_dt IS NULL OR
1219: TRUNC(ps.end_dt) >= TRUNC(SYSDATE))