APPS.GHR_MASS_AWARDS_ELIG dependencies on GHR_MASS_AWARD_CRITERIA_COLS

Line 133: from ghr_mass_award_criteria_cols col,

129:
130: Cursor c_asg_values is
131: select val.relational_operator,
132: val.value
133: from ghr_mass_award_criteria_cols col,
134: ghr_mass_award_criteria_vals val
135: Where col.table_name = 'ASSIGNMENT'
136: and col.column_name = 'Organization'
137: and val.mass_award_id = p_mass_award_id

Line 259: from ghr_mass_award_criteria_cols col,

255: select val.relational_operator,
256: val.value,
257: col.table_name,
258: col.column_name
259: from ghr_mass_award_criteria_cols col,
260: ghr_mass_award_criteria_vals val
261: Where val.mass_award_id = p_mass_award_id
262: and col.table_name = 'POSITION_KFF'
263: and val.mass_award_criteria_col_id = col.mass_award_criteria_col_id

Line 269: from ghr_mass_award_criteria_cols col,

265: Select val.relational_operator,
266: val.value,
267: col.table_name,
268: col.column_name
269: from ghr_mass_award_criteria_cols col,
270: ghr_mass_award_criteria_vals val
271: Where val.mass_award_id = p_mass_award_id
272: and col.table_name = 'JOB_KFF'
273: and val.mass_award_criteria_col_id = col.mass_award_criteria_col_id

Line 407: from ghr_mass_award_criteria_cols col,

403: Cursor c_pos_grp2_values is
404: Select val.relational_operator,
405: val.value,
406: col.column_name
407: from ghr_mass_award_criteria_cols col,
408: ghr_mass_award_criteria_vals val
409: Where val.mass_award_id = p_mass_award_id
410: and col.table_name = 'POSITION_EXTRA_INFO'
411: and val.mass_award_criteria_col_id = col.mass_award_criteria_col_id

Line 480: from ghr_mass_award_criteria_cols col,

476: Cursor c_pos_grp1_values is
477: Select val.relational_operator,
478: val.value,
479: col.column_name
480: from ghr_mass_award_criteria_cols col,
481: ghr_mass_award_criteria_vals val
482: Where val.mass_award_id = p_mass_award_id
483: and col.table_name = 'POSITION_EXTRA_INFO'
484: and val.mass_award_criteria_col_id = col.mass_award_criteria_col_id

Line 574: from ghr_mass_award_criteria_cols col,

570: Cursor c_pos_grp1_values is
571: Select val.relational_operator,
572: val.value,
573: col.column_name
574: from ghr_mass_award_criteria_cols col,
575: ghr_mass_award_criteria_vals val
576: Where val.mass_award_id = p_mass_award_id
577: and col.table_name = 'POSITION_EXTRA_INFO'
578: and val.mass_award_criteria_col_id = col.mass_award_criteria_col_id

Line 661: from ghr_mass_award_criteria_cols col,

657: Cursor c_loc_ddf_values is
658: Select val.relational_operator,
659: val.value,
660: col.column_name
661: from ghr_mass_award_criteria_cols col,
662: ghr_mass_award_criteria_vals val
663: Where val.mass_award_id = p_mass_award_id
664: and col.table_name = 'LOCATION_EXTRA_INFO'
665: and val.mass_award_criteria_col_id = col.mass_award_criteria_col_id

Line 735: from ghr_mass_award_criteria_cols col,

731: Cursor c_rating_values is
732: Select val.relational_operator,
733: val.value,
734: col.column_name
735: from ghr_mass_award_criteria_cols col,
736: ghr_mass_award_criteria_vals val
737: Where val.mass_award_id = p_mass_award_id
738: and col.table_name = 'PERSON_SIT'
739: and val.mass_award_criteria_col_id = col.mass_award_criteria_col_id