APPS.IGS_PS_GEN_006 dependencies on IGS_OR_UNIT

Line 1139: v_ou_description IGS_OR_UNIT.description%TYPE;

1135: p_billing_hrs IN NUMBER )
1136: AS
1137: lv_param_values VARCHAR2(1080);
1138: v_ul_description IGS_PS_UNIT_LEVEL.description%TYPE;
1139: v_ou_description IGS_OR_UNIT.description%TYPE;
1140: v_uicl_description IGS_PS_UNIT_INT_LVL.description%TYPE;
1141: v_level_code IGS_PS_UNIT_TYPE_LVL.LEVEL_CODE%TYPE;
1142: v_repeat_code IGS_PS_RPT_FMLY_ALL.REPEAT_CODE%TYPE;
1143: v_subtitle IGS_PS_UNIT_SUBTITLE.SUBTITLE%TYPE;

Line 1151: cp_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE,

1147: SELECT description
1148: FROM IGS_PS_UNIT_LEVEL
1149: WHERE unit_level = cp_unit_level;
1150: CURSOR c_org_unit(
1151: cp_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE,
1152: cp_start_dt IGS_OR_UNIT.start_dt%TYPE) IS
1153: SELECT party_name description
1154: FROM IGS_OR_INST_ORG_BASE_V
1155: WHERE party_number = cp_org_unit_cd AND

Line 1152: cp_start_dt IGS_OR_UNIT.start_dt%TYPE) IS

1148: FROM IGS_PS_UNIT_LEVEL
1149: WHERE unit_level = cp_unit_level;
1150: CURSOR c_org_unit(
1151: cp_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE,
1152: cp_start_dt IGS_OR_UNIT.start_dt%TYPE) IS
1153: SELECT party_name description
1154: FROM IGS_OR_INST_ORG_BASE_V
1155: WHERE party_number = cp_org_unit_cd AND
1156: start_dt = cp_start_dt;