APPS.PA_SCHEDULE_PVT dependencies on PA_LOOKUPS

Line 8326: FROM pa_lookups

8322: l_current_value := v_c2.status_code;
8323: IF (l_previous_value <> l_current_value) THEN
8324: SELECT meaning
8325: INTO l_old_value_text
8326: FROM pa_lookups
8327: WHERE lookup_type = 'PA_SCH_UPDATE_TOP'
8328: AND lookup_code = 'PA_MULTIPLE';
8329: l_multiple := 'T';
8330: END IF;

Line 8349: FROM pa_lookups

8345: l_current_value := v_c2_current.status_code;
8346: IF (l_previous_value <> l_current_value) THEN
8347: SELECT meaning
8348: INTO l_old_value_text
8349: FROM pa_lookups
8350: WHERE lookup_type = 'PA_SCH_UPDATE_TOP'
8351: AND lookup_code = 'PA_MULTIPLE';
8352: l_multiple := 'T';
8353: END IF;

Line 8379: FROM pa_lookups

8375: v_c2.thu_hours||','||v_c2.fri_hours||','||v_c2.sat_hours||','||v_c2.sun_hours;
8376: IF (l_previous_value <> l_current_value) THEN
8377: SELECT meaning
8378: INTO l_old_value_text
8379: FROM pa_lookups
8380: WHERE lookup_type = 'PA_SCH_UPDATE_TOP'
8381: AND lookup_code = 'PA_MULTIPLE';
8382: l_multiple := 'T';
8383: END IF;

Line 8403: FROM pa_lookups

8399: v_c2_current.sun_hours;
8400: IF (l_previous_value <> l_current_value) THEN
8401: SELECT meaning
8402: INTO l_old_value_text
8403: FROM pa_lookups
8404: WHERE lookup_type = 'PA_SCH_UPDATE_TOP'
8405: AND lookup_code = 'PA_MULTIPLE';
8406: l_multiple := 'T';
8407: END IF;

Line 8420: FROM pa_lookups

8416: ELSIF p_exception_type_code = 'CHANGE_HOURS' THEN
8417: IF ( p_end_date - p_start_date > 7) THEN
8418: SELECT meaning
8419: INTO l_old_value_text
8420: FROM pa_lookups
8421: WHERE lookup_type = 'PA_SCH_UPDATE_TOP'
8422: AND lookup_code = 'PA_MULTIPLE';
8423:
8424: ELSE

Line 8502: FROM pa_lookups

8498:
8499: FOR i IN 1..total_nonzero-1 LOOP
8500: IF (change_hours_check(i) <>change_hours_check(0)) then
8501: SELECT meaning INTO l_old_value_text
8502: FROM pa_lookups
8503: WHERE lookup_type = 'PA_SCH_UPDATE_TOP'
8504: AND lookup_code = 'PA_MULTIPLE';
8505: EXIT;
8506: END IF;

Line 8844: FROM pa_lookups

8840:
8841: IF c1%NOTFOUND THEN
8842: SELECT meaning
8843: INTO l_result
8844: FROM pa_lookups
8845: WHERE lookup_type = 'CONFLICT_EXISTS'
8846: AND lookup_code = 'NO';
8847: RETURN(l_result);
8848: ELSE

Line 8851: FROM pa_lookups

8847: RETURN(l_result);
8848: ELSE
8849: SELECT meaning
8850: INTO l_result
8851: FROM pa_lookups
8852: WHERE lookup_type = 'CONFLICT_EXISTS'
8853: AND lookup_code = 'YES';
8854: RETURN(l_result);
8855: END IF;

Line 8897: FROM pa_lookups

8893: RETURN (NULL);
8894: ELSE
8895: SELECT meaning
8896: INTO l_result
8897: FROM pa_lookups
8898: WHERE lookup_type = 'RESOLVE_CONFLICTS_ACTION_CODE'
8899: AND lookup_code = v_c1.resolve_conflicts_action_code;
8900: RETURN (l_result);
8901: END IF;

Line 9000: FROM pa_lookups

8996: l_attribute_label VARCHAR2(30);
8997: BEGIN
8998: SELECT meaning
8999: INTO l_attribute_label
9000: FROM pa_lookups
9001: WHERE lookup_type = p_region_code
9002: AND lookup_code = p_attribute_code;
9003:
9004: RETURN l_attribute_label;